tar -zxvf apache-hive-1.2.1-bin.tar.gz
mv apache-hive-1.2.2-bin hive
hive>create table t_first (id int, name string,salary string) ;
7.hive配置元数据库MySQL
将这个jar放到Linux 安装的hive/lib中
cp hive-default.xml.template hive-site.xml
将原有文件的内容删掉写入如下代码：
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.17.131:3306/hive?createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>123456</value> </property> </configuration>
原文：https://www.cnblogs.com/wf1647790534/p/9337762.html