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

Insert into/overwrite [SHUFFLE] hint is not applied unless the partition is not specified

    XMLWordPrintableJSON

    Details

      Description

      Queries that insert into partitions of the form:

      insert overwrite table_name partition(p=2)
      [shuffle]
      select col1, col2 from table_name where p=1

      or

      insert overwrite table_name partition(p=1)
      [shuffle]
      select col1, col2, '2' as p from table_name where p=1

      both have the [shuffle] hint ignored in the query plan. In order to get the shuffle hint to work you must use the following form

      insert overwrite table_name partition(p)
      [shuffle]
      select col1, col2, '2' as p from table_name where p=1

      which means you can't copy from one partition to another as the first two queries are.

        Attachments

          Activity

            People

            • Assignee:
              alex.behm Alexander Behm
              Reporter:
              PeterEbert Peter Ebert
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: