hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Parkirat <parkiratbigd...@gmail.com>
Subject Re: HBase Rowkey Scan Taking more than 10 minutes.
Date Sat, 08 Mar 2014 17:23:27 GMT
Hi Pradeep,

Thanks for the prompt help. Your Solution worked for me. My query time got
reduced significantly to 500ms.
Please find below the query result.

Though, I was thinking the Prefix Filter, would optimize on the Row Key
Index.


=========================================================
hbase(main):003:0> scan 'store', {STARTROW=>'U_mykey|AABrCwADAAABP/IQXolH',
ENDROW=>'U_mykey|AABrCwADAAABP/IQXolH~'}
ROW                                                  COLUMN+CELL
 U_mykey|AABrCwADAAABP/IQXolH.aliases                 
column=datafile:value, timestamp=1394275248787, value=[PHONE|991xxxxxx9]
 U_mykey|AABrCwADAAABP/IQXolH.birthdate               
column=datafile:value, timestamp=1393418222358, value=null
 U_mykey|AABrCwADAAABP/IQXolH.created                 
column=datafile:value, timestamp=1392098938946, value=1392098938955
 U_mykey|AABrCwADAAABP/IQXolH.email                   
column=datafile:value, timestamp=1393418222292, value=null
 U_mykey|AABrCwADAAABP/IQXolH.fname                   
column=datafile:value, timestamp=1393418222303, value=null
 U_mykey|AABrCwADAAABP/IQXolH.friends                 
column=datafile:value, timestamp=1374156544788, value=[]
 U_mykey|AABrCwADAAABP/IQXolH.gender                  
column=datafile:value, timestamp=1393418221863, value=null
 U_mykey|AABrCwADAAABP/IQXolH.image                   
column=datafile:value, timestamp=1393418222313, value=null
 U_mykey|AABrCwADAAABP/IQXolH.lname                   
column=datafile:value, timestamp=1393418221873, value=null
 U_mykey|AABrCwADAAABP/IQXolH.mname                   
column=datafile:value, timestamp=1393418222344, value=null
 U_mykey|AABrCwADAAABP/IQXolH.nick                    
column=datafile:value, timestamp=1393418221795, value=null
 U_mykey|AABrCwADAAABP/IQXolH.nid                     
column=datafile:value, timestamp=1393418221809,
value=mykey|AABrCwADAAABP/IQXolH
 U_mykey|AABrCwADAAABP/IQXolH.phone                   
column=datafile:value, timestamp=1384419197956, value=991xxxxxx9
 U_mykey|AABrCwADAAABP/IQXolH.phone2                  
column=datafile:value, timestamp=1393510696484, value=953xxxxxx5
 U_mykey|AABrCwADAAABP/IQXolH.token                   
column=datafile:value, timestamp=1392135639003, value=[]
15 row(s) in 0.0540 seconds
=========================================================

Regards,
Parkirat



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/HBase-Rowkey-Scan-Taking-more-than-10-minutes-tp4056816p4056820.html
Sent from the HBase User mailing list archive at Nabble.com.

Mime
View raw message