[ https://issues.apache.org/jira/browse/DRILL-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6361: ------------------------------------ Reviewer: Volodymyr Vysotskyi > Provide sqlTypeOf() and modeOf() functions > ------------------------------------------ > > 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 > Assignee: Paul Rogers > Priority: Minor > Labels: doc-impacting > Fix For: 1.14.0 > > > 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)