[ https://issues.apache.org/jira/browse/HIVE-16138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Winston Spencer updated HIVE-16138: ----------------------------------- Description: Consider the following table: {code:title=create-table.hql|borderStyle=solid} CREATE TABLE customer.customer_link( customer_id decimal(25,0), member_id decimal(25,0)) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://nameNodeHA/user/hive/warehouse/customer.db/customer_link' TBLPROPERTIES ( 'ORC.COMPRESS'='SNAPPY', 'transient_lastDdlTime'='1488844949') {code} When executing the following select, no records are returned. The table contains 10 million records. This only happens with ORC formatted tables. {code:title=query-with-no-result.hql|borderStyle=solid} select * from customer.customer_link where customer_id = 1000000000000003210009; {code} {code:title=query-with-results.hql|borderStyle=solid} select * from customer.customer_link where customer_id limit 10; {code} was: Consider the following table: {code:title=create-table.hql|borderStyle=solid} CREATE TABLE customer.customer_link( customer_id decimal(25,0), member_id decimal(25,0)) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://nameNodeHA/user/hive/warehouse/customer.db/customer_link' TBLPROPERTIES ( 'ORC.COMPRESS'='SNAPPY', 'transient_lastDdlTime'='1488844949') {code} When executing the following select, no records are returned. The table contains 10 million records. This only happens with ORC formatted tables. {code:title=query-with-no-result.hql|borderStyle=solid} select * from customer.customer_link where customer_id = 1000000000000003210009; {code} {code:title=query-with-result.hql|borderStyle=solid} select * from customer.customer_link where customer_id limit 10; {code} > Query on ORC table returns no result when specifying a DECIMAL(25) column in > a the where clause. > ------------------------------------------------------------------------------------------------ > > Key: HIVE-16138 > URL: https://issues.apache.org/jira/browse/HIVE-16138 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 1.2.1 > Reporter: Winston Spencer > > Consider the following table: > {code:title=create-table.hql|borderStyle=solid} > CREATE TABLE customer.customer_link( > customer_id decimal(25,0), > member_id decimal(25,0)) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY '\u0001' > STORED AS INPUTFORMAT > 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' > OUTPUTFORMAT > 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' > LOCATION > 'hdfs://nameNodeHA/user/hive/warehouse/customer.db/customer_link' > TBLPROPERTIES ( > 'ORC.COMPRESS'='SNAPPY', > 'transient_lastDdlTime'='1488844949') > {code} > When executing the following select, no records are returned. The table > contains 10 million records. This only happens with ORC formatted tables. > {code:title=query-with-no-result.hql|borderStyle=solid} > select * from customer.customer_link where customer_id = > 1000000000000003210009; > {code} > {code:title=query-with-results.hql|borderStyle=solid} > select * from customer.customer_link where customer_id limit 10; > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)