Hadoop生态圈Hive的基本使用

1、Hive最基本的建表语句

CREATE TABLE top100 ( time STRING,name STRING,ip STRING,UID STRING, ADDRESS STRING) COMMENT 'top100w';

2、加载数据

LOAD DATA  INPATH '/test/smittest.txt' OVERWRITE INTO TABLE top100w;

3、查询

select * from top100w limit 100;