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

UNION will translated to UNION ALL in Jdbc

    XMLWordPrintableJSON

    Details

      Description

      If the UseNativeQuery=0, the UNION will be translated to UNION ALL instead of UNION DISTINCT if there are duplicates in one side of the union.

      For example Q1 will return set A where there are two records of X, and Q2 will return set B where there is one record of X.
      Q1 UNION Q2 should be equal to Q1 UNION DISTINCT Q2 where we have one record of X.
      But, using the impala jdbc driver (2.5.28) it behaves as Q1 UNION ALL Q2 if UseNativeQuery=0

        Attachments

          Activity

            People

            • Assignee:
              shashmi Syed A. Hashmi
              Reporter:
              moazami.afshin@gmail.com Afshin Moazami
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: