hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by PhiloVivero
Date Mon, 02 May 2011 22:13:56 GMT
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';

Mime
View raw message