[jira] [Created] (DRILL-3870) CONVERT_FROM(..., uint8_be) can not be used in project

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-3870:
-------------------------------------

             Summary: 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


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)