Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://spark.apache.org/docs/latest/sql-ref-syntax-hive-format.html below:

Hive Row Format - Spark 4.0.0 Documentation

Spark supports a Hive row format in CREATE TABLE and TRANSFORM clause to specify serde or text delimiter. There are two ways to define a row format in row_format of CREATE TABLE and TRANSFORM clauses.

1. SERDE clause to specify a custom SerDe class.
2. DELIMITED clause to specify a delimiter, an escape character, a null character, and so on for the native SerDe.

row_format:    
    SERDE serde_class [ WITH SERDEPROPERTIES (k1=v1, k2=v2, ... ) ]
    | DELIMITED [ FIELDS TERMINATED BY fields_terminated_char [ ESCAPED BY escaped_char ] ] 
        [ COLLECTION ITEMS TERMINATED BY collection_items_terminated_char ] 
        [ MAP KEYS TERMINATED BY map_key_terminated_char ]
        [ LINES TERMINATED BY row_terminated_char ]
        [ NULL DEFINED AS null_char ]

• SERDE serde_class

  Specifies a fully-qualified class name of custom SerDe.

• SERDEPROPERTIES

  A list of key-value pairs that is used to tag the SerDe definition.

• FIELDS TERMINATED BY

  Used to define a column separator.

• COLLECTION ITEMS TERMINATED BY

  Used to define a collection item separator.

• MAP KEYS TERMINATED BY

  Used to define a map key separator.

• LINES TERMINATED BY

  Used to define a row separator.

• NULL DEFINED AS

  Used to define the specific value for NULL.

• ESCAPED BY

  Used for escape mechanism.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4