Which HBase release are you using ? Can you take a look at the log on the server hosting the region for "U_mykey|AABrCwADAAABP/IQXolH" ?
On Sat, Mar 8, 2014 at 8:37 AM, Parkirat <[email protected]> wrote: > Hi All, > > I am using HBase for storing the data, which is around 100 GBs in an HBase > Table, which I am trying to query. > > Also, there are around 100 Regions, for the table, each region having 1 GB > of Data. The region, I am trying to query is around 850 mb. But when I do a > scan on the part of the key using the Prefix Filter, it is taking more than > 10 mins. Please find below the query result. > > Could anybody help me answering the question, why is the scan taking so > much > time???? > > ====================================================== > hbase(main):005:0> scan 'store', > > {FILTER=>org.apache.hadoop.hbase.filter.PrefixFilter.new(org.apache.hadoop.hbase.util.Bytes.toBytes('U_mykey|AABrCwADAAABP/IQXolH'))} > ROW COLUMN+CELL > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > > [jar:file:/usr/lib/hbase/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > > [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.4.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > > [jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > 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 880.4260 seconds > ====================================================== > > Regards, > Parkirat > > > > -- > View this message in context: > http://apache-hbase.679495.n3.nabble.com/HBase-Rowkey-Scan-Taking-more-than-10-minutes-tp4056816.html > Sent from the HBase User mailing list archive at Nabble.com. >
