Paul Rogers created DRILL-7501:
----------------------------------
Summary: Drill 1.17 sqlTypeOf for a Map now reports STRUCT
Key: DRILL-7501
URL: https://issues.apache.org/jira/browse/DRILL-7501
Project: Apache Drill
Issue Type: Bug
Reporter: Paul Rogers
Drill 1.14 introduced the {{sqlTypeOf()}} function to workaround limits of the
{{typeof()}} function. {{sqlTypeOf()}} should return the name of the SQL type
for a column, using the type name that Drill uses.
A query from page 163 of _Learning Apache Drill_:
{code:sql}
SELECT sqlTypeOf(`name`) AS name_type FROM `json/nested.json`;
{code}
Drill 1.14 results (correct):
{noformat}
+------------+
| name_type |
+------------+
| MAP |
+------------+
{noformat}
Drill 1.17 results (incorrect):
{noformat}
+-----------+
| name_type |
+-----------+
| STRUCT |
+-----------+
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
