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

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-8145.1.patch
          2 kB
          Harish Butani

        Issue Links

          Activity

            People

              rhbutani Harish Butani
              rhbutani Harish Butani
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: