Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-1213

sort-merge join does not work for sub-queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Query Processor
    • None

    Description

      A query like:

      select count(1) from (select /*+ MAPJOIN */ from x join y ON ... ) subq;

      does not work - since there is no mapping between the join operator and the corresponding source

      Attachments

        1. Hive-1213.1.patch
          224 kB
          He Yongqiang
        2. Hive-1213.4.patch
          284 kB
          He Yongqiang
        3. Hive-1213.5.patch
          311 kB
          He Yongqiang
        4. Hive-1213.6.patch
          336 kB
          He Yongqiang
        5. Hive-1213.7.patch
          333 kB
          He Yongqiang
        6. Hive-1213.8.patch
          309 kB
          He Yongqiang
        7. Hive-1213.9.patch
          247 kB
          He Yongqiang

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1194 sorted merge join

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              namit Namit Jain
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: