Paul Rogers created DRILL-6361:
----------------------------------
Summary: Provide a dataTypeOf() 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
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)
