Apache Hive处理数据示例

xiaoyu28

　　0: jdbc:hive2://> CREATE TABLE userinfo ( uname STRING, pswd STRING, uid INT, gid INT, fullname STRING, hdir STRING, shell STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ':' STORED AS TEXTFILE;
　　0: jdbc:hive2://> LOAD DATA INPATH '/tmp/passwd' OVERWRITE INTO TABLE userinfo;
　　0: jdbc:hive2://> select uname,fullname,hdir from userinfo order by unmame;
　　MapReduce Jobs Launched:
　　Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 27.83 sec HDFS Read: 8767 HDFS Write: 1454 SUCCESS
　　Total MapReduce CPU Time Spent: 27 seconds 830 msec
　　OK
　　+----------------+-------------------------------+-------------------------------+--+
　　| uname | fullname | hdir |
　　+----------------+-------------------------------+-------------------------------+--+
　　| abrt | | /etc/abrt |
　　| adm | adm | /var/adm |
　　| apache | Apache | /var/www |
　　| avahi-autoipd | Avahi IPv4LL Stack | /var/lib/avahi-autoipd |
　　| bin | bin | /bin |
　　| cloudera | | /home/cloudera |
　　| cloudera-scm | Cloudera Manager | /var/lib/cloudera-scm-server |
　　...