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 AlexSmith
Date Fri, 27 Feb 2009 00:43:16 GMT
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 ===
  {{{

Mime
View raw message