hive创建分区表

hive创建分区表

create EXTERNAL table if not exists hive_eventpush01(
    accountNumber string,
    activities string,
    cardNumber string,
    customerId string,
    eventcode string,
    eventTime string,
    lables string,
    scenarioCode string
)
    PARTITIONED BY (`dt` STRING)
    STORED AS parquet;
drop table hive_eventpush01;
show tables ;

create EXTERNAL table if not exists hive_eventpush01(
    accountNumber string,
    activities string,
    cardNumber string,
    customerId string,
    eventcode string,
    eventTime string,
    lables string,
    scenarioCode string,
    dt string
)
    PARTITIONED BY (`dt` STRING)
    STORED AS parquet;
drop table hive_eventpush01;
show tables ;

第二种会报错

org.apache.hadoop.hive.ql.parse.SemanticException:Column repeated in partitioning columns