请教大神,以下的sql如何转换成hive sql啊?
drop table base.MD_CDR_WAP_DAY_01;
/*==============================================================*/
/* Table: MD_CDR_WAP_DAY_01 */
/*==============================================================*/
create table base.MD_CDR_WAP_DAY_01 (
DAY_NUMBER NUMERIC(2) null,
STAT_DATE NUMERIC(8) null,
REGIONCODE VARCHAR(12) null,
MSISDN VARCHAR(30) null,
URL VARCHAR(200) null,
CNT_WAP NUMERIC(15) null,
DATA_UP_DOWN NUMERIC(20) null,
BOSS_CITY NUMERIC(2) null
)
WITH (APPENDONLY=true, COMPRESSLEVEL=5, ORIENTATION=column, COMPRESSTYPE=zlib,
OIDS=FALSE
)
DISTRIBUTED BY (msisdn)
partition by list(day_number)
(
partition P_DAY_01 values (1) tablespace ts_tab_tmp_1001,
partition P_DAY_02 values (2) tablespace ts_tab_tmp_1001,
partition P_DAY_03 values (3) tablespace ts_tab_tmp_1001,
partition P_DAY_04 values (4) tablespace ts_tab_tmp_1001,
partition P_DAY_05 values (5) tablespace ts_tab_tmp_1001,
partition P_DAY_06 values (6) tablespace ts_tab_tmp_1001,
partition P_DAY_07 values (7) tablespace ts_tab_tmp_1001,
partition P_DAY_08 values (8) tablespace ts_tab_tmp_1001,
partition P_DAY_09 values (9) tablespace ts_tab_tmp_1001,
partition P_DAY_10 values (10) tablespace ts_tab_tmp_1001,
partition P_DAY_11 values (11) tablespace ts_tab_tmp_1001,
partition P_DAY_12 values (12) tablespace ts_tab_tmp_1001,
partition P_DAY_13 values (13) tablespace ts_tab_tmp_1001,
partition P_DAY_14 values (14) tablespace ts_tab_tmp_1001,
partition P_DAY_15 values (15) tablespace ts_tab_tmp_1001,
partition P_DAY_16 values (16) tablespace ts_tab_tmp_1001,
partition P_DAY_17 values (17) tablespace ts_tab_tmp_1001,
partition P_DAY_18 values (18) tablespace ts_tab_tmp_1001,
partition P_DAY_19 values (19) tablespace ts_tab_tmp_1001,
partition P_DAY_20 values (20) tablespace ts_tab_tmp_1001,
partition P_DAY_21 values (21) tablespace ts_tab_tmp_1001,
partition P_DAY_22 values (22) tablespace ts_tab_tmp_1001,
partition P_DAY_23 values (23) tablespace ts_tab_tmp_1001,
partition P_DAY_24 values (24) tablespace ts_tab_tmp_1001,
partition P_DAY_25 values (25) tablespace ts_tab_tmp_1001,
partition P_DAY_26 values (26) tablespace ts_tab_tmp_1001,
partition P_DAY_27 values (27) tablespace ts_tab_tmp_1001,
partition P_DAY_28 values (28) tablespace ts_tab_tmp_1001,
partition P_DAY_29 values (29) tablespace ts_tab_tmp_1001,
partition P_DAY_30 values (30) tablespace ts_tab_tmp_1001,
partition P_DAY_31 values (31) tablespace ts_tab_tmp_1001
);
ALTER TABLE base.MD_CDR_WAP_DAY_01 OWNER TO base;