Page History

  Usageusage: hive
 [-hiveconf x=y]* [<-i filename>]* [<-f filename>|<-e query-string>] [-S]

  -i <filename>-d,--define <key=value>          Variable subsitution to apply to hive
                       Initialization Sql from file (executed automatically and silently before any other commands)
  -e 'quoted query string'  Sql. e.g. -d A=B or --define A=B
 -e <quoted-query-string>         SQL from command line
  -f <filename>                    SqlSQL from file
  -Sfiles
 -H,--help                        Print help information
 -h <hostname>                    connecting to Hive Server on remote Silent mode in interactive shell where only data is emitted
  -vhost
    --hiveconf <property=value>   Use value for given property
    --hivevar <key=value>         Variable subsitution to apply to hive
                              Verbose mode (echo executed SQL to the console)
 commands. e.g. --hivevar A=B
 -i <filename>                    Initialization SQL file
 -p <port>                       connect connecting to Hive Server on port number
 -S,--silent     -hiveconf x=y             Use this to setSilent hive/hadoopmode configurationin variables.interactive shell
  
-v,--verbose         -e and -f cannot be specified together. In the absence of these options,Verbose interactivemode shell(echo isexecuted started.SQL to the
   However, -i can be used with any other options.  Multiple instances of -i can be used to execute multiple init scripts.

   To see this usage help, run hive -h
 console)