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/DML" by PeterSkomoroch
Date Sat, 06 Jun 2009 05:43:22 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 PeterSkomoroch:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DML

------------------------------------------------------------------------------
  ===== Synopsis =====
   * directory can be full URI. If scheme or authority are not specified, Hive will use the
scheme and authority from hadoop configuration variable `fs.default.name` that specifies the
Namenode URI.
   * if LOCAL keyword is used - then Hive will write data to the directory on the local file
system. 
-  * Data written to the filesystem is serialized as text with columns separated by ^A and
rows separated by newlines.  This default format can be changed by choosing a different format
in the table CREATE statement (for example: FIELDS TERMINATED BY '\t'). If any of the columns
are not of primitive type - then those columns are serialized to JSON format.
+  * Data written to the filesystem is serialized as text with columns separated by ^A and
rows separated by newlines. If any of the columns are not of primitive type - then those columns
are serialized to JSON format.
  
  ===== Notes =====
   * Insert statements to directories, local directories and tables (or partitions) can all
be used together within the same query.

Mime
View raw message