sql将1个表的数据插入另一个表

mysql

(1) create table tableName as (select xxxxx)

(2)insert overwrite table sale_detail_insert partition (sale_date='2013', region='china')

select shop_name, customer_id, total_price from sale_detail zorder by customer_id, total_price;

kudu

（注意：kudu的primary key，必须放在 字段第一位

create table test.dwd_hs_db_lc1 primary key(eventcode) PARTITION BY HASH (eventcode) PARTITIONS 5 STORED AS KUDU TBLPROPERTIES ('kudu.master_addresses'='bigdata001,bigdata002,bigdata003') AS select xxxxx