[jira] [Created] (HIVE-9149) Add unit test to test implicit conversion during dynamic partitioning/distribute by

["Jason Dere (JIRA)" <ji...@apache.org>]

Jason Dere created HIVE-9149:
--------------------------------

             Summary: Add unit test to test implicit conversion during dynamic partitioning/distribute by
                 Key: HIVE-9149
                 URL: https://issues.apache.org/jira/browse/HIVE-9149
             Project: Hive
          Issue Type: Bug
          Components: Tests
            Reporter: Jason Dere
            Assignee: Jason Dere


This particular case was failing in Hive 0.13 because the string "key" column was not being converted to INT when written to the ORC file, resulting in a type cast error when reading data from the table.

HIVE-8151 seems to have fixed this issue, but I would like to add a unit test to make sure we don't regress.

{noformat}
create table implicit_cast_during_insert (c1 int, c2 string)
  partitioned by (p1 string) stored as orc;

set hive.exec.dynamic.partition.mode=nonstrict; 

insert overwrite table implicit_cast_during_insert partition (p1)
  select key, value, key key1 from (select * from src where key = 0) q
  distribute by key1 sort by key1;

select * from implicit_cast_during_insert;

drop table implicit_cast_during_insert;
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)