How to create multiple hierarchy partitions in Hive?

asked 2018-03-21 03:34:15 -0500

casel.chen gravatar image

updated 2018-03-21 03:45:35 -0500

I want to know how to create multiple hierarchy partitions when drift into Hive with StreamSets DC?

Here is my create hive table statement: CREATE EXTERNAL TABLE overdue_event_table_2 (...) PARTITIONED BY (tenantId string, dt string) ...

Why it will create files in the path as following? hdfs://host:port/xxx/tenantId=/dt=2018-03-21-16 It seems no tenantId value in partition path, but I confirmed that tenantId field has value in my data.

Hive Metadata

image description

Hadoop FS

image description

edit retag flag offensive close merge delete