You mean 50ms :)
________________________________ From: Parkirat <[email protected]> To: [email protected] Sent: Saturday, March 8, 2014 9:23 AM Subject: Re: HBase Rowkey Scan Taking more than 10 minutes. 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.
