Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2901

Infer schema from CSV header

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Creating external datasets from CSV files should be able to infer the attribute names from the file header if present and sample records for the data type. For example, in the create statement there could be an "infer" flag that takes in the number of records to scan like the below statement.

      CREATE EXTERNAL DATASET Employee() USING localfs (("path"="localhost:///employees.csv"), ("format"="delimited-text"), ("delimiter"=","), ("header"=true), ("infer"=10))

      Attachments

        Activity

          People

            tillw Till Westmann
            psinthon Gift Sinthong
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: