hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: HBase Rowkey Scan Taking more than 10 minutes.
Date Sat, 08 Mar 2014 18:06:07 GMT
>From 880 seconds to 50ms, we can say it's a good improvement  ;)


2014-03-08 12:28 GMT-05:00 lars hofhansl <larsh@apache.org>:

> You mean 50ms :)
>
>
>
> ________________________________
>  From: Parkirat <parkiratbigdata@gmail.com>
> To: user@hbase.apache.org
> 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message