drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-2419) UDF that returns string representation of expression type
Date Mon, 13 Apr 2015 01:18:12 GMT

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

Mime
View raw message