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)