hive的配置及使用

Hive的配置过程：

 

 

<configuration>
 <property>

    <name>javax.jdo.option.ConnectionURL</name>

    <value>jdbc:mysql://192.168.60.29: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>hive</value>

    <description>username to use against metastore database</description>

</property>

<property>

    <name>javax.jdo.option.ConnectionPassword</name>

    <value>111111</value>

    <description>password to use against metastore database</description>

</property>
<property>
    <name>hive.metastore.uris</name>
    <value>thrift://192.168.60.29:9083</value>
</property>

</configuration>

 

 

Hive的启动过程：

    hive --service metastore

    hive --service hiveserver

 

 

Hive的建表：

create table click_cancel(apik int, style STRING, operator STRING, program STRING, time STRING)     COMMENT 'click_cancel'
ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '
collection items terminated by "\n"
STORED AS TEXTFILE
LOCATION '/data/uid';

 

Hive的加载数据：

LOAD DATA INPATH '/home/hduser/data_smit/click_cancel.txt' OVERWRITE INTO TABLE click_cancel;

 

查询过程：

select * from click_cancel limit 100;