[jira] [Comment Edited] (DRILL-2419) UDF that returns string representation of expression type

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

    [ 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)