[
https://issues.apache.org/jira/browse/DRILL-7501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004028#comment-17004028
]
Arina Ielchiieva commented on DRILL-7501:
-----------------------------------------
Paul, this change was done deliberately. sqltypeof function returns sql name of
the type, the one which is used in schema file, since Drill map in reality is a
struct, it returns struct naming. drillsqltypeof function will return map
naming since this is how structs are named in Drill.
> 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
> 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)
