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)
