[ https://issues.apache.org/jira/browse/HIVE-21896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16869449#comment-16869449 ]
Zoltan Haindrich commented on HIVE-21896: ----------------------------------------- added todoc label; and marked it "incompatibleChange" since the pattern will change from ".*" to (sql like) "%" for "SHOW FUNTIONS LIKE" > SHOW FUNCTIONS / SHOW FUNCTIONS LIKE - clarify > ---------------------------------------------- > > Key: HIVE-21896 > URL: https://issues.apache.org/jira/browse/HIVE-21896 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.1.1 > Reporter: Miklos Gergely > Assignee: Miklos Gergely > Priority: Major > Labels: incompatibleChange, todoc4.0 > Fix For: 4.0.0 > > Attachments: HIVE-21896.01.patch > > > According to > [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowFunctions] > the currently available functions can be listed like this: > {code:java} > SHOW FUNCTIONS <pattern>;{code} > If the user executes this command, they will get the correct list of > functions, but they will also see this on the standard output: > {code:java} > SHOW FUNCTIONS is deprecated, please use SHOW FUNCTIONS LIKE instead.{code} > If the user uses the > {code:java} > SHOW FUNCTIONS LIKE <pattern>;{code} > command then they will receive the exact same result (though through > different codes). The only difference is that one can get all the function > names with "SHOW FUNCTIONS;", while "SHOW FUNCTIONS LIKE;" returns an > exception, so in this case the pattern is mandatory. > So there should be a decision if we still accept "SHOW FUNCTIONS" without the > "LIKE". My suggestion is to accept it only if there is no pattern. so "SHOW > FUNCTIONS;" is ok, without deprecation message, but "SHOW FUNCTIONS > <pattern>" should throw an exception. > Whatever we decide, we should document it appropriately. > cc [~krishahn] -- This message was sent by Atlassian JIRA (v7.6.3#76005)