hive 常用操作

1。创建表

    内部表        CREATE  TABLE IF NOT EXISTS hibernate.student( id string ,       age string ,       name string      )       ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ;      外部表     CREATE  external TABLE IF NOT EXISTS hibernate.student_text(   id string ,       age string ,       name string      )       ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ;      外部表使用存储parquet格式     CREATE  external TABLE IF NOT EXISTS hibernate.student_parquet(id string ,       age string ,       name string      ) stored as PARQUET;

2.加载数据

 直接从本地加载数据 load data local inpath '/home/hadoop/data.txt'  into table  student; 查询加载数据     insert into table hibernate.student_parquet select id,age,name from hibernate.student;