[
https://issues.apache.org/jira/browse/DRILL-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388905#comment-14388905
]
Daniel Barclay (Drill) edited comment on DRILL-2419 at 4/13/15 1:15 AM:
------------------------------------------------------------------------
When defining this function, specify whether it returns:
1) just the data type name (e.g., "DECIMAL"; as defined by ISO/IEC 9075-2:2011
§9.9, "Type name determination") or
2) a representation of the data type descriptor (e.g. "DECIMAL(3,2)"; see
ISO/IEC 9075-2:2011 §4.1.2, near the end (p. 15).)
Maybe have two functions (one returning the full type-description information;
the other returning just the data type name), or possibly have a function with
a control flag.
Possibly the function, or a third third, 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 table for data type descriptor
information).
was (Author: dsbos):
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.1.0
>
>
> Suggested name: typeof (credit goes to Aman)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
