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

Support insert plan hints for CREATE TABLE AS SELECT

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.5.0, Impala 2.4.0, Impala 2.6.0, Impala 2.7.0
    • Fix Version/s: Impala 3.0, Impala 2.12.0
    • Component/s: Frontend
    • Labels:

      Description

      In order to tune ETL processes we should also support the same plan hints for CREATE TABLE AS SELECT (CTAS) statements that we already support for INSERT statements. Otherwise, the convenience of a CTAS may be somewhat lost, or the generated data may not be as efficient as it could be with CREATE + INSERT + hints.

      The placement of the hint should be as in Oracle's syntax:

      CREATE /*+ clustered  sort(day,hour) */ TABLE t AS
      SELECT * from src;
      

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              csringhofer Csaba Ringhofer
              Reporter:
              alex.behm Alexander Behm

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment