[
https://issues.apache.org/jira/browse/DRILL-6360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17005125#comment-17005125
]
Paul Rogers edited comment on DRILL-6360 at 12/30/19 6:34 AM:
--------------------------------------------------------------
The information should go
[here|https://drill.apache.org/docs/data-type-functions/].
{{typeof()}} returns {{"NULL"}} if the value of a column is NULL, else it
returns the internal Drill type name for a column as given by {{drillTypeOf()}}.
If we adopt the changes proposed in DRILL-6362, then the documentation becomes:
Returns the type of the column using the internal Drill type name. If the
column is the experimental {{UNION}} type, then returns the type of the
specific column value, or "NULL" if that column is null. To determine if a
column is a UNION, use the {{drillTypeOf()}} function.
Note that in Drill 1.17 and before, the {{typeof()}} function returned "NULL"
if the column value is null. From Drill 1.18 and later, this is only true if
the column is of type {{UNION}}.
was (Author: paul.rogers):
The information should go
[here|https://drill.apache.org/docs/data-type-functions/].
{{typeof()}} returns {{"NULL"}} if the value of a column is NULL, else it
returns the internal Drill type name for a column as given by {{drillTypeOf()}}.
> Document the typeof() function
> ------------------------------
>
> Key: DRILL-6360
> URL: https://issues.apache.org/jira/browse/DRILL-6360
> Project: Apache Drill
> Issue Type: Task
> Components: Documentation
> Affects Versions: 1.13.0
> Reporter: Paul Rogers
> Assignee: Bridget Bevens
> Priority: Minor
> Labels: doc-impacting
>
> Drill has a {{typeof()}} function that returns the data type (but not mode)
> of a column. It was discussed on the dev list recently. However, a search of
> the Drill web site, and a scan by hand, failed to turn up documentation about
> the function.
> As a general suggestion, would be great to have an alphabetical list of all
> functions so we don't have to hunt all over the site to find which functions
> are available.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
