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>'; }}}
