e1: sogou 500w数据,创建一张表sogou_20111230, 这张表在sogou这个数据库中, 注意,6个字段的数据类型. create table t1(id STRING,name STRING,age INT) > ROW FORMAT DELIMITED //delimited 分隔 > FIELDS TERMINATED BY '\t' // terminated 终止 > LOCATION '/xuhaifeng'; create table sogou_20111230(time STRING,uid STRING, keyword STRING,rank INT,order INT,url STRING) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY '\t' > LOCATION '/sogou'; select uid FROM sogou_20111230 limit 10; e2: 把sogou 500w的数据放到表中,并执行下面的查询, 查询前100行数据 select * from sogou.sogou_20111230 limit 100; reate table sogou_20111230_2(time STRING,uid STRING, keyword STRING,rank INT,order INT,url STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/sogou'; select * from sogou_20111230_2 limit 10