Adesh Kumar Rao created HIVE-25322: -------------------------------------- Summary: Partition type checking is not strict and converts values before insertion Key: HIVE-25322 URL: https://issues.apache.org/jira/browse/HIVE-25322 Project: Hive Issue Type: Bug Affects Versions: 3.1.2, 4.0.0 Reporter: Adesh Kumar Rao Assignee: Adesh Kumar Rao Fix For: 4.0.0
Reproducible case: {code:java} create table testpartitioned (col1 int) partitioned by (p1 int); insert into testpartitioned partitioned(p1=1.1) values (1); insert into testpartitioned partitioned(p1=true) values (1); select * from testpartitioned; +-----------------------+---------------------+ | testpartitioned.col1 | testpartitioned.p1 | +-----------------------+---------------------+ | 1 | 1 | | 1 | 1 | +-----------------------+---------------------+ {code} This happens even when `hive.typecheck.on.insert` is enabled. -- This message was sent by Atlassian Jira (v8.3.4#803005)