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-3870) CONVERT_FROM(..., uint8_be) can not be used in project
Date Thu, 01 Oct 2015 22:15:26 GMT

     [ 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)

Mime
View raw message