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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: