Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-13464

Support STORED AS CSV/TSV

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Frontend
    • ghx-label-3

    Description

      It'd be helpful to add a syntactic sugar for creating CSV/TSV tables. Users just need to remember "STORED AS CSV", e.g.

      create table my_csv_tbl(first_name string, age int)
      stored as csv;

      instead of a long statement like this

      create table my_csv_tbl(first_name string, age int)
      row format delimited fields terminated by ','
      stored as textfile;

      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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            stigahuang Quanlong Huang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: