Delimited Tables¶
These are the delimited tables.
DDL Statement (AWS)¶
create external table nation_s3_txt
(N_NATIONKEY INT, N_NAME STRING, N_REGIONKEY INT, N_COMMENT STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
STORED AS TEXTFILE
LOCATION 's3://qtest-qubole-com/datasets/presto/functional/nation_s3_txt';
Features¶
The features of delimited table are:
- Entire record must be one line in text file
- Field delimiter configurable through DDL
- Delimited files may be compressed using gzip, bzip2 or lzo