hive,查询后写入表中

hive> insert overwrite table sales_info_new partition(dt='2019-04-26') 
    > select sku_id,sku_name,category_id3,price,sales_count 
    > from sales_info where dt = '2019-04-26';

目的表，建表语句：

CREATE TABLE `sales_info_new`(
`sku_id` string COMMENT '商品id', 
`sku_name` string COMMENT '商品名称', 
`category_id3` string COMMENT '三级分类id', 
`price` double COMMENT '销售价格', 
`sales_count` bigint COMMENT '销售数量'
)
COMMENT '商品销售信息表'
PARTITIONED BY(
`dt` string)
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ',' 
NULL DEFINED AS '' 
STORED AS TEXTFILE
LOCATION
'hdfs://ns1/abc/sales_info_new'

原表数据：

hive> select *  from sales_info;
OK
sku_id	sku_name	category_id3	price	sales_count	dt
12377	华为Ma