Sunday, May 31, 2015

Hadoop Learning Resources - updated as on 26-Jul-2015

http://ercoppa.github.io/HadoopInternals/AnatomyMapReduceJob.html#maptask-spilling

HDFS Architecture:
https://hadoop.apache.org/docs/current2/hadoop-project-dist/hadoop-hdfs/HdfsDesign.html
http://www.edureka.co/blog/hadoop-interview-questions-hdfs-2/
http://blog.cloudera.com/blog/2009/08/hadoop-default-ports-quick-reference/



HDFS Shell commands
http://www.thegeekstuff.com/2015/02/hadoop-command-reference/



HBase Architecture

HBase shell commands

Hive
http://thriveschool.blogspot.in/search/label/Hive%20Tutorial
http://www.edureka.co/blog/hive-commands/


Pig

Sqoop
http://hadooped.blogspot.in/2013/05/apache-sqoop-for-data-integration.html

NoSQL – Cassandra

mongodb definitive guide – second edition

NoSQL – CouchDB


NoSQL – Redis
http://www.pdfiles.com/pdf/files/English/Databases/Seven_Databases_In_Seven_Weeks.pdf

NoSQL - Neo4j
http://neo4j.com/docs/stable/cypher-getting-started.html
http://assets.neo4j.org/download/Neo4j_CheatSheet_v3.pdf
http://www.tutorialspoint.com/neo4j/index.htm
https://www.airpair.com/neo4j/posts/getting-started-with-neo4j-and-cypher

Data Science
http://www.datasciencecentral.com/profiles/blogs/66-job-interview-questions-for-data-scientists


Certification Guide:http://marksbiblog.com/how-i-passed-ccd-410-cloudera-certified-developer-for-apache-hadoop-ccdh/
http://www.pantz.org/software/hadoop/cloudera_certified_administrator_for_apache_hadoop_ccah_study_guide.html


Interview preparation:
http://myhadoopguide.blogspot.in/
http://www.slideshare.net/rohitkapa/hadoop-interview-questions
http://www.dezyre.com/article/top-50-hadoop-interview-questions-/92
http://sivasoft-interview-questions.blogspot.in/p/hadoop-interview-questions.html
http://hadoopiq.blogspot.in/2014/08/100-top-hadoop-interview-questions-and.html
http://www.wiziq.com/blog/31-questions-for-hadoop-developers/

http://www.slideshare.net/pappupassindia/hadoop-interview-question?qid=37fd34d3-b5ae-414f-8239-30c43373eacd&v=qf1&b=&from_search=7

http://www.slideshare.net/vemularavi17/hadoop-interview-quations1?qid=37fd34d3-b5ae-414f-8239-30c43373eacd&v=default&b=&from_search=24

Sample Hadoop resume
http://www.slideshare.net/PankajKumar524/pankaj-resume-for-hadoopjavaj2ee-outside-world?qid=37fd34d3-b5ae-414f-8239-30c43373eacd&v=default&b=&from_search=22

Tuesday, May 26, 2015

HBase Shell Commands

ram@ram-pc:~$ start-hbase.sh

starting master, logging to /usr/lib/hbase/hbase-1.0.1.1//logs/hbase-ram-master-ram-pc.out

ram@ram-pc:~$ hbase shell

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/lib/hbase/hbase-1.0.1.1/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
2015-05-27 08:31:20,911 WARN  [main] util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
HBase Shell; enter 'help<RETURN>' for list of supported commands.
Type "exit<RETURN>" to leave the HBase Shell
Version 1.0.1.1, re1dbf4df30d214fca14908df71d038081577ea46, Sun May 17 12:34:26 PDT 2015

hbase(main):002:0> status 'summary'
1 servers, 0 dead, 3.0000 average load

