hive
启动
./hive
查看库
show databases;
启用库
use default;
显示表
show tables;
创建表(不带红色导入数据时为NULL)
create table student(id int,name string) row format delimited fields terminated by '\t';
导入数据
load data local inpath '/root/mywork/hivetest/student.txt' into table student;
查看数据
select * from student;
日志(拷贝log4j修改日志路径)
配置元数据存储到mysql(注意把driver拷到hive lib下),显示db,表头
新建hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>work dir</description>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.0.105:3306/metastore_db?createDatabaseIfNotExist=true</value>
<description>connect url</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>driver class</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>mysql username</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>mysql password</description>
</property>
<property>
<name>hive.cli.print.header</name>
<value>true</value>
<description>show header</description>
</property>
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
<description>show db</description>
</property>
</configuration>
查看帮助
hive -help
查看hdfs文件
dfs -ls /;
查看linux文件
!ls /opt/module/datas;