[jira] [Created] (DRILL-7499) sqltypeof() function with an array returns "ARRAY", not type

["Paul Rogers (Jira)" <ji...@apache.org>]

Paul Rogers created DRILL-7499:
----------------------------------

             Summary: sqltypeof() function with an array returns "ARRAY", not type
                 Key: DRILL-7499
                 URL: https://issues.apache.org/jira/browse/DRILL-7499
             Project: Apache Drill
          Issue Type: Improvement
            Reporter: Paul Rogers


The {{sqltypeof()}} function was introduced in Drill 1.14 to work around limitations of the original {{typeof()}} function. The function is mentioned in _Learning Apache Drill_, Chapter 8, page 152:


{noformat}
ELECT sqlTypeOf(columns) AS cols_type,
       modeOf(columns) AS cols_mode
FROM `csv/cust.csv` LIMIT 1;

+--------------------+------------+
|     cols_type      | cols_mode  |
+--------------------+------------+
| CHARACTER VARYING  | ARRAY      |
+--------------------+------------+
{noformat}

When the same query is run against the just-released Drill 1.17, we get the *wrong* results:

{noformat}
+-----------+-----------+
| cols_type | cols_mode |
+-----------+-----------+
| ARRAY     | ARRAY     |
+-----------+-----------+
{noformat}

The definition of {{sqlTypeOf()}} is that it should return the type portion of the columns (type, mode) major type. Clearly, it is no longer doing so for arrays. As a result, there is no function to obtain the data type for arrays.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)