[Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by PhiloVivero

[Apache Wiki <wi...@apache.org>]

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';