03-Hive数据加载的几种方式

声明：前面两篇文章已经知道了如何创建表
现在我们来学习Hive数据加载

1. 不得不说一个知识点：hive -help、hive --help 、 hive --service -help

[root@hadoop1 host]# hive -help
usage: hive
 -d,--define <key=value>          Variable subsitution to apply to hive
                                  commands. e.g. -d A=B or --define A=B
 -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
                                  console)
[root@hadoop1 host]#hive --help
Usage ./hive <parameters> --service serviceName <service parameters>
Service List: cli help hiveserver hwi jar lineage metastore rcfilecat 
Parameters parsed:
  --auxpath : Auxillary jars 
  --config : Hive configuration directory
  --service : Starts specific service/component. cli is default
Parameters used:
  HADOOP_HOME : Hadoop install directory
  HIVE_OPT : Hive options
For help on a particular service:
  ./hive --service serviceName --help
Debug help:  ./hive --debug --help

2. 根据这里的参数，我们可以做以下实验：

[root@hadoop1 host]# hive -e "select * from testtext"
警告信息省略
OK
wer	46
wer	89
weree	78
rr	89
Time taken: 5.632 seconds
[root@hadoop1 host]# hive -S -e "select * from testtext"
wer	46
wer	89
weree	78
rr	89

这样子就可以不用进入hive的命令行模式了。加-S还更简洁。
3. 还可以玩重定向哦，输出到/usr/host/result

[root@hadoop1 host]# hive -e "select * from testtext" > /usr/host/result
OK
Time taken: 4.144 seconds
[root@hadoop1 host]# cat result 
wer	46
wer	89
weree	78
rr	89
[root@hadoop1 host]# hive -S -e "select * from testtext" >> /usr/host/result
[root@hadoop1 host]# cat result 
wer	46
wer	89
weree	78
rr	89
wer	46
wer	89
weree	78
rr	89
[root@hadoop1 host]# hive -v -e "select * from testtext" > /usr/host/result

"