Quanlong Huang created IMPALA-13464:
---------------------------------------
Summary: Support STORED AS CSV/TSV
Key: IMPALA-13464
URL: https://issues.apache.org/jira/browse/IMPALA-13464
Project: IMPALA
Issue Type: New Feature
Components: Frontend
Reporter: Quanlong Huang
It'd be helpful to add a syntactic sugar for creating CSV/TSV tables. Users
just need to remember "STORED AS CSV", e.g.
{code:sql}
create table my_csv_tbl(first_name string, age int)
stored as csv;{code}
instead of a long statement like this
{code:sql}
create table my_csv_tbl(first_name string, age int)
row format delimited fields terminated by ','
stored as textfile;{code}
For CSV files that have a header line, we add the tbl property
'skip.header.line.count'='1' to handle it. It'd also be helpful to add a
syntactic sugar for it, e.g. STORED AS CSV_WITH_HEADER.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