hbase(main):003:0> status 'detailed'
version 1.0.1.1
0 regionsInTransition
master coprocessors: []
1 live servers
    ram-pc:37709 1432695633622
        requestsPerSecond=0.0, numberOfOnlineRegions=3, usedHeapMB=21, maxHeapMB=908, numberOfStores=6, numberOfStorefiles=7, storefileUncompressedSizeMB=0, storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0, readRequestsCount=12, writeRequestsCount=2, rootIndexSizeKB=0, totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0, currentCompactedKVs=0, compactionProgressPct=NaN, coprocessors=[]
        "employee,,1432311600131.7506fab2a734ae625c0327ab735c35b8."
            numberOfStores=4, numberOfStorefiles=4, storefileUncompressedSizeMB=0, storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0, readRequestsCount=0, writeRequestsCount=0, rootIndexSizeKB=0, totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0, currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1, dataLocality=0.0
        "hbase:meta,,1"
            numberOfStores=1, numberOfStorefiles=2, storefileUncompressedSizeMB=0, storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0, readRequestsCount=8, writeRequestsCount=2, rootIndexSizeKB=0, totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0, currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1, dataLocality=0.0
        "hbase:namespace,,1432310126720.f752353aa49e17b5d25d0792dc84e87d."
            numberOfStores=1, numberOfStorefiles=1, storefileUncompressedSizeMB=0, storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0, readRequestsCount=4, writeRequestsCount=0, rootIndexSizeKB=0, totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0, currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1, dataLocality=0.0
0 dead servers


hbase(main):004:0> version
1.0.1.1, re1dbf4df30d214fca14908df71d038081577ea46, Sun May 17 12:34:26 PDT 2015

hbase(main):005:0> whoami
ram (auth:SIMPLE)
    groups: ram, adm, cdrom, sudo, dip, plugdev, lpadmin, sambashare

hbase(main):006:0> list
TABLE                                                                                                                                          
employee                                                                                                                                       
1 row(s) in 0.0720 seconds

