Affects Version/s: 3.6.0
Fix Version/s: 3.9.0
CDH5.1 using an external metastore on postgresql. External Hive table with partitions.
When I use the function "Show Partitions" in the Metastore Manager I get presented with a list of the available partitions but it seems like the path presented is not correct in my case.
I create a partition like so:
ALTER TABLE MyTable ADD PARTITION (part_col=1234) location '/x/y/z/1/1234';
Hue shows me the following path to the created partition:
The correct path to the partition is:
If I follow the path link it points me to a folder that does not exist.
My create table statement looks like so:
CREATE EXTERNAL TABLE IF NOT EXISTS MyTable (
PARTITIONED BY (part_col INT)
ROW FORMAT SERDE 'myserde'
STORED AS INPUTFORMAT 'myinputformat' OUTPUTFORMAT 'myoutputformat'
Seem like Hue uses the base location for the table and then assumes that the folders storing the partitions will be named using the convention part_col=nnnn which might be common but not mandatory.
- is duplicated by
HUE-2815 Metastore Manager shows incorrect partition path for custom partition locations