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

Backport HIVE-15239 to branch-1

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0, 2.1.0
    • Fix Version/s: 1.3.0
    • Component/s: Spark
    • Labels:
      None

      Description

      env: hive on spark engine
      reproduce step:

      create table a1(KEHHAO string, START_DT string) partitioned by (END_DT string);
      create table a2(KEHHAO string, START_DT string) partitioned by (END_DT string);
      
      alter table a1 add partition(END_DT='20161020');
      alter table a1 add partition(END_DT='20161021');
      
      insert into table a1 partition(END_DT='20161020') values('2000721360','20161001');
      
      
      SELECT T1.KEHHAO,COUNT(1) FROM ( 
      SELECT KEHHAO FROM a1 T 
      WHERE T.KEHHAO = '2000721360' AND '20161018' BETWEEN T.START_DT AND T.END_DT-1 
      UNION ALL 
      SELECT KEHHAO FROM a2 T
      WHERE T.KEHHAO = '2000721360' AND '20161018' BETWEEN T.START_DT AND T.END_DT-1 
      ) T1 
      GROUP BY T1.KEHHAO 
      HAVING COUNT(1)>1; 
      
      +-------------+------+--+
      |  t1.kehhao  | _c1  |
      +-------------+------+--+
      | 2000721360  | 2    |
      +-------------+------+--+
      

      the result should be none record

        Attachments

        1. HIVE-15389.branch-1.1.patch
          13 kB
          Niklaus Xiao

          Issue Links

            Activity

              People

              • Assignee:
                niklaus.xiao Niklaus Xiao
                Reporter:
                niklaus.xiao Niklaus Xiao
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: