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

In Tez mode,dynamic partitioning query with union all fails at moveTask,Invalid partition key & values

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.2.1, 1.3.0, 2.0.0
    • Component/s: Tez
    • Labels:
      None

      Description

      create table dummy(i int);
      insert into table dummy values (1);
      select * from dummy;
      
      create table partunion1(id1 int) partitioned by (part1 string);
      
      set hive.exec.dynamic.partition.mode=nonstrict;
      set hive.execution.engine=tez;
      
      explain insert into table partunion1 partition(part1)
      select temps.* from (
      select 1 as id1, '2014' as part1 from dummy 
      union all 
      select 2 as id1, '2014' as part1 from dummy ) temps;
      
      insert into table partunion1 partition(part1)
      select temps.* from (
      select 1 as id1, '2014' as part1 from dummy 
      union all 
      select 2 as id1, '2014' as part1 from dummy ) temps;
      
      select * from partunion1;
      

      fails.

        Attachments

        1. HIVE-10929.1.patch
          8 kB
          Vikram Dixit K
        2. HIVE-10929.2.patch
          261 kB
          Vikram Dixit K
        3. HIVE-10929.3.patch
          261 kB
          Vikram Dixit K
        4. HIVE-10929.4.patch
          261 kB
          Vikram Dixit K

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              vikram.dixit Vikram Dixit K Assign to me
              Reporter:
              vikram.dixit Vikram Dixit K

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment