You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Bridget Bevens (JIRA)" <ji...@apache.org> on 2018/12/10 23:16:00 UTC

[jira] [Commented] (DRILL-3988) Create a sys.functions table to expose available Drill functions

    [ https://issues.apache.org/jira/browse/DRILL-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16715753#comment-16715753 ] 

Bridget Bevens commented on DRILL-3988:
---------------------------------------

Hi [~kkhatua] and [~arina],

I've updated the following doc to include changes listed in this JIRA.

Please have a look and let me know if I need to change anything.

[https://drill.apache.org/docs/querying-system-tables/] 

[https://drill.apache.org/docs/querying-system-tables/#querying-the-functions-table] 

Thanks,
Bridget

> Create a sys.functions table to expose available Drill functions
> ----------------------------------------------------------------
>
>                 Key: DRILL-3988
>                 URL: https://issues.apache.org/jira/browse/DRILL-3988
>             Project: Apache Drill
>          Issue Type: Sub-task
>          Components: Metadata
>            Reporter: Jacques Nadeau
>            Assignee: Kunal Khatua
>            Priority: Major
>              Labels: doc-complete
>             Fix For: 1.15.0
>
>
> Create a new sys.functions table that returns a list of all available functions.
> Key considerations: 
> - one row per name or one per argument set. I'm inclined to latter so people can use queries to get to data.
> - we need to create a delineation between user functions and internal functions and only show user functions. 'CastInt' isn't something the user should be able to see (or run).
> - should we add a description annotation that could be included in the sys.functions table?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)