=> ["employee"]
hbase(main):007:0> describe 'employee'

 
Table employee is ENABLED                                                                                                                      
employee                                                                                                                                       
COLUMN FAMILIES DESCRIPTION                                                                                                                    
{NAME => '1', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE',
IN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                   
{NAME => 'misc', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '3', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                
{NAME => 'personal', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}            
{NAME => 'professional', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '1',
TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}        
4 row(s) in 0.1570 seconds

hbase(main):001:0> is_enabled 'employee'
true                                                                                                                                           
0 row(s) in 0.3260 seconds

hbase(main):002:0> is_disabled 'employee'
false                                                                                                                                          
0 row(s) in 0.0320 seconds

hbase(main):003:0> exists 'employee'
Table employee does exist                                                                                                                      
0 row(s) in 0.0240 seconds
 

hbase(main):005:0> disable 'employee'
0 row(s) in 1.4030 seconds

hbase(main):006:0> disable_all 'emp.*'
employee                                                                                                                                       

Disable the above 1 tables (y/n)?
y
1 tables successfully disabled

hbase(main):007:0> enable_all 'emp.*'
employee                                                                                                                                       

Enable the above 1 tables (y/n)?
y
1 tables successfully enabled

scan

Here is some help for this command:
Scan a table; pass table name and optionally a dictionary of scanner
specifications.  Scanner specifications may include one or more of:
TIMERANGE, FILTER, LIMIT, STARTROW, STOPROW, TIMESTAMP, MAXLENGTH,
or COLUMNS, CACHE or RAW, VERSIONS

Some examples:

  hbase> scan 'hbase:meta'
  hbase> scan 'hbase:meta', {COLUMNS => 'info:regioninfo'}
  hbase> scan 'ns1:t1', {COLUMNS => ['c1', 'c2'], LIMIT => 10, STARTROW => 'xyz'}
  hbase> scan 't1', {COLUMNS => ['c1', 'c2'], LIMIT => 10, STARTROW => 'xyz'}
  hbase> scan 't1', {COLUMNS => 'c1', TIMERANGE => [1303668804, 1303668904]}
  hbase> scan 't1', {REVERSED => true}
  hbase> scan 't1', {FILTER => "(PrefixFilter ('row2') AND
    (QualifierFilter (>=, 'binary:xyz'))) AND (TimestampsFilter ( 123, 456))"}
  hbase> scan 't1', {FILTER =>
    org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(1, 0)}
  hbase> scan 't1', {CONSISTENCY => 'TIMELINE'}
For setting the Operation Attributes
  hbase> scan 't1', { COLUMNS => ['c1', 'c2'], ATTRIBUTES => {'mykey' => 'myvalue'}}
  hbase> scan 't1', { COLUMNS => ['c1', 'c2'], AUTHORIZATIONS => ['PRIVATE','SECRET']}
For experts, there is an additional option -- CACHE_BLOCKS -- which
switches block caching for the scanner on (true) or off (false).  By
default it is enabled

hbase(main):005:0> scan 'hbase:meta'
ROW                                   COLUMN+CELL                                                                                              
 employee,,1432311600131.7506fab2a734 column=info:regioninfo, timestamp=1432311600249, value={ENCODED => 7506fab2a734ae625c0327ab735c35b8, NAME
 ae625c0327ab735c35b8.                => 'employee,,1432311600131.7506fab2a734ae625c0327ab735c35b8.', STARTKEY => '', ENDKEY => ''}            
 employee,,1432311600131.7506fab2a734 column=info:seqnumDuringOpen, timestamp=1432696316738, value=\x00\x00\x00\x00\x00\x00\x00\x5C            
 ae625c0327ab735c35b8.                                                                                                                         
 employee,,1432311600131.7506fab2a734 column=info:server, timestamp=1432696316738, value=ram-pc:37709                                          
 ae625c0327ab735c35b8.                                                                                                                         
 employee,,1432311600131.7506fab2a734 column=info:serverstartcode, timestamp=1432696316738, value=1432695633622                                
 ae625c0327ab735c35b8.                                                                                                                         
 hbase:namespace,,1432310126720.f7523 column=info:regioninfo, timestamp=1432310126980, value={ENCODED => f752353aa49e17b5d25d0792dc84e87d, NAME
 53aa49e17b5d25d0792dc84e87d.         => 'hbase:namespace,,1432310126720.f752353aa49e17b5d25d0792dc84e87d.', STARTKEY => '', ENDKEY => ''}     
 hbase:namespace,,1432310126720.f7523 column=info:seqnumDuringOpen, timestamp=1432695646741, value=\x00\x00\x00\x00\x00\x00\x00\x18            
 53aa49e17b5d25d0792dc84e87d.                                                                                                                  
 hbase:namespace,,1432310126720.f7523 column=info:server, timestamp=1432695646741, value=ram-pc:37709                                          
 53aa49e17b5d25d0792dc84e87d.                                                                                                                  
 hbase:namespace,,1432310126720.f7523 column=info:serverstartcode, timestamp=1432695646741, value=1432695633622                                
 53aa49e17b5d25d0792dc84e87d.                                                                                                                  
2 row(s) in 0.0590 seconds


hbase(main):006:0> scan 'hbase:meta', {COLUMNS => 'info:regioninfo'}
ROW                                   COLUMN+CELL                                                                                              
 employee,,1432311600131.7506fab2a734 column=info:regioninfo, timestamp=1432311600249, value={ENCODED => 7506fab2a734ae625c0327ab735c35b8, NAME
 ae625c0327ab735c35b8.                => 'employee,,1432311600131.7506fab2a734ae625c0327ab735c35b8.', STARTKEY => '', ENDKEY => ''}            
 hbase:namespace,,1432310126720.f7523 column=info:regioninfo, timestamp=1432310126980, value={ENCODED => f752353aa49e17b5d25d0792dc84e87d, NAME
 53aa49e17b5d25d0792dc84e87d.         => 'hbase:namespace,,1432310126720.f752353aa49e17b5d25d0792dc84e87d.', STARTKEY => '', ENDKEY => ''}     
2 row(s) in 0.0360 seconds

hbase(main):007:0> scan 'hbase:meta', {COLUMNS => 'info:server'}
ROW                                   COLUMN+CELL                                                                                              
 employee,,1432311600131.7506fab2a734 column=info:server, timestamp=1432696316738, value=ram-pc:37709                                          
 ae625c0327ab735c35b8.                                                                                                                         
 hbase:namespace,,1432310126720.f7523 column=info:server, timestamp=1432695646741, value=ram-pc:37709                                          
 53aa49e17b5d25d0792dc84e87d.                                                                                                                  
2 row(s) in 0.0230 seconds



hbase(main):001:0> scan 'employee'
ROW                                   COLUMN+CELL                                                                                              
 1                                    column=misc:col1, timestamp=1432313857498,value=value1                                                  
 1                                    column=misc:col2, timestamp=1432313863008,value=value2                                                  
 1                                    column=misc:col3, timestamp=1432313868349,value=value3                                                  
 1                                    column=misc:col4, timestamp=1432313875047,value=value4                                                  
 1                                    column=misc:col5, timestamp=1432313880371,value=value5                                                  
 1                                    column=personal:city, timestamp=1432311813313,value=chennai                                             
 1                                    column=personal:education, timestamp=1432311804632,value=mca                                            
 1                                    column=personal:empno, timestamp=1432311778356,value=1001                                               
 1                                    column=personal:name, timestamp=1432311793553,value=ramkumar                                            
 1                                    column=professional:branch, timestamp=1432311870738,value=chennai                                       
 1                                    column=professional:dept, timestamp=1432311879711,value=gmot                                            
 1                                    column=professional:organization, timestamp=1432311857369,value=bankofamerica                           
 2                                    column=personal:city, timestamp=1432313374307,value=nj                                                  
 2                                    column=personal:education, timestamp=1432313389299,value=MS                                             
 2                                    column=personal:empno, timestamp=1432313401126,value=1002                                               
 2                                    column=personal:name, timestamp=1432313411542,value=karthik                                             
 2                                    column=professional:branch, timestamp=1432313435759,value=nj                                            
 2                                    column=professional:dept, timestamp=1432313445589, value=gritt       

hbase(main):015:0> scan 'employee', {COLUMNS => ['personal:name', 'professional:dept']}
ROW                                   COLUMN+CELL                                                                                              
 1                                    column=personal:name, timestamp=1432311793553,value=ramkumar                                            
 1                                    column=professional:dept, timestamp=1432311879711,value=gmot                                            
 2                                    column=personal:name, timestamp=1432313411542,value=karthik                                             
 2                                    column=professional:dept, timestamp=1432313445589,value=gritt                                           
2 row(s) in 0.0380 seconds


hbase(main):006:0> scan 'employee', {COLUMNS => ['personal:name'], LIMIT => 1, STARTROW => '2'}
ROW                                   COLUMN+CELL                                                                                              
 2                                    column=personal:name, timestamp=1432313411542, value=karthik  

hbase(main):012:0> scan 'employee', {COLUMNS => 'personal:name', TIMERANGE => [1432311804632, 1432313857498]}
ROW                                   COLUMN+CELL                                                                                              
 2                                    column=personal:name, timestamp=1432313411542, value=karthik    



hbase(main):019:0> drop 'employee'

ERROR: Table employee is enabled. Disable it first.

Here is some help for this command:
Drop the named table. Table must first be disabled:
  hbase> drop 't1'
  hbase> drop 'ns1:t1'


hbase(main):020:0> disable 'employee'
0 row(s) in 1.3280 seconds

hbase(main):021:0> drop 'employee'
0 row(s) in 0.2700 seconds


hbase(main):017:0> create 'sales', 'product_details', 'order_details'
0 row(s) in 0.5620 seconds
=> Hbase::Table - sales

hbase(main):018:0> describe 'sales'
Table sales is ENABLED                                                                                                                         
sales                                                                                                                                          
COLUMN FAMILIES DESCRIPTION                                                                                                                    
{NAME => 'order_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}       
{NAME => 'product_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}     
2 row(s) in 0.0510 seconds

 

hbase(main):042:0> create 'sales', 'product_details', 'order_details'
0 row(s) in 0.4680 seconds

=> Hbase::Table - sales


hbase(main):043:0> desc 'sales'
Table sales is ENABLED                                                                                                                         
sales                                                                                                                                          
COLUMN FAMILIES DESCRIPTION                                                                                                                    
{NAME => 'order_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE',
 MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}       
{NAME => 'product_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE
', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}     
2 row(s) in 0.0330 seconds

hbase(main):044:0> put 'sales', '1', 'product_details:product_id', 'P1001'
0 row(s) in 0.0190 seconds

hbase(main):045:0>  put 'sales', '1', 'product_details:product_name', 'APPLE IPAD'
0 row(s) in 0.0110 seconds

hbase(main):046:0> put 'sales', '1', 'product_details:product_price', '35000'
0 row(s) in 0.0110 seconds

hbase(main):047:0> put 'sales', '1', 'order_details:order_id', 'O5001'
0 row(s) in 0.0290 seconds

hbase(main):048:0> put 'sales', '1', 'order_details:cust_id', 'C7001'
0 row(s) in 0.0150 seconds

hbase(main):049:0> put 'sales', '1', 'order_details:ord_qty', '20'
0 row(s) in 0.0120 seconds

hbase(main):050:0> put 'sales', '2', 'product_details:product_id', 'P1002'
0 row(s) in 0.0060 seconds

hbase(main):051:0>  put 'sales', '2', 'product_details:product_name', 'I10 CAR'
0 row(s) in 0.0060 seconds

hbase(main):052:0> put 'sales', '2', 'product_details:product_price', '535000'
0 row(s) in 0.0060 seconds

hbase(main):053:0> put 'sales', '2', 'order_details:order_id', 'O5002'
0 row(s) in 0.0050 seconds

hbase(main):054:0> put 'sales', '2', 'order_details:cust_id', 'C7004'
0 row(s) in 0.0040 seconds

hbase(main):055:0> put 'sales', '2', 'order_details:ord_qty', '4'
0 row(s) in 0.0050 seconds

hbase(main):056:0> scan 'sales'
ROW                                   COLUMN+CELL                                                                                              
 1                                    column=order_details:cust_id, timestamp=1432700173670,value=C7001                                       
 1                                    column=order_details:ord_qty, timestamp=1432700186023,value=20                                          
 1                                    column=order_details:order_id, timestamp=1432700162924,value=O5001                                      
 1                                    column=product_details:product_id, timestamp=1432700115374,value=P1001                                  
 1                                    column=product_details:product_name, timestamp=1432700124398, value=APPLEIPAD                           
 1                                    column=product_details:product_price, timestamp=1432700132634,value=35000                               
 2                                    column=order_details:cust_id, timestamp=1432700302696,value=C7004                                       
 2                                    column=order_details:ord_qty, timestamp=1432700315227,value=4                                           
 2                                    column=order_details:order_id, timestamp=1432700283486,value=O5002                                      
 2                                    column=product_details:product_id, timestamp=1432700237200,value=P1002                                  
 2                                    column=product_details:product_name, timestamp=1432700255326, value=I10CAR                              
 2                                    column=product_details:product_price, timestamp=1432700270345,value=535000                              
2 row(s) in 0.0410 seconds


get help

  hbase> get 'ns1:t1', 'r1'
  hbase> get 't1', 'r1'
  hbase> get 't1', 'r1', {TIMERANGE => [ts1, ts2]}
  hbase> get 't1', 'r1', {COLUMN => 'c1'}
  hbase> get 't1', 'r1', {COLUMN => ['c1', 'c2', 'c3']}
  hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}
  hbase> get 't1', 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2], VERSIONS => 4}
  hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1, VERSIONS => 4}
  hbase> get 't1', 'r1', {FILTER => "ValueFilter(=, 'binary:abc')"}
  hbase> get 't1', 'r1', 'c1'
  hbase> get 't1', 'r1', 'c1', 'c2'
  hbase> get 't1', 'r1', ['c1', 'c2']
  hbase> get 't1', 'r1', {COLUMN => 'c1', ATTRIBUTES => {'mykey'=>'myvalue'}}
  hbase> get 't1', 'r1', {COLUMN => 'c1', AUTHORIZATIONS => ['PRIVATE','SECRET']}
  hbase> get 't1', 'r1', {CONSISTENCY => 'TIMELINE'}
  hbase> get 't1', 'r1', {CONSISTENCY => 'TIMELINE', REGION_REPLICA_ID => 1}

get examples

hbase(main):065:0> get 'sales', '1'
COLUMN                                CELL                                                                                                     
 order_details:cust_id                timestamp=1432700173670,value=C7001                                                                     
 order_details:ord_qty                timestamp=1432700186023,value=20                                                                        
 order_details:order_id               timestamp=1432700162924,value=O5001                                                                     
 product_details:product_id           timestamp=1432700115374,value=P1001                                                                     
 product_details:product_name         timestamp=1432700124398,value=APPLE IPAD                                                                
 product_details:product_price        timestamp=1432700132634,value=35000                                                                     
6 row(s) in 0.0110 seconds

hbase(main):066:0> get 'sales', '1', {TIMERANGE => [1432700162924, 1432700173670]}
COLUMN                                CELL                                                                                                     
 order_details:order_id               timestamp=1432700162924,value=O5001                                                                     
1 row(s) in 0.0120 seconds

hbase(main):067:0> get 'sales', '1', {COLUMN => ['product_details:product_name',  'order_details:ord_qty']}
COLUMN                                CELL                                                                                                     
 order_details:ord_qty                timestamp=1432700186023,value=20                                                                        
 product_details:product_name         timestamp=1432700124398,value=APPLE IPAD                                                                
2 row(s) in 0.0110 seconds

hbase(main):069:0> get 'sales', '2', 'order_details'
COLUMN                                CELL                                                                                                     
 order_details:cust_id                timestamp=1432700302696,value=C7004                                                                     
 order_details:ord_qty                timestamp=1432700315227,value=4                                                                         
 order_details:order_id               timestamp=1432700283486,value=O5002                                                                     
3 row(s) in 0.0160 seconds

hbase(main):070:0> get 'sales', '2', 'order_details:cust_id'
COLUMN                                CELL                                                                                                     
 order_details:cust_id                timestamp=1432700302696,value=C7004                                                                     
1 row(s) in 0.0080 seconds

hbase(main):071:0> temp_sales = get_table 'sales'
0 row(s) in 0.0050 seconds

=> Hbase::Table - sales
hbase(main):072:0> temp_sales.scan
ROW                                   COLUMN+CELL                                                                                              
 1                                    column=order_details:cust_id, timestamp=1432700173670,value=C7001                                       
 1                                    column=order_details:ord_qty, timestamp=1432700186023,value=20                                          
 1                                    column=order_details:order_id, timestamp=1432700162924,value=O5001                                      
 1                                    column=product_details:product_id, timestamp=1432700115374,value=P1001                                  
 1                                    column=product_details:product_name, timestamp=1432700124398, value=APPLEIPAD                           
 1                                    column=product_details:product_price, timestamp=1432700132634,value=35000                               
 2                                    column=order_details:cust_id, timestamp=1432700302696,value=C7004                                       
 2                                    column=order_details:ord_qty, timestamp=1432700315227,value=4                                           
 2                                    column=order_details:order_id, timestamp=1432700283486,value=O5002                                      
 2                                    column=product_details:product_id, timestamp=1432700237200,value=P1002                                  
 2                                    column=product_details:product_name, timestamp=1432700255326, value=I10CAR                              
 2                                    column=product_details:product_price, timestamp=1432700270345, value=535000   


hbase(main):085:0> alter 'sales', 'delete' => 'order_details'
Updating all regions with the new schema...
0/1 regions updated.
1/1 regions updated.
Done.
0 row(s) in 2.2010 seconds

hbase(main):086:0> desc 'sales'
Table sales is ENABLED                                                                                                                         
sales                                                                                                                                          
COLUMN FAMILIES DESCRIPTION                                                                                                                    
{NAME => 'product_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE
', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}     
1 row(s) in 0.0340 seconds


hbase(main):089:0> alter 'sales', 'new_order_details_group'
Updating all regions with the new schema...
0/1 regions updated.
1/1 regions updated.
Done.
0 row(s) in 2.2150 seconds

hbase(main):090:0> desc 'sales'
Table sales is ENABLED                                                                                                                         
sales                                                                                                                                          
COLUMN FAMILIES DESCRIPTION                                                                                                                    
{NAME => 'new_order_details_group', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIO
NS => '1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true
'}                                                                                                                                             
{NAME => 'product_details', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE
', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}     
2 row(s) in 0.0320 seconds
 



reference:
https://learnhbase.wordpress.com/