???mysql???hive????????
???????????? ???????[ 2014/2/8 10:59:50 ] ???????????? ???????
????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;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11