[jira] [Created] (DRILL-7501) Drill 1.17 sqlTypeOf for a Map now reports STRUCT

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

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)