create table database.tablename (
id int,
name string,
age int
birthday timestamp
) comment 'tablename' row format delimited fields terminated by '\t' lines terminated by '\n';
<!-- 文件导入数据或导出数据时,'\t'为列分隔符,'\n'为行分割符 -->
hive本地文件数据导入表命令: load data local inpath '../a.txt' [overwrite] into table tablename
5.hive 不支持select * from tablename group by columnname,
需要用join on连接。
select * from tablename t1 join (
select columnname from tablename groupby columnname having ...
) t2 on t1.columnname=t2.columnname;