select SrcIP,DstIP,RecTime from (select get_json_object(json,'RecTime') RecTime ,get_json_object(json,'SrcIP') SrcIP,get_json_object(json,'DstIP') DstIP from tmp_json_test t) t2 distribute by SrcIP,DstIP sort by RecTime;
原因:hive本身缺陷,需要在每个子查询后面加别名。
select SrcIP,DstIP,RecTime from (select get_json_object(json,'RecTime') RecTime ,get_json_object(json,'SrcIP') SrcIP,get_json_object(json,'DstIP') DstIP from tmp_json_test t) t2 distribute by SrcIP,DstIP sort by RecTime;
原因:hive本身缺陷,需要在每个子查询后面加别名。