#修改hive-site.xml文件,指定MySQL数据库驱动、数据库名、用户名及密码,修改的内容如下所示 <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.1.178: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>hive</value> <description>password to use against metastore database</description> </property>
hive> SHOW TABLES; OK testuser Time taken: 0.707 seconds, Fetched: 1 row(s)
hive> DESC testuser; OK id int username string Time taken: 0.38 seconds, Fetched: 2 row(s) hive> SELECT * from testuser limit 10; OK 1 sssss 1 sssss Time taken: 0.865 seconds, Fetched: 2 row(s) hive>
hive> select count(1) from testuser; Query ID = hadoop_20160205004747_9d84aaca-887a-43a0-bad9-eddefe4e2219 Total jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1454604205731_0001, Tracking URL = http://Master:8088/proxy/application_1454604205731_0001/ Kill Command = /usr/local/hadoop/bin/hadoop job -kill job_1454604205731_0001 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1 2016-02-0500:48:11,942 Stage-1 map = 0%, reduce = 0% 2016-02-0500:48:19,561 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 1.38 sec 2016-02-0500:48:28,208 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 2.77 sec MapReduce Total cumulative CPU time: 2 seconds 770 msec Ended Job = job_1454604205731_0001 MapReduce Jobs Launched: Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 2.77 sec HDFS Read: 6532 HDFS Write: 2 SUCCESS Total MapReduce CPU Time Spent: 2 seconds 770 msec OK 2 Time taken: 35.423 seconds, Fetched: 1 row(s)