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

["Surya Hebbar (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-13464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Surya Hebbar reassigned IMPALA-13464:
-------------------------------------

    Assignee: Surya Hebbar

> 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
>            Assignee: Surya Hebbar
>            Priority: Major
>              Labels: ramp-up
>
> 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