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

if partition have the same data location,quey will ignore the former one

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 2.1.1
    • None
    • Query Planning
    • None

    Description

      Hi 

      I have a weird thing,the bevior shows like this:

      1) create table test1(id int) partitioned by (year int);

      2) insert overwrite table test1 partition(year=2020) select 1;

      3) check the location of partition 2020,so as '/A/B';

      4) alter table test1 add partition(year=2021) location '/A/B'

      5)check the data

      6)check partitrions

      7)check data from different partitions

      8)The question is,when we check the count,the result sames wrong :

      hive> select year,count(1) as cnt from test1 group by year;

      OK
      2021 1
      Time taken: 9.524 seconds, Fetched: 1 row(s)
      hive>

       

      Can anyone help review whether we have fixed this issue in furture?

       

      Thansk in advance!

       

       

       

      Attachments

        1. image-2020-03-26-14-45-22-717.png
          3 kB
          philipse
        2. image-2020-03-26-14-45-33-112.png
          18 kB
          philipse
        3. image-2020-03-26-14-45-44-959.png
          11 kB
          philipse
        4. image-2020-03-26-14-46-01-562.png
          52 kB
          philipse
        5. image-2020-03-26-14-48-02-096.png
          7 kB
          philipse

        Activity

          People

            Unassigned Unassigned
            小郭飞飞刀 philipse
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: