Joy SN created HIVE-8494:
----------------------------
Summary: Hive partitioned table with smallint datatype
Key: HIVE-8494
URL: https://issues.apache.org/jira/browse/HIVE-8494
Project: Hive
Issue Type: Bug
Components: CLI, Query Processor
Affects Versions: 0.13.0, 0.12.0
Reporter: Joy SN
create a hive partitioned table with datatype smallint
ol_name data_type comment
a int None
b int None
c int None
p smallint None
# Partition Information
# col_name data_type comment
p smallint None
Put the following data. See the partition value is 32768 - which exceeds the
smallint limit by 1
select * from t;
a b c p
1 2 3 32768
4 5 6 32768
7 8 9 32768
hive> select sum(p) from t;
also works
but
hive> select min(p) from t;
fails
It should disallow creation of partition with value 32768 as it exceeds the
smallint limit
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
