[jira] [Updated] (DRILL-6361) Provide a sqlTypeOf() or modeOf() function

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

     [ https://issues.apache.org/jira/browse/DRILL-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Rogers updated DRILL-6361:
-------------------------------
    Summary: Provide a sqlTypeOf() or modeOf() function  (was: Provide a dataTypeOf() or modeOf() function)

> Provide a sqlTypeOf() or modeOf() function
> ------------------------------------------
>
>                 Key: DRILL-6361
>                 URL: https://issues.apache.org/jira/browse/DRILL-6361
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.13.0
>            Reporter: Paul Rogers
>            Priority: Minor
>
> Drill provides a {{typeof()}} function to return the type of a column. The returned string, however, has only the base data type. A Drill data type (a "major type") also includes a cardinality (a "mode"). For example, {{Optional Int}} or {{Required VarChar}}.
> This type information is useful for handling data conversions. For example, if I could tell that a column value was a {{Nullable Int}}, I could guess that it is one Drill invented, and I could merge it, by hand, with the type from another file that had actual values.
> The two options are equivalent. Either provide a {{modeOf()}} to just return cardinality, or a {{dataTypeOf()}} that returns both. (Maybe the {{modeOf()}} might be more useful.)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)