drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3886) Range query over HBase table from Drill returns no results
Date Fri, 02 Oct 2015 01:01:26 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Khurram Faraaz updated DRILL-3886:
----------------------------------
    Description: 
Range query over HBase table from Drill returns no results. Note that the filter is pushed
down to the Scan, however query does not return any results. Drill master commit ID: b9afcf8f

case 1) without cast and without quotes around integer value

{code}
0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD') as
rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])

0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
+--+
|  |
+--+
+--+
No rows selected (0.869 seconds)
{code}

case 2) with cast and without quotes around integer value

{code}
0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND convert_from(row_key,'INT_OBD')
< cast(536870911 as int);
+--+
|  |
+--+
+--+
No rows selected (0.905 seconds)

0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD') as
rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND convert_from(row_key,'INT_OBD')
< cast(536870911 as int);
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])
{code}

  was:
Range query over HBase table from Drill returns no results. Note that the filter is pushed
down to the Scan, however query does not return any results. Drill master commit ID: b9afcf8f

case 1) without cast and without quotes around integer value

0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD') as
rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])

0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
+--+
|  |
+--+
+--+
No rows selected (0.869 seconds)

-----------------------

case 2) with cast and without quotes around integer value

{code}
0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND convert_from(row_key,'INT_OBD')
< cast(536870911 as int);
+--+
|  |
+--+
+--+
No rows selected (0.905 seconds)

0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD') as
rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND convert_from(row_key,'INT_OBD')
< cast(536870911 as int);
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])
{code}


> Range query over HBase table from Drill returns no results
> ----------------------------------------------------------
>
>                 Key: DRILL-3886
>                 URL: https://issues.apache.org/jira/browse/DRILL-3886
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.2.0
>         Environment: 4 node cluster CentOS
>            Reporter: Khurram Faraaz
>            Assignee: Smidth Panchamia
>
> Range query over HBase table from Drill returns no results. Note that the filter is pushed
down to the Scan, however query does not return any results. Drill master commit ID: b9afcf8f
> case 1) without cast and without quotes around integer value
> {code}
> 0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD')
as rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
> +------+------+
> | text | json |
> +------+------+
> | 00-00    Screen
> 00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
> 00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])
> 0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > -536870912 AND convert_from(row_key,'INT_OBD')
< 536870911;
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.869 seconds)
> {code}
> case 2) with cast and without quotes around integer value
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select convert_from(row_key,'INT_OBD') as rk from int_Tbl
WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND convert_from(row_key,'INT_OBD')
< cast(536870911 as int);
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.905 seconds)
> 0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(row_key,'INT_OBD')
as rk from int_Tbl WHERE convert_from(row_key,'INT_OBD') > cast(-536870912 as int) AND
convert_from(row_key,'INT_OBD') < cast(536870911 as int);
> +------+------+
> | text | json |
> +------+------+
> | 00-00    Screen
> 00-01      Project(rk=[CONVERT_FROMINT_OBD($0)])
> 00-02        Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=int_Tbl,
startRow=\xD4`\x00\x00\x00\x00, stopRow=\xD4\x9F\xFF\xFF\xFF, filter=FilterList AND (2/2):
[RowFilter (LESS, \xD4\x9F\xFF\xFF\xFF), RowFilter (GREATER, \xD4`\x00\x00\x00)]], columns=[`row_key`]]])
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message