Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/DDL" page has been changed by PhiloVivero. The comment on this change is: When I try to create partitions as files... FAIL.. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=86&rev2=87 -------------------------------------------------- partition_spec: : PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...) }}} - You can use ALTER TABLE ADD PARTITION to add partitions to a table. Partition values should be quoted only if they are strings. + You can use ALTER TABLE ADD PARTITION to add partitions to a table. Partition values should be quoted only if they are strings. The location must be a directory inside of which data files reside. {{{ ALTER TABLE page_view ADD PARTITION (dt='2008-08-08', country='us') location '/path/to/us/part080808' PARTITION (dt='2008-08-09', country='us') location '/path/to/us/part080809';
