[jira] [Created] (IMPALA-13464) Support STORED AS CSV/TSV

["Quanlong Huang (Jira)" <ji...@apache.org>]

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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org