[
https://issues.apache.org/jira/browse/DRILL-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388905#comment-14388905
]
Daniel Barclay (Drill) commented on DRILL-2419:
-----------------------------------------------
When defining this function, specify whether it returns (the string
representation of) just the _data type_ (e.g., "DECIMAL") or more of the _type
descriptor_ ("DECIMAL(3,2)"). (See ISO/IEC 9075-2:2011 ยง4.1.2, near the end
(p. 15).)
(Possibly have two functions or control parameters so both versions are
available.)
The function probably should be consistent with the type information in
INFORMATION_SCHEMA.COLUMNS (once Drill's INFORMATION_SCHEMA.COLUMNS follows the
SQL standard, as least for type information).
Actually, maybe the function should return a value of a multi-valued row (map?
struct?) type that includes the same type-information columns as
INFORMATION_SCHEMA.COLUMNS or whatever other INFORMATION_SCHEMA views there are
for data types/descriptors (INFORMATION_SCHEMA views that use
DEFINITION_SCHEMA.DATA_TYPE_DESCRIPTOR).
> UDF that returns string representation of expression type
> ---------------------------------------------------------
>
> Key: DRILL-2419
> URL: https://issues.apache.org/jira/browse/DRILL-2419
> Project: Apache Drill
> Issue Type: Improvement
> Components: Functions - Drill
> Reporter: Victoria Markman
> Assignee: Mehant Baid
> Fix For: 1.0.0
>
>
> Suggested name: typeof (credit goes to Aman)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
