Hive 教程(六)-命令补充说明

[root@hadoop10 hive2.3.6]# hive --heip
 -d,--define <key=value>          Variable substitution 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
    --hiveconf <property=value>   Use value for given property
    --hivevar <key=value>         Variable substitution to apply to Hive
                                  commands. e.g. --hivevar A=B
 -i <filename>                    Initialization SQL file
 -S,--silent                      Silent mode in interactive shell
 -v,--verbose                     Verbose mode (echo executed SQL to the
                                  console)

[root@hadoop10 hive2.3.6]# hive -e ‘select * from hive1.hive_01 limit 10‘;

[root@hadoop10 hive2.3.6]# hive -f sql.sh

hive> dfs - ls /;

hive> ! ls /usr/lib/hive2.3.6;
bin
binary-package-licenses
conf
examples