SQL语句

desc [表明]; 获得表中的字段;
获得创建表的结构: show create table [表名];
如下:

命令:show create table tbl_play_pt;
获得如下:
CREATE EXTERNAL TABLE tbl_play_pt(
  ip string, 
  time string, 
  cookie string, 
  inu string, 
  country string, 
  area string, 
  province string, 
  city string, 
)
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
  'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileOutputFormat';

创建新表:复制以上创建表的内容,改下表名.

复制表的内容到目标表: insert into table [目标表] select * from [源表] where …;

create table default.tbl_c as select a.p1,a.p2,a.app,count() from tbl_a a left outer join default.tbl_b b on (a.mac = b.deviceid and a.p1=b.p1 and a.p2=b.p2) group by a.p1,a.p2,a.app having count()>100;