hive 将查询的结果存为新表

create table itcast_ods.tmp as SELECT
    count(ip) c,
    ip
    FROM itcast_ods.web_acc_info
 GROUP BY ip
  order by  c desc

几种保存Hive查询结果的方法 - 又尘埃 - 博客园 (cnblogs.com)