You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Larry Ogrodnek (JIRA)" <ji...@apache.org> on 2009/06/25 00:13:07 UTC

[jira] Created: (HIVE-580) command to list available UDF names

command to list available UDF names
-----------------------------------

                 Key: HIVE-580
                 URL: https://issues.apache.org/jira/browse/HIVE-580
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Clients, Documentation
            Reporter: Larry Ogrodnek


It would be great if there was some way to list all available UDF names in the CLI.

Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.

Would also be nice if the UDF names were available for auto-completion (HIVE-97).

As a start, just having the names available would be great.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Scott Chen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Chen updated HIVE-580:
----------------------------

    Attachment: hive-580-2009-07-25.patch

"SHOW FUNCTIONS;" will list all the udf.
"SHOW FUNCTIONS 'regular expression string';" will list all the udf matches the regular expression.
Most of the logic in this patch follows "SHOW TABLE".

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-580:
----------------------------

      Resolution: Fixed
    Hadoop Flags: [Reviewed]
          Status: Resolved  (was: Patch Available)

Committed. Thanks Scott

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26-2.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Scott Chen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Chen updated HIVE-580:
----------------------------

    Attachment: hive-580-2009-07-26-1.patch

@Ashish: Sorry I forgot to svn add show_function.q.out. The UDAF in FunctionRegistry will also be listed out. 

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Scott Chen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735882#action_12735882 ] 

Scott Chen commented on HIVE-580:
---------------------------------

Thank you very much Namit.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26-2.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735480#action_12735480 ] 

Namit Jain commented on HIVE-580:
---------------------------------

Also, can you add some property which shows the signature and the properties of the function (whether it is temporary or not).
You can add something like:

describe function {extended}

You can also do the describe in a follow-up - in that case please file a JIRA for the same

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-580:
------------------------------

    Status: Patch Available  (was: Open)

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735847#action_12735847 ] 

Namit Jain commented on HIVE-580:
---------------------------------

+1

Looks good - will run tests and merge if the tests pass

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26-2.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735379#action_12735379 ] 

He Yongqiang commented on HIVE-580:
-----------------------------------

The patch looks good.  Can you use hadoop conversion for code format? (showFunctionsDesc and DDLSemanticAnalyzer)

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Scott Chen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Chen updated HIVE-580:
----------------------------

    Attachment: hive-580-2009-07-26.patch

@Yongqing: Thanks. I have checked with the convention but I only changed few things. It would be good if you can point out the file and lineno.

@Namit: That is a very good suggestion. But as Zheng mentioned there's hive-691 on this one.

@Zheng: Thanks for the comments. I have add javadoc to 3 new functions that I added. And LOG.info has been changed to LOG.warn in both showFunctions and showTables.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (HIVE-580) command to list available UDF names

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao reassigned HIVE-580:
-------------------------------

    Assignee: Scott Chen

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12723800#action_12723800 ] 

Zheng Shao commented on HIVE-580:
---------------------------------

That's a good idea.
It should be pretty easy to do since FunctionRegistry has all the information needed.


> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12730953#action_12730953 ] 

He Yongqiang commented on HIVE-580:
-----------------------------------

That's good.  We should avoid adding all command processing logics in one CliDriver.  I can see CliDriver will get fatter and fatter as new commands got in.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-580:
------------------------------

    Attachment: hive-580-2009-07-15.patch

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12724785#action_12724785 ] 

Ashish Thusoo commented on HIVE-580:
------------------------------------

+1.

Additionally I think we should support UDFs persistently as well (not just create temporary function but also create function)

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735719#action_12735719 ] 

Ashish Thusoo commented on HIVE-580:
------------------------------------

One question about this patch. This does not print out UDAFs - granted that we do not yet have the capability to register UDAFs but I think it would be good to be able to list out UDAFs as well considering that we are adding new ones soon. Also show_functions.q.out does not seem to be part of the patch.



> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-580:
--------------------------------

    Fix Version/s: 0.4.0

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>             Fix For: 0.4.0
>
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26-2.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-580) command to list available UDF names

Posted by "Scott Chen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Chen updated HIVE-580:
----------------------------

    Attachment: hive-580-2009-07-26-2.patch

changed HashMap -> LinkedHashMap following Namit's suggestion

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26-2.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735486#action_12735486 ] 

Zheng Shao commented on HIVE-580:
---------------------------------

Since we already have HIVE-691, let's use that one for "describe function {extended}".

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735802#action_12735802 ] 

Namit Jain commented on HIVE-580:
---------------------------------

Since, mFunctions in FunctionRegistry is a hashmap - it does not guarantee any order.
So, output of show functions is non-deterministic.

Please change mFuntions to a linkedhashmap.

Otherwise, the changes look good.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch, hive-580-2009-07-26-1.patch, hive-580-2009-07-26.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12730962#action_12730962 ] 

Namit Jain commented on HIVE-580:
---------------------------------

Yes, it would be better to add a 'show functions' command supported by the hive parser itself.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12735484#action_12735484 ] 

Zheng Shao commented on HIVE-580:
---------------------------------

Overall the patch looks pretty good. Some nitpicks:
@hive-580-2009-07-25.patch:
43,47: Can you add javadoc for all new functions? I know we don't have javadoc for all functions, but a while back we've decided to add "javadoc" for all new functions (and gradually do that for all old functions as well).
141: LOG.warn instead of LOG.info. (Can you do the same change to showTables?)


> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>            Assignee: Scott Chen
>         Attachments: hive-580-2009-07-15.patch, hive-580-2009-07-25.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-580) command to list available UDF names

Posted by "Prasad Chakka (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12730940#action_12730940 ] 

Prasad Chakka commented on HIVE-580:
------------------------------------

@yongqing, we are trying to move away from processing queries inside CliDriver.java. This just creates problems later on. Joydeep is planning to move all such commands/constructs (set, add, comments) from CliDriver into parser. I don't think we should add this command here.

> command to list available UDF names
> -----------------------------------
>
>                 Key: HIVE-580
>                 URL: https://issues.apache.org/jira/browse/HIVE-580
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients, Documentation
>            Reporter: Larry Ogrodnek
>         Attachments: hive-580-2009-07-15.patch
>
>
> It would be great if there was some way to list all available UDF names in the CLI.
> Ideally, there would be some way for the UDFs themselves to provide a description/help that could also be displayed.
> Would also be nice if the UDF names were available for auto-completion (HIVE-97).
> As a start, just having the names available would be great.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.