hive cli 常用操作(-e,-f.-i)

hive cli 常用操作(-e,-f.-i)

官网：https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli

1、bin/hive -help

bin/hive -help15/10/18 06:34:46 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* insteadusage: hive -d,--define <key=value>          Variable subsitution to apply to hive                                  commands. e.g. -d A=B or --define A=B    --database <databasename>     Specify the database to use -e <quoted-query-string>         SQL from command line -f <filename>                    SQL from files -H,--help                        Print help information -h <hostname>                    connecting to Hive Server on remote host    --hiveconf <property=value>   Use value for given property    --hivevar <key=value>         Variable subsitution to apply to hive                                  commands. e.g. --hivevar A=B -i <filename>                    Initialization SQL file -p <port>                        connecting to Hive Server on port number -S,--silent                      Silent mode in interactive shell -v,--verbose                     Verbose mode (echo executed SQL to the

2、hive -e 用法

[root@cloud1 hive-0.13.1]# bin/hive -e 'select *  from default.student'15/10/18 06:55:27 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* insteadLogging initialized using configuration in jar:file:/opt/hive-0.13.1/lib/hive-common-0.13.1.jar!/hive-log4j.propertiesOK1xiaoming2zhangsan3lisiTime taken: 21.298 seconds, Fetched: 3 row(s)

3、hive -f 用法

[root@cloud1 hive-0.13.1]# touch hfile.sql[root@cloud1 hive-0.13.1]# vi hfile.sqlselect * from default.student ; bin/hive -f /opt/hive-0.13.1/hfile.sql[root@cloud1 hive-0.13.1]# bin/hive -f /opt/hive-0.13.1/hfile.sql15/10/18 07:00:12 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* insteadLogging initialized using configuration in jar:file:/opt/hive-0.13.1/lib/hive-common-0.13.1.jar!/hive-log4j.propertiesOK1xiaoming2zhangsan3lisiTime taken: 13.048 seconds, Fetched: 3 row(s)或者： bin/hive -f hdfs://192.168.80.20:8020/user/hive/hfile.sql

4、hive -i 用法：(这里占时还没有例子)

* bin/hive -i xx
-i <filename>                    Initialization SQL file
eg:
add jar xxx.jar
add file xxx
create temporary function my_lower as ....
bin/hive -i hive-init.sql