You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Winston Spencer (JIRA)" <ji...@apache.org> on 2017/03/07 13:22:38 UTC
[jira] [Created] (HIVE-16138) Query on ORC table returns no result
when specifying a DECIMAL(25) column in a the where clause.
Winston Spencer created HIVE-16138:
--------------------------------------
Summary: 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-result.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)