select count(*) from dwrstj;

select date_format(ssqq, 'y') as y, * from gsmx limit 10;

select count(*) from gsmx;

select date_format(ssqq, 'y') as y, count(*) as c from gsmx group by date_format(ssqq, 'y');

select djxh,cast(y as int) as y, pjgz from dwrstj3 order by djxh,y limit 100;

create table gsmxSample as select * from gsmx limit 10;

select * from gsmxSample limit 100;

truncate table gsmxSample;

load data inpath 'obs://gsmx/GeShuiSample.csv' into table  gsmxSample options('DATA_TYPE'='CSV','HEADER'='true');

select count(*) as c from gsmxsample;

create table gsmx  as select * from gsmxSample where year(ssqq)>=2006;

select date_format(ssqq, 'y') as y, count(*) as c from gsmx group by date_format(ssqq, 'y') order by date_format(ssqq, 'y');

drop table gsmxsample;

load data inpath 'obs://gsmx/airpassengers.csv' into table  gsmxSample options('DATA_TYPE'='CSV','HEADER'='true');