{"id":20297,"date":"2013-05-10T12:49:02","date_gmt":"2013-05-10T07:19:02","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=20297"},"modified":"2024-04-12T14:16:40","modified_gmt":"2024-04-12T08:46:40","slug":"single-range-and-multiget-slice","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/","title":{"rendered":"Single, range and multiget slice"},"content":{"rendered":"

Certify and Increase Opportunity.<\/span>
\nBe <\/span>
\nGovt. Certified Apache Cassandra Professional
\n<\/span><\/a><\/p>\n

Single, range and multiget slice<\/p>\n

SLICE<\/strong><\/p>\n

A slice is a result of a query on the database. When querying a database i want to be able to ask something like.<\/p>\n

Give me the password of the user with the login name of loginname.<\/p>\n

When querying Cassandra a simple question like that is less simple from what you might expect.
\nThe way forward for me is using and setting a secondary index on a column.<\/p>\n

A secondary index is telling Cassandra to be prepared to answer simple questions like above.
\nNote that this feature is build in later so i expect that this is not the normal way of querying the database but for now i can create ColumnFamilies with indexed Columns.<\/p>\n

Create an indexed Column<\/span><\/p>\n

BasicColumnFamilyDefinition columnFamilyDefinition = new BasicColumnFamilyDefinition();
\ncolumnFamilyDefinition.setKeyspaceName(_keyspaceName);
\ncolumnFamilyDefinition.setName(_columnFamilyName);
\ncolumnFamilyDefinition.setKeyValidationClass(ComparatorType.UTF8TYPE.getClassName());<\/p>\n

\/\/ Create a column that can be queried by a secondary slice
\nBasicColumnDefinition bcd = new BasicColumnDefinition();
\nbcd.setName(StringSerializer.get().toByteBuffer(FIRSTNAME_COLUMN_NAME));
\nbcd.setIndexName(FIRSTNAME_COLUMN_NAME);
\nbcd.setValidationClass(“org.apache.cassandra.db.marshal.UTF8Type”);
\nbcd.setIndexType(ColumnIndexType.KEYS);
\ncolumnFamilyDefinition.addColumnDefinition(bcd);
\n\/\/ Persist or execute update on cassandra
\n_cluster.addColumnFamily(columnFamilyDefinition);<\/p>\n

Slice an indexed Column<\/span><\/p>\n

\/\/ Create the query object
\nIndexedSlicesQuery<String, String, byte[]> indexedSlicesQuery = HFactory.createIndexedSlicesQuery(_keyspace,
\nstringSerializer,stringSerializer, byteArraySerializer);<\/p>\n

\/\/ Query column family with name
\nindexedSlicesQuery.setColumnFamily(_columnFamilyName);
\n\/\/ Set the columns you want back
\nindexedSlicesQuery.setColumnNames(FIRSTNAME_COLUMN_NAME, MIDDLENAME_COLUMN_NAME,LASTNAME_COLUMN_NAME);
\n\/\/ A mandatory equals method. Find the firstname10 in column with name firstname
\nindexedSlicesQuery.addEqualsExpression(FIRSTNAME_COLUMN_NAME,stringSerializer.toBytes(“firstname10”));
\n\/\/ Do the query
\nQueryResult<OrderedRows<String, String, byte[]>> result = indexedSlicesQuery.execute();<\/p>\n

boolean found = false;
\n\/\/ result is ….
\nIterator<Row<String, String, byte[]>> queryResultIterator = result.get().iterator();<\/p>\n

while (queryResultIterator.hasNext()){
\n\/\/ fetch the result and translate the content of the column
\nRow<String, String, byte[]> queryRow= queryResultIterator.next();
\nString firstName = stringSerializer.fromBytes(
\nqueryRow.getColumnSlice().getColumnByName(“firstName”).getValue());
\nAssert.assertEquals(“Search string should match query string”, firstName , “firstname10”);
\nfound  = true;
\n}<\/p>\n

Range Slice<\/strong><\/p>\n

In Cassandra, rows are hash partitioned  by default. If you want to data sorted by some attribute, column name sorting feature of Cassandra is usually exploited. If you look at the Cassandra slice range API, you will find that you can specify only the range start, range end and an upper limit on the number of columns fetched.<\/p>\n

However in many applications the need is to paginate through the data i.e each call should fetch a predetermined number of items.<\/p>\n

The only option is to select a range such that that the number of items expected to return is far greater than the max limit. In this post I will discuss an adaptive range reader that I have implemented recently in agiato hosted on github. It borrows ideas from feedback control system to adaptively change the column range so that a predetermined number of items are returned.<\/p>\n

Listed below id the slice range constructor as defined. It gets used in the Cassandra API get_slice(). As you can tell, there is no way to set the appropriate range that will ensure the return of expected number of items.<\/p>\n

SliceRange(byte[] start, byte[] finish, boolean reversed, int count)<\/p>\n

The only thing you can do is to set start low enough and finish high enough, and hope  that the number of columns in that range is  greater than count, resulting in count number of items returned from the query. But, there is no guarantee and nobody likes hope based logic.<\/p>\n

Multiget Slice<\/strong><\/p>\n

With get_slice, user can fetch a set of column names for a single specified row key. But, multiget_slice can fetch a subset of columns for a set of row keys based on a column parent and a predicate. Thus by providing more than one row key, fetch the value of the named columns for each key. So a multiget slice is more than one named column for more than one row.<\/p>\n

\n

Apply for Apache Cassandra Certification Now!!<\/h3>\n

http:\/\/www.vskills.in\/certification\/Certified-Apache-Cassandra-Professional<\/a><\/p>\n

Go To Tutorial- Certified Apache Cassandra Professional Tutorial<\/strong><\/a><\/h5>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Certify and Increase Opportunity. Be Govt. Certified Apache Cassandra Professional Single, range and multiget slice SLICE A slice is a result of a query on the database. When querying a database i want to be able to ask something like. Give me the password of the user with the login name of loginname. When querying…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[63],"tags":[],"class_list":["post-20297","page","type-page","status-publish","hentry","category-apache-cassandra"],"acf":[],"yoast_head":"\nSingle, range and multiget slice - Tutorial<\/title>\n<meta name=\"description\" content=\"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Single, range and multiget slice - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:46:40+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/\",\"name\":\"Single, range and multiget slice - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-05-10T07:19:02+00:00\",\"dateModified\":\"2024-04-12T08:46:40+00:00\",\"description\":\"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Single, range and multiget slice\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Single, range and multiget slice - Tutorial","description":"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/","og_locale":"en_US","og_type":"article","og_title":"Single, range and multiget slice - Tutorial","og_description":"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:46:40+00:00","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/","name":"Single, range and multiget slice - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-05-10T07:19:02+00:00","dateModified":"2024-04-12T08:46:40+00:00","description":"Single, range and multiget slice. Vskills Government Certification in Apache Cassandra is very popular in India amongst developers working in the IT Bid data industry.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/single-range-and-multiget-slice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Single, range and multiget slice"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/20297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=20297"}],"version-history":[{"count":12,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/20297\/revisions"}],"predecessor-version":[{"id":122134,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/20297\/revisions\/122134"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=20297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=20297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=20297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}