row_format

Syntax

ROW FORMAT DELIMITED

[FIELDS TERMINATED BY separator]

[COLLECTION ITEMS TERMINATED BY separator]

[MAP KEYS TERMINATED BY separator] [LINES TERMINATED BY separator]

[NULL DEFINED AS separator]

| SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, property_name=property_value, ...)]

Description

• separator indicates the separator or substitute character in the syntax. Only the CHAR type is supported.
• FIELDS TERMINATED BY specifies the delimiter of field levels in a table. Only the CHAR type is supported.
• COLLECTION ITEMS TERMINATED BY specifies the delimiter of the set level. Only the CHAR type is supported.
• MAP KEY TERMINATED BY specifies the separator between the key and value in the MAP type. Only the CHAR type is supported.
• LINES TERMINATED BY indicates the separator between lines. Currently, only \n is supported.
• The NULL DEFINED AS clause can be used to specify the NULL format.
• The SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, property_name=property_value, ...)] You can use the following statement to convert the NULL value to an empty string.

  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' with serdeproperties('serialization.null.format' = '')