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

Backport HIVE-15239 to branch-1

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 1.2.0, 2.1.0
    • 1.3.0
    • Spark
    • 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

              niklaus.xiao Niklaus Xiao
              niklaus.xiao Niklaus Xiao
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: