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

ADD PARTITION doesn't accept SET FORMAT

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.3.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Epic Color:
      ghx-label-14

      Description

      The Impala docs say this should work, however, I get an error:

      alter table tbl_name add partition (i=3) set fileformat orc;
      ERROR: ParseException: Syntax error in line 1:
      ..._name add partition (i=3) set fileformat orc
                                   ^
      Encountered: SET
      Expected: CACHED, LOCATION, PARTITION, UNCACHEDCAUSED BY: Exception: Syntax error

       

      There is a workaround to create the partition first with the default fileformat of the table and in a separate step change the format:

      alter tbl_name add partition (i=2);
      alter table tbl_name partition (i=2) set fileformat orc;
      +-------------------------+
      | summary                 |
      +-------------------------+
      | Updated 1 partition(s). |
      +-------------------------+

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gaborkaszab Gabor Kaszab
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: