[
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:17 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:
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).
> 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)
