hive搭建

hive是依赖于hadoop的数据仓库的工具，sql语句转换成mapreduce进行计算，存储在hdfs上

搭建hive

前期准备

配置jdk环境，hadoop环境，下载hive包解压，配置hive环境变量，安装mysql

修改hive配置文件

将hive-default.xml.template文件cp一份为hive-site.xml  

修改hive-site.xml

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.1.106:3306/hive?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>


<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>


<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
  <description>username to use against metastore database</description>
</property>




<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>root</value>
  <description>password to use against metastore database</description>
</property>

把mysql驱动包mysql-connector-java-5.1.17.jar放入lib目录

执行hive

进入后创建数据库，表，执行简单sql命令