Hive常用sql

1、查看hive建表语句：show create table tablename;

2、查看hive表结构：describe  tablename; 简写：desc tablename;

3、快速建表语句：create table tablename as select  *  from tablename