https://issues.apache.org/jira/browse/HBASE-7010
-- Lars ________________________________ From: Ted Yu <[email protected]> To: "[email protected]" <[email protected]> Sent: Sunday, March 9, 2014 8:08 PM Subject: Re: HBase Rowkey Scan Taking more than 10 minutes. I took a look at unit tests which involve PrefixFilter. TestFilter#testPrefixFilter() creates a Scan object without start row but with PrefixFilter which starts at "testRowOne". "testRowOnexx" rows are the first rows inserted to the table. I think we should have more tests w.r.t. PrefixFilter that don't start from the rows that pass the PrefixFilter. The usage of PrefixFilter should be made more user-friendly: start row for the scan is implicit when PrefixFilter is specified. Cheers On Sat, Mar 8, 2014 at 9:23 AM, Parkirat <[email protected]> wrote: > 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. >
