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] [Commented] (DRILL-2419) UDF that returns string representation of expression type
Date Tue, 31 Mar 2015 17:35:54 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) 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

> 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

View raw message