声明:前面两篇文章已经知道了如何创建表
现在我们来学习Hive数据加载
- 不得不说一个知识点: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
- 根据这里的参数,我们可以做以下实验:
[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/re