特别注意:要谨慎使用overwrite关键字,特别是它与目录结合的时候,路径不要搞错了,否则目录下的文件直接被覆盖了
hive> insert into area_t values('1','1','1',now(),'1','1',2,2);
NoViableAltException(26@[])
结论:不支持此种用法
hive> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 from area limit 15;
结论:追加方式
hive> insert overwrite table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 from area limit 15;
结论:覆盖的方式
hive> insert overwrite directory '/user/lifeng' select * from area;
结论:不能用into、目录要用引号包含
hive> from area
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 limit 10;
结论:基本模式的用法
hive> from area
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 limit 10
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 order by areacode desc limit 15;
FAILED: SemanticException [Error 10087]: The same output cannot be present multiple times: area_t
hive> select all parentcode from area order by parentcode limit 20;
结论:排序后再选取前面的20条记录,order by 全局排序,只有一个Reduce任务
hive> select all parentcode from area sort by p
hive> insert into area_t values('1','1','1',now(),'1','1',2,2);
NoViableAltException(26@[])
结论:不支持此种用法
hive> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 from area limit 15;
结论:追加方式
hive> insert overwrite table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 from area limit 15;
结论:覆盖的方式
hive> insert overwrite directory '/user/lifeng' select * from area;
结论:不能用into、目录要用引号包含
hive> from area
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 limit 10;
结论:基本模式的用法
hive> from area
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 limit 10
> insert into table area_t select areacode,areaname,'1',gxrq,parentcode,bz,flags,flags1 order by areacode desc limit 15;
FAILED: SemanticException [Error 10087]: The same output cannot be present multiple times: area_t
结论:使用多插入模式时,不能插入相同的表
所有查询都不会显示列头(即字段名)
hive> select [all] parentcode from area limit 20;
结论:查询所有记录hive> select all parentcode from area order by parentcode limit 20;
结论:排序后再选取前面的20条记录,order by 全局排序,只有一个Reduce任务
hive> select all parentcode from area sort by p