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.
