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

Support DDL parameter for inserting specified directory.

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Expression, SQL Parser
    • Labels:
      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

            People

            • Assignee:
              Unassigned
              Reporter:
              blrunner Jaehwa Jung
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: