????1.hive??????
????2.????mysql???
????3.??root???????mysql?????У?mysql -uroot -p?????????????
????4.????hive????????create database metahive??????????metahive??
????5.????hive?????create user hive@‘localhost’ identified by ‘hive’??mysql???hive????user????hive?????????hive??
????6.????????grant all privileges on metahive.* to hive;flush privileges;
????7.???root?????quit;
????8.???hive??????mysql??mysql -uhive -p?????????????
???????????show databases???????????metahive????????OK!??
????9.????hive?????????hive-site.xml?????
????9.1.??hive??conf??????е?hive-default.xml.template????????hive-site.xml?????cp hive-default.xml.template hive-site.xml
????9.2.????hive-site.xml?????vim hive-site.xml
???????????property?????????????????hive??????????????????derby??????????mysql??

 

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/?????????createDatabaseIfNotExist=true</value>
<description>JDBCconnectstringforaJDBCmetastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>DriverclassnameforaJDBCmetastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>mysql???hive?????????</value>
<description>usernametouseagainstmetastoredatabase</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>passwordtouseagainstmetastoredatabase</description>
</property>

????10.????????????/etc/profile??????redhat OS?μ?.bash_profile??ubuntu OS?μ?.bashrc???????HIVE_HOME??hive???·????bin???????
????------------------------------------------------------------------???????????????????????????????????????????????????????-----------------------------------------------------
????11.????hive cli????????????hive
????12.??hive?н??????test??create table test??id int??name string??row format delimited fields terminated by ' ' lines terminated by ' ' stored as textfile;