Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1051

Support DDL parameter for inserting specified directory.

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • None
    • None
    • Expression, SQL Parser
    • None

    Description

      Currently, users just can write csv file with specified directory as follows:

      INSERT OVERWRITE INTO LOCATION '/dir/subdir' SELECT l_orderkey, l_quantity FROM lineitem;
      

      In above case, the output file has made by default csv file parameters. So, users can't use another field delimiter and compression options.

      Thus, we need to support that users can choice their table parameters as follows:

      INSERT OVERWRITE INTO LOCATION '/dir/subdir' 
      USING csv WITH ('csvfile.delimiter'='\u001','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
      SELECT l_orderkey, l_quantity FROM lineitem;
      

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            blrunner JaeHwa Jung
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: