You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "Karthick (JIRA)" <ji...@apache.org> on 2019/05/09 11:30:00 UTC
[jira] [Comment Edited] (HBASE-21620) Problem in scan query when
using more than one column prefix filter in some cases.
[ https://issues.apache.org/jira/browse/HBASE-21620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16836290#comment-16836290 ]
Karthick edited comment on HBASE-21620 at 5/9/19 11:29 AM:
-----------------------------------------------------------
[~openinx] please use the attached *HBaseFileImport.java* file and change the filename from _"columnkey.txt"_ to _"qualifiers.txt"_ to import the columns in your table. You also have to replace the ZK quorum, topnode and namespace:tablename. After importing the columns you can use scan query given in *scanquery.txt* in hbase shell.
was (Author: karthickram):
[~openinx] please use the *HBaseFileImport.java* file and change the filename from _"columnkey.txt"_ to _"qualifiers.txt"_ to import the columns in your table. You also have replace the ZK quorum, topnode and namespace:tablename. After importing the columns you can use scan query given in *scanquery.txt* in hbase shell.
> Problem in scan query when using more than one column prefix filter in some cases.
> ----------------------------------------------------------------------------------
>
> Key: HBASE-21620
> URL: https://issues.apache.org/jira/browse/HBASE-21620
> Project: HBase
> Issue Type: Bug
> Components: Scanners
> Affects Versions: 3.0.0, 1.5.0, 2.2.0, 1.4.8, 2.1.2, 2.0.4
> Environment: hbase-1.4.8, hbase-1.4.9
> hadoop-2.7.3
> Reporter: Mohamed Mohideen Meeran
> Assignee: Zheng Hu
> Priority: Major
> Fix For: 3.0.0, 2.2.0, 2.1.2, 2.0.4
>
> Attachments: HBASE-21620.branch-1.patch, HBASE-21620.v1.patch, HBASE-21620.v2.patch, HBASE-21620.v3.patch, HBASE-21620.v3.patch, HBaseFileImport.java, HBaseImportData.java, columnkey.txt, file.txt, qualifiers.txt, scanquery.txt, test.patch
>
>
> In some cases, unable to get the scan results when using more than one column prefix filter.
> Attached a java file to import the data which we used and a text file containing the values..
> While executing the following query (hbase shell as well as java program) it is waiting indefinitely and after RPC timeout we got the following error.. Also we noticed high cpu, high load average and very frequent young gc in the region server containing this row...
> scan 'namespace:tablename',\{STARTROW => 'test',ENDROW => 'test', FILTER => "ColumnPrefixFilter('1544770422942010001_') OR ColumnPrefixFilter('1544769883529010001_')"}
> ROW COLUMN+CELL ERROR: Call id=18, waitTime=60005, rpcTimetout=60000
>
> Note: Table scan operation and scan with a single column prefix filter works fine in this case.
> When we check the same query in hbase-1.2.5 it is working fine.
> Can you please help me on this..
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)