You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/02/27 01:43:16 UTC

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

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by AlexSmith:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL

The comment on the change is:
add bucketed table warning

------------------------------------------------------------------------------
   LOCATION '<hdfs_location>';
  }}}
  
- You can use above statement to create page_view table which points to data location any hdfs location. But you have to make sure that the data is delimited as specified in the query above. 
+ You can use above statement to create page_view table which points to data location any hdfs location. But you have to make sure that the data is delimited as specified in the query above.
+ 
+ ==== Inserting Data Into Bucketed Tables ====
+ The CLUSTER BY and SORTED BY creation commands do not effect how data is inserted into a table -- only how it is read.  This means that users must actively insert data correctly by specifying the number of reducers to be equal to the number of buckets, and using CLUSTER BY and SORT BY commands in their query.
  
  === Drop Table ===
  {{{