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 CarlSteinbach
Date Fri, 11 Jun 2010 01:04:49 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 CarlSteinbach.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=63&rev2=64

--------------------------------------------------

  
  row_format
    : DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY char]
-         [MAP KEYS TERMINATED BY char]
+         [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
    | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, property_name=property_value,
...)]
  
  file_format:
@@ -66, +66 @@

  
  You can create tables with custom SerDe or using native SerDe. A native SerDe is used if
ROW FORMAT is not specified or ROW FORMAT DELIMITED is specified. You can use the DELIMITED
clause to read delimited files. Use the SERDE clause to create a table with custom SerDe.
Refer to SerDe section of the User Guide for more information on SerDe.
  
- You must specify list of a columns for tables with native SerDe. Refer to the Types part
of the User Guide for the allowable column types. A list of columns for tables with custom
SerDe may be specified but Hive will query the SerDe to determine the actual list of columns
for this table.
+ You must specify a list of a columns for tables that use a native SerDe. Refer to the Types
part of the User Guide for the allowable column types. A list of columns for tables that use
a custom SerDe may be specified but Hive will query the SerDe to determine the actual list
of columns for this table.
  
  Use STORED AS TEXTFILE if the data needs to be stored as plain text files. Use STORED AS
SEQUENCEFILE if the data needs to be compressed. Please read more about [[Hive/CompressedStorage]]
if you are planning to keep data compressed in your Hive tables.  Use INPUTFORMAT and OUTPUTFORMAT
to specify the name of a corresponding InputFormat and OutputFormat class as a string literal,
e.g. 'org.apache.hadoop.hive.contrib.fileformat.base64.Base64TextInputFormat'.
  

Mime
View raw message