{"id":543,"date":"2019-02-28T10:01:05","date_gmt":"2019-02-28T10:01:05","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=543"},"modified":"2024-04-04T08:33:17","modified_gmt":"2024-04-04T08:33:17","slug":"hadoop-hbase-test-case","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/","title":{"rendered":"Hadoop Hbase Test Case"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1104\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg\" alt=\"Hadoop HBase test case\" width=\"850\" height=\"315\" \/><\/p>\n<p>&nbsp;<\/p>\n<h1>Hadoop HBase test case<\/h1>\n<p>&nbsp;<\/p>\n<p><strong>Hadoop HBase test case<\/strong>, Welcome to the world of advanced Tutorials on Hadoop Hbase. Are you looking forward to the <a href=\"https:\/\/www.youtube.com\/watch?v=tI-6CVf7gME\">Hadoop HBase test case<\/a> Platform? Or looking for some help on the HBase client test case? Then you\u2019ve landed on the Right Path which providing advanced tutorial Based concepts on the Hadoop Hbase. In this tutorial, one can easily explore apache Hadoop Hbase test cases with step by step explanation.<\/p>\n<p>If you are the one who wanted to become an expert in <a href=\"https:\/\/prwatech.in\/hadoop-training-institute-in-bangalore\/\">Hadoop technology<\/a>? Or the one who wanted to explore the technology like a Pro under the certified experts with world-class classroom training environment, then asks your <a href=\"https:\/\/prwatech.in\/hadoop-training-institute-in-bangalore\/\">Hadoop Training institute<\/a> experts who offer Advanced advanced Hadoop training. Follow the below-mentioned Hadoop HBase test case tutorial and enhance your skills to become a professional <a href=\"https:\/\/prwatech.in\/hadoop-training-institute-in-bangalore\/\">Hadoop Developer<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em>Description: Creating an HBase table using below mentioned columnar family to store student information and creating student database.Using the hue tool for more detailed and structured data manipulation. \u00a0 <\/em><br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>For Student Record :<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-544\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-14.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"117\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-14.png 637w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-14-300x41.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Creating Table<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>We create table \u2018Prwatech\u2019 with column_family as Weekend_Joining, Weekdays_Joining, Weekend_demo, Weekdays_demo, Weekend_new, Weekdays_new<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-545\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-14.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"361\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-14.png 647w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-14-300x128.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Inserting Values<\/h3>\n<p>&nbsp;<\/p>\n<p><strong> In below-given case, we insert the value of two-row named as \u2018Bng_st1\u2019 and \u2018Pune_st1\u2019 in the column as Name, DOJ, Course, Status, and email id<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-546\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-13.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"532\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-13.png 625w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-13-300x188.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Scan<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Case 1: To scan the record of a particular row\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1346\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-22.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"244\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-22.png 616w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/1-22-300x86.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Case 2: To scan a particular record in the column of a row<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1347\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-22.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"92\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-22.png 627w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/2-22-300x33.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Case 3: To scan the record of two or more than two records in a column of a row<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1352\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-21.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"204\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-21.png 625w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/3-21-300x72.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1350\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-17.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"205\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-17.png 637w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-17-300x73.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Case 4: Scanning the record or other rows with column\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1351\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-18.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"164\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-18.png 639w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-18-300x58.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Display Table<\/h3>\n<p>&nbsp;<\/p>\n<p><strong> All the data inserted are shown in tabular form in columnar form.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-547\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-12.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"394\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-12.png 584w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/4-12-300x139.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Data Manipulation<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Using the hue tool we can represent our table in a more organized form.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Using the hue tool we can also update the values of the table.<\/strong><\/p>\n<p><strong>As shown below we have inserted the value for two columnar families:<\/strong><\/p>\n<p><strong>Weekend_Joining and Weekend_demo.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-548\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-13.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"406\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-13.png 596w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/5-13-300x143.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Finally, all data inserted into the table is displayed below :<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-549\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/6-13.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"456\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/6-13.png 520w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/6-13-300x161.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2>For Query<\/h2>\n<p>&nbsp;<\/p>\n<h3>Creating Table<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Similar to the above case we create a table \u2018Query\u2019<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-550\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/7-13.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"672\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/7-13.png 387w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/7-13-300x237.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>In hue it will look something like this\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-551\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/8-12.png\" alt=\"hadoop hbase testcase\" width=\"850\" height=\"459\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/8-12.png 641w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/02\/8-12-300x162.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/tI-6CVf7gME\" width=\"650\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>Hadoop Hbase test case 2<\/h2>\n<p>&nbsp;<\/p>\n<p><em><strong>Description:<\/strong> The basic objective of this project is to create a database for IPL player and their stats using HBase in such a way that we can easily extract data for a particular player on the basis of the column in a particular columnar family. Using this technique we can easily sort and extract data from our database using a particular column as reference.<\/em><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Prerequisites :<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p><strong>\u2666 Cloudera v5<br \/>\n<\/strong><\/p>\n<p><strong>\u2666 Eclipse on cloudera<\/strong><\/p>\n<p><strong>\u2666 HBase daemons running<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Create an HBase table for student query in such a way that it includes following columnar family<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Batsman<\/strong><\/p>\n<p><strong>Bowlers<\/strong><\/p>\n<p><strong>All-rounders<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>And add the following column in each column family as per query<\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Player id<\/strong><\/li>\n<li><strong>Jersey number<\/strong><\/li>\n<li><strong>Name<\/strong><\/li>\n<li><strong>DOB<\/strong><\/li>\n<li><strong>Handed<\/strong><\/li>\n<li><strong>Matches played<\/strong><\/li>\n<li><strong>Strike Rate <\/strong><\/li>\n<li><strong>Total Runs<\/strong><\/li>\n<li><strong>Country<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3>Some of the use case to extract data are mentioned below:<\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Players info from a particular country<\/strong><\/li>\n<li><strong>Players info with particular Jersey Number<\/strong><\/li>\n<li><strong>Run scored by a player between particular player id<\/strong><\/li>\n<li><strong>Players info which is left-handed<\/strong><\/li>\n<li><strong>Players from a particular country which are left-handed<\/strong><\/li>\n<li><strong>Players from a particular country with their strike rate<\/strong><\/li>\n<li><strong>Total match played for particular jersey number<\/strong><\/li>\n<li><strong>Info of player using DOB<\/strong><\/li>\n<li><strong>Total run of the player using Player ID<\/strong><\/li>\n<li><strong>Runs scored by Right-Handed players<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>Hadoop HBase Test case Solution<\/h2>\n<p>&nbsp;<\/p>\n<p><strong>Create Ipl stats Database<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1482\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/Capture.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"557\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/Capture.png 643w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/Capture-300x196.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Data Source<\/strong><\/p>\n<p>https:<a href=\"https:\/\/drive.google.com\/file\/d\/1rFQzqbS6CEqrM0TMrDMQBEP4sRm1yoCc\/view?usp=sharing\">\/\/drive.google.com\/file\/d\/1rFQzqbS6CEqrM0TMrDMQBEP4sRm1yoCc\/view?usp=sharing<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Move the above database in HDFS<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1474\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-8.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"144\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-8.png 643w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-8-300x51.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Create a table with following the columnar family in HBase<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1476\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-5.png\" alt=\"Hadoop HBase testcase 2\" width=\"596\" height=\"105\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-5.png 596w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-5-300x53.png 300w\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Move bulk data from HDFS into HBase<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1477\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-2.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"96\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-2.png 646w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-2-300x34.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Data after loading into HBase<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1479\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-3.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"590\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-3.png 789w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-3-300x208.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-3-768x533.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1480\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/81.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"614\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/81.png 789w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/81-300x217.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/81-768x555.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1481\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/91.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"342\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/91.png 785w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/91-300x121.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/91-768x309.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Hbase Test Case Examples<\/h2>\n<p>&nbsp;<\/p>\n<p><strong>1: Player&#8217;s info from the particular country: \u00a0<\/strong>Sorting players on the basis of their respective country.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;country&#8217;,=,&#8217;binary:India&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1483\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-12.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"546\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-12.png 645w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-12-300x193.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1484\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-9.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"516\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-9.png 648w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-9-300x182.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1485\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-7.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"549\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-7.png 646w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-7-300x194.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1486\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-6.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"176\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-6.png 644w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-6-300x62.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>2: Players info with particular Jersey Number:\u00a0<\/strong>Finding info about Players on the basis of their jersey Number<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;jersy_no&#8217;,=,&#8217;binary:18&#8242;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1487\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-13.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"413\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-13.png 646w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-13-300x146.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>3: Run scored by a player between particular player id:\u00a0<\/strong>Sorting players on the basis of run scored using player id<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command :<\/strong> scan &#8216;iplstat&#8217;,{COLUMN=&gt;&#8217;Batsman:total_runs&#8217;,LIMIT=&gt;9,STARTROW=&gt;&#8217;7&#8242;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1488\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-14.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"237\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-14.png 642w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-14-300x84.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>4: Players info which is left-handed:<\/strong> Finding player info on the basis of their batting hand<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command :<\/strong> scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;handed&#8217;,=,&#8217;binary:Left-handbat&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1489\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-15.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"439\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-15.png 646w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-15-300x155.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>5: Players from a particular country which are left-handed:\u00a0<\/strong>Finding info about a player on the basis of their country and Left-handed batting<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;country&#8217;,=,&#8217;binary:India&#8217;) AND SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;handed&#8217;,=,&#8217;binary:Left-handbat&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1490\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-16.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"469\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-16.png 647w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-16-300x166.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>6: Players from a particular country with their strike rate:\u00a0<\/strong>Finding the strike rate of players on the basis of their country.<strong><br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;country&#8217;,=,&#8217;binary:India&#8217;) AND QualifierFilter(=,&#8217;binary:strike_rate&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1491\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-17.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"171\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-17.png 803w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-17-300x61.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-17-768x155.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>7: Total match played for particular jersey number:\u00a0<\/strong>Finding total match played by the player on the basis of their jersey number<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;jersy_no&#8217;,=,&#8217;binary:7&#8242;) AND QualifierFilter(=,&#8217;binary:matches_played&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1492\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-18.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"104\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-18.png 806w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-18-300x37.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-18-768x94.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>8: Info of player using DOB:\u00a0<\/strong>Finding information about player on the basis of their DOB (Date of Birth)<strong><br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command :<\/strong> scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;dob&#8217;,=,&#8217;binary:12\/12\/1981&#8242;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1493\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-19.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"229\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-19.png 803w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-19-300x81.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-19-768x207.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>9: Total run of the player using Player name:\u00a0<\/strong>Using player name o find total run scored by him.<strong><br \/>\n<\/strong><\/p>\n<p><strong>Command :<\/strong> scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;name&#8217;,=,&#8217;binary:VKohli&#8217;) AND QualifierFilter(=,&#8217;binary:total_runs&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1494\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-20.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"101\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-20.png 809w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-20-300x36.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-20-768x91.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>10: Runs scored and name of all Right Handed players:\u00a0<\/strong>Finding the run scored and name for all right-handed players.<\/p>\n<p><strong>Command<\/strong> : scan &#8216;iplstat&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Batsman&#8217;,&#8217;handed&#8217;,=,&#8217;binary:Right-handbat&#8217;) AND MultipleColumnPrefixFilter(&#8216;name&#8217;,&#8217;total_runs&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1495\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-21.png\" alt=\"Hadoop HBase testcase 2\" width=\"850\" height=\"444\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-21.png 806w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-21-300x157.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-21-768x401.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Hadoop Hbase test case 3<\/h2>\n<p>&nbsp;<\/p>\n<p><em><strong>Description:<\/strong> The basic objective of this project is to create a student database using HBase in such a way that we can easily extract data for a particular student on the basis of the column in particular columnar family. Using this technique we can easily sort and extract data from our database using a particular column as a reference.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>Prerequisites :<\/h2>\n<p><strong>\u2666 Cloudera v5<\/strong><\/p>\n<p><strong>\u2666 Eclipse on Cloudera<\/strong><\/p>\n<p><strong>\u2666 HBase daemons running<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Create an HBase table for student query in such a way that it includes following columnar family :<\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Weekdays_query<\/strong><\/li>\n<li><strong>Weekend_query<\/strong><\/li>\n<li><strong>Weekdays_demo<\/strong><\/li>\n<li><strong>Weekend_demo<\/strong><\/li>\n<li><strong>Weekdays_joining<\/strong><\/li>\n<li><strong>Weekend_joining<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3>And add the following column in each column family as per query :<\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Student id<\/strong><\/li>\n<li><strong>Date of Query (DOQ)<\/strong><\/li>\n<li><strong>Name<\/strong><\/li>\n<li><strong>Contact number<\/strong><\/li>\n<li><strong>Email id<\/strong><\/li>\n<li><strong>Course<\/strong><\/li>\n<li><strong>Location<\/strong><\/li>\n<li><strong>Status<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3><strong>Some of the use cases to extract data are mentioned below:<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Total number of Query for Particular date: <\/strong>Sorting student on the basis of the DOQ.<\/li>\n<li><strong>Name of student between particular id:\u00a0Sorting<\/strong> Student on the basis of id and course.<\/li>\n<li><strong>Student details using particular student Id:<\/strong> Sorting Student on the basis of student Id.<\/li>\n<li><strong>Student details for the particular course:<\/strong> Sorting Students on the basis of their choice of course.<\/li>\n<li><strong>Student details using status:<\/strong> Sorting Students on the basis of their status.<\/li>\n<li><strong>Name of student between particular id for a particular course: Sorting<\/strong> Student on the basis of id and course.<\/li>\n<li><strong>A student enrolled for the demo: <\/strong>Sorting Student on the basis of the demo scheduled.<\/li>\n<li><strong>A student not confirmed for the session:<\/strong> Sorting Student on the basis of the status of not joining or no response.<\/li>\n<li><strong>Student query for Pune\/Bangalore location:<\/strong> Sorting Student on the basis of location.<\/li>\n<li><strong>Student name and email info using student ID:<\/strong> Sorting Student on the basis of missing email info.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>Hadoop HBase Test case Solution<\/h2>\n<p>&nbsp;<\/p>\n<h3><strong>\u00a0Create a student database<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1434\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"49\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1.png 656w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1-300x17.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Data source: <a href=\"https:\/\/drive.google.com\/open?id=1zVkg6_4matUGYfFA5Kkb9ao983lbrUyg\">https:\/\/drive.google.com\/open?id=1zVkg6_4matUGYfFA5Kkb9ao983lbrUyg<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Move the above database in HDFS<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1435\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"531\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-1.png 658w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-1-300x187.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Create a table with following the columnar family in HBase<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1434\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"49\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1.png 656w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-1-300x17.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Move bulk data from HDFS into HBase<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1436\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"114\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-1.png 658w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-1-300x40.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Data after loading into HBase<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1437\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"496\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-1.png 642w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-1-300x175.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1438\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/6-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"499\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/6-1.png 646w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/6-1-300x176.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1439\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-2.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"495\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-2.png 640w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-2-300x175.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1440\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/8-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"549\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/8-1.png 641w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/8-1-300x194.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1441\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/9-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"498\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/9-1.png 643w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/9-1-300x176.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1444\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-1.png\" alt=\"\" width=\"650\" height=\"307\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-1.png 650w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-1-300x142.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1445\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"222\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-1.png 647w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-1-300x78.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1442\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"549\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-1.png 643w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-1-300x194.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1443\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-1.png\" alt=\"Hadoop HBase Testcase 3\" width=\"850\" height=\"120\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-1.png 644w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-1-300x42.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Using HBase Shell :<\/h3>\n<p>&nbsp;<\/p>\n<h2>Hbase Test case Examples<\/h2>\n<p>&nbsp;<\/p>\n<p>1: <span style=\"text-decoration: underline;\"><strong>Total number of Query for Particular date: <\/strong><\/span>Sorting student on the basis of the DOQ.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Command<\/span>:<\/strong> scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;DOQ&#8217;,=,&#8217;binary:1stFeb&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1446\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-1.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"470\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-1.png 647w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-1-300x166.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1447\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-2.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"235\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>2:<\/strong> <strong><span style=\"text-decoration: underline;\">Name of student\u00a0 between particular id<\/span>:\u00a0 <\/strong>Sorting Student on the basis of id and course<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Command<\/span> :<\/strong> scan &#8216;Prwatech&#8217;,{COLUMN=&gt;&#8217;Weekdays_query:name&#8217;,LIMIT=&gt;7, STARTROW=&gt;&#8217;3&#8242;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1448\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-2.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"310\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>3: <span style=\"text-decoration: underline;\">Student details using particular student Id:<\/span><\/strong> Sorting Student on the basis of student Id.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Command<\/span> :<\/strong> scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;(PrefixFilter(&#8216;4&#8217;))&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1449\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"293\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>4:<\/strong> <span style=\"text-decoration: underline;\"><strong>Student details for the particular course:<\/strong><\/span> Sorting Students on the basis of their choice of course.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Command<\/span> :<\/strong> scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;course&#8217;,=,&#8217;binary:Hadoop&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1450\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"265\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1451\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"377\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1452\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-2.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"397\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>5:<\/strong> <span style=\"text-decoration: underline;\"><strong>Student details using status:<\/strong><\/span> Sorting Students on the basis of their status.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command <\/strong>: hbase(main):008:0&gt; scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;status&#8217;,=,&#8217;binary:Joining&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1453\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-5.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"359\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1454\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"380\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1455\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"343\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1456\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-2.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"396\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>6: <span style=\"text-decoration: underline;\">Name of student between particular id for a particular course:<\/span> Sorting<\/strong> Student on the basis of id and course.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Command: <\/strong><\/span>scan &#8216;Prwatech&#8217;,{COLUMN=&gt;&#8217;Weekdays_query:course&#8217;,LIMIT=&gt;7, STARTROW=&gt;&#8217;3&#8242;,FILTER=&gt;&#8221;ValueFilter(=,&#8217;binary:Hadoop&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1457\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-6.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"179\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>7:<\/strong> <span style=\"text-decoration: underline;\"><strong>Student enrolled for the demo: <\/strong><\/span>Sorting Student on the basis of demo scheduled.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Command:<\/strong> \u00a0scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;status&#8217;,=,&#8217;binary:Need Demo&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1458\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-7.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"353\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1459\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-5.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"413\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1460\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"411\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1461\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"66\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>8:<\/strong> <span style=\"text-decoration: underline;\"><strong>Student not confirmed for Session:<\/strong><\/span> Sorting Student on the basis of the status of not joining or no response.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Command<\/span>:<\/strong> scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;status&#8217;,=,&#8217;binary:Not confirm&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1462\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-8.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"323\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1463\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-6.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"202\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>9: <span style=\"text-decoration: underline;\">Student query for Pune\/Bangalore location:<\/span><\/strong> Sorting Student on the basis of location.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Command:<\/strong><\/span> hbase(main):014:0&gt; scan &#8216;Prwatech&#8217;,{FILTER=&gt;&#8221;SingleColumnValueFilter(&#8216;Weekdays_query&#8217;,&#8217;location&#8217;,=,&#8217;binary:Pune&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1464\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-9.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"360\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1465\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-7.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"411\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1466\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-5.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"412\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1467\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"83\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>10:<\/strong>\u00a0<span style=\"text-decoration: underline;\"><strong>Student name and email info using student ID:<\/strong><\/span> Sorting Student on the basis of missing email info.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Command<\/strong> <\/span>: scan &#8216;Prwatech&#8217;,{COLUMN=&gt;&#8217;Weekdays_query&#8217;,STARTROW=&gt;&#8217;3&#8242;,LIMIT=&gt;5,FILTER=&gt;&#8221;MultipleColumnPrefixFilter(&#8216;name&#8217;,&#8217;emailid&#8217;)&#8221;}<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1468\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-10.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"391\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Using Eclipse :<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Case 1: Total number of Query for Particular date: Sorting student on the basis of the DOQ.<br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;DOQ&#8221;) , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;1stFeb&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>&nbsp;<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1534\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/1-23.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"241\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Case 2: Name of student between particular id:\u00a0Sorting Student on the basis of id and course.<br \/>\n<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.KeyValue<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.client.Get<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.BinaryComparator<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.InclusiveStopFilter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.PrefixFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.RegexStringComparator<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.SubstringComparator<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.CompareFilter<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.Filter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.QualifierFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.FamilyFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.FilterList<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.ValueFilter<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> <u>com.sun.imageio.plugins.png.RowFilter<\/u>;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> <u>java.util.ArrayList<\/u>;<\/p>\n<p><strong>import<\/strong> <u>java.util.List<\/u>;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> Gaprow{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>Scan <u>scan<\/u> = <strong>new<\/strong> Scan();<\/p>\n<p>Filter filter1 = <strong>new<\/strong> InclusiveStopFilter(Bytes.<em>toBytes<\/em>(&#8220;7&#8221;));<\/p>\n<p>Scan scan1 = <strong>new<\/strong> Scan();<\/p>\n<p>scan1.setStartRow(Bytes.<em>toBytes<\/em>(&#8220;4&#8221;));<\/p>\n<p>scan1.setFilter(filter1);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan1);<\/p>\n<p><strong>for<\/strong> (Result result : scanner) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner.close();<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan1);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner1.next(); result != <strong>null<\/strong>; result = scanner1.next())<\/p>\n<p>&nbsp;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1535\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/2-11.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"270\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1536\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/3-9.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"123\" \/><\/p>\n<h3><strong>Case 3: Student details using particular student Id: Sorting Student on the basis of student Id.<br \/>\n<\/strong><\/h3>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.KeyValue;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.client.Get<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.BinaryComparator<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.PrefixFilter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.RegexStringComparator<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.SubstringComparator<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.CompareFilter<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.Filter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.QualifierFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.FamilyFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.FilterList<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.ValueFilter<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> <u>com.sun.imageio.plugins.png.RowFilter<\/u>;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> <u>java.util.ArrayList<\/u>;<\/p>\n<p><strong>import<\/strong> <u>java.util.List<\/u>;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> Rowfilter{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>Scan <u>scan<\/u> = <strong>new<\/strong> Scan();<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Filter filter = <strong>new<\/strong> PrefixFilter(Bytes.<em>toBytes<\/em>(&#8220;4&#8221;));<\/p>\n<p>Scan scan1 = <strong>new<\/strong> Scan();<\/p>\n<p>scan1.setFilter(filter);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan1);<\/p>\n<p><strong>for<\/strong> (Result result : scanner) {<\/p>\n<p><strong>for<\/strong> (KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner.close();<\/p>\n<p>&nbsp;<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan1);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner1.next(); result != <strong>null<\/strong>; result = scanner1.next())<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1537\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/4-8.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"136\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Case 4: <\/strong><strong>Student details for the particular course:<\/strong> Sorting Students on the basis of their choice of course.<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;course&#8221;)\u00a0 , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;Hadoop&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>&nbsp;<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1538\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/5-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"288\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1539\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/6-4.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"89\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4><strong>Case 5 : <\/strong><strong>Student details using status:<\/strong> Sorting Student on the basis of their status.<\/h4>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;status&#8221;) , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;Joining&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>&nbsp;<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1540\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/7-5.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"268\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1541\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/8-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"205\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Case 6 : <\/strong><strong>Name of student between particular id for a particular course: Sorting<\/strong> Student on the basis of id and course.<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.KeyValue<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.client.Get<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.BinaryComparator<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.InclusiveStopFilter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.PrefixFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.RegexStringComparator<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SubstringComparator;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.Filter;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.QualifierFilter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>org.apache.hadoop.hbase.filter.FamilyFilter<\/u>;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.FilterList;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.ValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> <u>com.sun.imageio.plugins.png.RowFilter<\/u>;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> java.util.ArrayList;<\/p>\n<p><strong>import<\/strong> java.util.List;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> Multifilter{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>Scan <u>scan<\/u> = <strong>new<\/strong> Scan();<\/p>\n<p>List&lt;Filter&gt; filters = <strong>new<\/strong> ArrayList&lt;Filter&gt;();<\/p>\n<p>Filter filter1 = <strong>new<\/strong> ValueFilter(CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>,<\/p>\n<p><strong>new<\/strong> SubstringComparator(&#8220;Hadoop&#8221;));<\/p>\n<p>&nbsp;<\/p>\n<p>filters.add(filter1);<\/p>\n<p>Filter filter2 = <strong>new<\/strong> InclusiveStopFilter(Bytes.<em>toBytes<\/em>(&#8220;7&#8221;));<\/p>\n<p>Scan scan1 = <strong>new<\/strong> Scan();<\/p>\n<p>scan1.setStartRow(Bytes.<em>toBytes<\/em>(&#8220;3&#8221;));<\/p>\n<p>filters.add(filter2);<\/p>\n<p>FilterList fl = <strong>new<\/strong> FilterList( FilterList.Operator.<strong><em>MUST_PASS_ALL<\/em><\/strong>,filters);<\/p>\n<p>scan1.setFilter(fl);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan1);<\/p>\n<p><strong>for<\/strong> (Result result : scanner) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner.close();<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan1);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner1.next(); result != <strong>null<\/strong>; result = scanner1.next())<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1542\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/9-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"133\" \/><\/p>\n<h3><strong>Case 7 : <\/strong><strong>Student enrolled for the demo: <\/strong>Sorting Student on the basis of demo scheduled.<\/h3>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;status&#8221;) , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;Need Demo&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>&nbsp;<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>&nbsp;<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<h3>\/\/closing the scanner<\/h3>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1543\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"389\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-3.png 627w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/10-3-300x137.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1544\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"309\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-3.png 495w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/11-3-300x109.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Case 8 : <\/strong><strong>Student not confirmed for the session:<\/strong> Sorting Student on the basis of the status of not joining or no response.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;status&#8221;)\u00a0 , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;Not confirm&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>&nbsp;<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<h3>\/\/ Reading values from the scan result<\/h3>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1545\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"304\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-3.png 631w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/12-3-300x107.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Case 9 : <strong>Student query for Pune\/Bangalore location:<\/strong> Sorting Student on the basis of location.<\/p>\n<p><strong>package<\/strong> com.test.ap;<\/p>\n<p><strong>import<\/strong> java.io.IOException;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.conf.Configuration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.HBaseConfiguration;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.util.Bytes;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.HTable;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Result;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.ResultScanner;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.client.Scan;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.SingleColumnValueFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.CompareFilter;<\/p>\n<p><strong>import<\/strong> org.apache.hadoop.hbase.filter.BinaryComparator;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.applicationdiscovery.model.Filter<\/u>;<\/p>\n<p><strong>import<\/strong> <u>com.amazonaws.services.elasticmapreduce.model.KeyValue<\/u>;<\/p>\n<p><strong>public<\/strong> <strong>class<\/strong> ScanTable{<\/p>\n<p><strong>public<\/strong> <strong>static<\/strong> <strong>void<\/strong> main(String args[]) <strong>throws<\/strong> IOException{<\/p>\n<p>\/\/ Instantiating Configuration class<\/p>\n<p>Configuration config = HBaseConfiguration.<em>create<\/em>();<\/p>\n<p>\/\/ Instantiating HTable class<\/p>\n<p>HTable <u>table<\/u> = <strong>new<\/strong> <span style=\"text-decoration: line-through;\"><u>HTable<\/u><\/span><u>(<\/u><u>config<\/u><u>, <\/u><u>&#8220;Prwatech&#8221;<\/u><u>)<\/u>;<\/p>\n<p>\/\/ Instantiating the Scan class<\/p>\n<p>Scan scan = <strong>new<\/strong> Scan();<\/p>\n<p>SingleColumnValueFilter filter = <strong>new<\/strong> SingleColumnValueFilter(Bytes.<em>toBytes<\/em>(&#8220;Weekdays_query&#8221;), Bytes.<em>toBytes<\/em>(&#8220;location&#8221;) , CompareFilter.CompareOp.<strong><em>EQUAL<\/em><\/strong>, <strong>new<\/strong> BinaryComparator(Bytes.<em>toBytes<\/em>(&#8220;Pune&#8221;)));<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner = table.getScanner(scan);<\/p>\n<p>\/\/ Reading values from the scan result<\/p>\n<p><strong>for<\/strong> (Result result = scanner.next(); result != <strong>null<\/strong>; result = scanner.next())<\/p>\n<p>&nbsp;<\/p>\n<p>scan.setFilter(filter);<\/p>\n<p>ResultScanner scanner1 = table.getScanner(scan);<\/p>\n<p><strong>for<\/strong> (Result result : scanner1) {<\/p>\n<p><strong>for<\/strong> (org.apache.hadoop.hbase.KeyValue kv : result.<span style=\"text-decoration: line-through;\"><u>raw<\/u><\/span><u>()<\/u>) {<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;KV: &#8221; + kv + &#8220;, Value: &#8221; +<\/p>\n<p>Bytes.<em>toString<\/em>(kv.<span style=\"text-decoration: line-through;\"><u>getValue<\/u><\/span><u>()<\/u>));<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>scanner1.close();<\/p>\n<p>String result = <strong>null<\/strong>;<\/p>\n<p>System.<strong><em>out<\/em><\/strong>.println(&#8220;Found row : &#8221; + result);<\/p>\n<p>\/\/closing the scanner<\/p>\n<p>scanner1.close();<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1546\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-3.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"343\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-3.png 639w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/13-3-300x121.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1547\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/14-2.png\" alt=\"Hadoop HBase testcase 3 tutorial\" width=\"850\" height=\"482\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/14-2.png 483w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/04\/14-2-300x170.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; Hadoop HBase test case &nbsp; Hadoop HBase test case, Welcome to the world of advanced Tutorials on Hadoop Hbase. Are you looking forward to the Hadoop HBase test case Platform? Or looking for some help on the HBase client test case? Then you\u2019ve landed on the Right Path which providing advanced tutorial Based [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,1645],"tags":[276,1838,1837,1835,1836],"class_list":["post-543","post","type-post","status-publish","format-standard","hentry","category-hadoop","category-hbase","tag-hadoop-hbase-test-case","tag-hadoop-hbase-test-case-with-examples","tag-how-to-load-test-hbase-with-jmeter","tag-how-to-mock-an-hbase-connection-unit-testing","tag-how-to-test-hbase-applications-using-popular-tools"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech<\/title>\n<meta name=\"description\" content=\"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech\" \/>\n<meta property=\"og:description\" content=\"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-28T10:01:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-04T08:33:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"30 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/\",\"url\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/\",\"name\":\"Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg\",\"datePublished\":\"2019-02-28T10:01:05+00:00\",\"dateModified\":\"2024-04-04T08:33:17+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg\",\"width\":828,\"height\":315},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hadoop Hbase Test Case\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech","description":"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech","og_description":"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech","og_url":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2019-02-28T10:01:05+00:00","article_modified_time":"2024-04-04T08:33:17+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"30 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/","url":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/","name":"Hadoop Hbase test case with examples | Apache hbase tutorial | Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg","datePublished":"2019-02-28T10:01:05+00:00","dateModified":"2024-04-04T08:33:17+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Explore Hadoop Hbase test case tutorial with detailed information, one can Learn Advanced Tutorials on Hadoop Hbase test case with examples from Prwatech","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/03\/3.jpg","width":828,"height":315},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/hadoop\/hbase\/hadoop-hbase-test-case\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Hadoop Hbase Test Case"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":17,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/543\/revisions"}],"predecessor-version":[{"id":11273,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/543\/revisions\/11273"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}