You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/10/02 00:15:26 UTC
[jira] [Updated] (DRILL-3870) CONVERT_FROM(..., uint8_be) can not
be used in project
[ https://issues.apache.org/jira/browse/DRILL-3870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Khurram Faraaz updated DRILL-3870:
----------------------------------
Assignee: Aditya Kishore
> CONVERT_FROM(..., uint8_be) can not be used in project
> ------------------------------------------------------
>
> Key: DRILL-3870
> URL: https://issues.apache.org/jira/browse/DRILL-3870
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 1.2.0
> Environment: 4 node cluster CentOS
> Reporter: Khurram Faraaz
> Assignee: Aditya Kishore
> Fix For: Future
>
>
> CONVERT_FROM(..., 'uint8_be') results in UNSUPPORTED_OPERATION when used in project. However, when it is used in the predicate in the WHERE clause no error is reported.
> Data in the HBase table has long integer values.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,1,8),'bigint_be') AS RK from dt_Tbl T;
> +----------------+
> | RK |
> +----------------+
> | 1408924800000 |
> | 1443240886094 |
> | 1443413686094 |
> | 1443491446094 |
> | 1443500086094 |
> +----------------+
> 5 rows selected (0.767 seconds)
> {code}
> The below query fails when CONVERT_FROM function is used in the project.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,1,8),'uint8_be') AS RK from dt_Tbl T;
> Error: UNSUPPORTED_OPERATION ERROR: CONVERT_FROM does not support conversion from type 'uint8_be'.
> Did you mean UINT8?
> [Error Id: 1e58b2bb-73c3-4c55-84db-e59b80ea6dbb on centos-03.qa.lab:31010] (state=,code=0)
> {code}
> When the same CONVERT_FROM function is used in the predicate no error is reported.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select * from dt_Tbl WHERE CONVERT_FROM(BYTE_SUBSTR(row_key,1,8),'uint8_be') < cast(1443500086094 as bigint);
> +--------------+-----------------------+
> | row_key | colfam1 |
> +--------------+-----------------------+
> | [B@14c9d776 | {"qual1":"dmFsMQ=="} |
> | [B@4f608ea3 | {"qual1":"dmFsNQ=="} |
> | [B@4c34980b | {"qual1":"dmFsNA=="} |
> | [B@10ea2143 | {"qual1":"dmFsMw=="} |
> +--------------+-----------------------+
> 4 rows selected (0.865 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)