Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5775 Introduce Cost Based Optimizer to Hive
  3. HIVE-8159

CBO: bail from Optiq planning if a Select list contains multiple references to the same name

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.14.0
    • CBO
    • None

    Description

      Optiq explicitly disallows this:

      select x, x from t1

      This is allowed in Hive (and also in mysql). Will check in Postgres. For now bailing from Optiq planning if we see this. Will file an Optiq issue.

      Attachments

        1. HIVE-8159.cbo.patch
          6 kB
          Ashutosh Chauhan

        Issue Links

          is a clone of

          Sub-task - The sub-task of the issue HIVE-8145 CBO: bail from Optiq planning if a Select list contains multiple references to the same name

          • Major - Major loss of function.
          • Closed
          links to

          Web Link RB request

          Activity

            People

              ashutoshc Ashutosh Chauhan
              ashutoshc Ashutosh Chauhan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: