Is it possible to convert a hive partition field into a Druid dimension during ingestion?

Now, I have a partitioned hive table described here:

CREATE TABLE user_temp. payment_summary (

appid string,

base_users int,

pay_users int,

pay_amounts float,)

PARTITIONED BY (

dt string,

country string,

)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ‘\t’

LINES TERMINATED BY ‘\n’

STORED AS INPUTFORMAT

‘org.apache.hadoop.mapred.TextInputFormat’

OUTPUTFORMAT

‘org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat’

LOCATION

‘hdfs://tcdh-name-service-1/user/hive/warehouse/user_temp.db/payment_summary’;

I plan to do the data ingestion from this partitioned hive table.

The partition field dt is a yyyy-mm-dd format date string. How can I convert the field ds and country into Druid dimensions during ingestion?

Hello Druid Friend!

I believe a good place to start would be to look at that change during ingestion via transformspec - https://druid.apache.org/docs/latest/ingestion/transform-spec.html.