[
https://issues.apache.org/jira/browse/DRILL-7501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paul Rogers reassigned DRILL-7501:
----------------------------------
Assignee: Paul Rogers
> 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
> Affects Versions: 1.16.0
> Reporter: Paul Rogers
> Assignee: Paul Rogers
> Priority: Minor
>
> 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)
