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 ZhengShao
Date Tue, 22 Dec 2009 00:33:57 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 ZhengShao.
The comment on this change is: Remove "LINES TERMINATED BY" since it's not possible to support
without hadoop changes.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=22&rev2=23

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

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

   PARTITIONED BY(dt STRING, country STRING) 
   ROW FORMAT DELIMITED 
     FIELDS TERMINATED BY '\001' 
-    LINES TERMINATED BY '\012' 
  STORED AS SEQUENCEFILE;
  }}}
  
- The above statement lets you to create same table as previous table but the lines are delimited
by '\012' instead of newline.
+ The above statement lets you to create same table as previous table.
  
  {{{
  CREATE TABLE page_view(viewTime INT, userid BIGINT, 
@@ -104, +103 @@

     FIELDS TERMINATED BY '\001' 
     COLLECTION ITEMS TERMINATED BY '\002' 
     MAP KEYS TERMINATED BY '\003' 
-    LINES TERMINATED BY '\012' 
   STORED AS SEQUENCEFILE;
  }}}
  
@@ -118, +116 @@

       ip STRING COMMENT 'IP Address of the User', 
       country STRING COMMENT 'country of origination') 
   COMMENT 'This is the staging page view table' 
-  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' LINES TERMINATED BY '\012' 
+  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054'
   STORED AS TEXTFILE 
   LOCATION '<hdfs_location>';
  }}}

Mime
View raw message