Shulou(Shulou.com)06/03 Report--

This example takes hive as an example, which only considers implementation and has nothing to do with performance.

First create the table

12345678910111213141516171819202122232425CREATE TABLE orders (orderid INT,createtime STRING,modifiedtime STRING,status STRING) row format delimited fields terminated by'\ t 'CREATE TABLE ods_orders_inc (orderid INT,createtime STRING,modifiedtime STRING,status STRING) PARTITIONED BY (day STRING) row format delimited fields terminated by'\ t 'CREATE TABLE dw_orders_his (orderid INT,createtime STRING,modifiedtime STRING,status STRING,dw_start_date STRING,dw_end_date STRING) row format delimited fields terminated by'\ t'

First of all, a full update, we first to 2016-08-20 until the data.

Initialize, initialize the data of 2016-08-20 first.

1234INSERT overwrite TABLE ods_orders_inc PARTITION (day = '2016-08-20') SELECT orderid,createtime,modifiedtime,statusFROM ordersWHERE createtime

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.