>From 880 seconds to 50ms, we can say it's a good improvement ;)
2014-03-08 12:28 GMT-05:00 lars hofhansl <[email protected]>: > 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. >
