Example Analysis of hive in hadoop
Editor to share with you the example analysis of hive in hadoop, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
1.1 download hbase http://osdn.jp/projects/sfnet_purehadoop/downloads/hive-0.12.0.tar.gz/
1.2 install [root@hadoop04 Desktop] # tar-zxvf hive-0.12.0.tar.gz-C.. / app/
[root@hadoop04 Desktop] # cd.. / app
[root@hadoop04 app] # ls
Hive-0.12.0
[root@hadoop04 app] # cd hive-0.12.0
[root@hadoop04 hive-0.12.0] # cd bin
[root@hadoop04 bin] #. / hive
Hive > show databases
OK
Default
Time taken: 23.804 seconds, Fetched: 1 row (s)
Hive > create database yun12
>
OK
Time taken: 24.355 seconds
Hive > show databases
>
OK
Default
Yun12
Time taken: 4.162 seconds, Fetched: 2 row (s)
Hive > create table t_mygirls (id int,name string, age int, size string)
OK
Time taken: 28.528 seconds
Hive > show tables
OK
T_mygirls
Time taken: 0.062 seconds, Fetched: 1 row (s)
Hive > drop table t_mygirls
OK
Time taken: 2.772 seconds
Hive > create table t_mygirls (id int,name string, age int, size string) row format
> delimited
> fields terminated by "\ t"
Http://192.168.88.166:50070/explorer.html#/user/hive/warehouse
Browse Directory
PermissionOwnerGroupSizeReplicationBlock SizeNamedrwxr-xr-xrootsupergroup0 B00 Bt_mygirlsdrwxr-xr-xrootsupergroup0 B00 Byun12.db
[root@hadoop06 hadoop-2.6.0] # vi mygirls.data
1 baby 18 36C
2 YIFEI 19 38d
3 yangmi 20 31q
4 zhiling 40 39t
[root@hadoop04 ~] # hadoop fs-put mygirls.data / user/hive/warehouse/t_mygirls (path to the t_mygirls folder)
Hive > select * from t_mygirls
OK
The above is all the content of the article "sample Analysis of hive in hadoop". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
