Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/Cli" page has been changed by JohnSichi. http://wiki.apache.org/hadoop/Hive/LanguageManual/Cli?action=diff&rev1=15&rev2=16 -------------------------------------------------- Usage: {{{ - Usage: hive [-hiveconf x=y]* [<-f filename>|<-e query-string>] [-S] + Usage: hive [-hiveconf x=y]* [<-i filename>]* [<-f filename>|<-e query-string>] [-S] + -i <filename> Initialization Sql from file (executed automatically and silently before any other commands) -e 'quoted query string' Sql from command line -f <filename> Sql from file -S Silent mode in interactive shell where only data is emitted -hiveconf x=y Use this to set hive/hadoop configuration variables. - -e and -f cannot be specified together. In the absence of these options, interactive shell is started + -e and -f cannot be specified together. In the absence of these options, interactive shell is started. However, -i can be used with any other options. To see this usage help, run hive -h @@ -39, +40 @@ {{{ HIVE_HOME/bin/hive -S -e 'select a.col from tab1 a' > a.txt }}} - + * Example of running a script non-interactively + {{{ + HIVE_HOME/bin/hive -f /home/my/hive-script.sql + }}} + * Example of running an initialization script before entering interactive mode + {{{ + HIVE_HOME/bin/hive -i /home/my/hive-init.sql + }}} == Hive interactive Shell Command ==
