[
https://issues.apache.org/jira/browse/HIVE-5?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647789#action_12647789
]
Ashish Thusoo commented on HIVE-5:
----------------------------------
One thing that is quite powerful in the show variable syntax is that ability to
use like matching. I do not think that is covered by the SET syntax per se.
With show variables we could do
SHOW VARIABLES like '%mapred%'
and that would show the values of all variables which has mapred somewhere in
its name.
> "set" command is case-sensitive; also lacks "EXTENDED" support, as documented
> on http://wiki.apache.org/hadoop/Hive/HiveQL
> --------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-5
> URL: https://issues.apache.org/jira/browse/HIVE-5
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: Jeff Hammerbacher
>
> When I try to run "SET;" from the Hive shell, I get a parse error (FAILED:
> Parse Error: line 1:0 cannot recognize input 'SET'). It works if I run
> "set;". Also, when I try to run "set extended;", I get a new kind of error,
> with error message "extended is undefined".
> On another note, can we alias "SET;" to something more descriptive, like
> "SHOW VARIABLES" (e.g.
> http://dev.mysql.com/doc/refman/5.0/en/show-variables.html)?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
