[
https://issues.apache.org/jira/browse/HIVE-16138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15901136#comment-15901136
]
Saurabh Mishra commented on HIVE-16138:
---------------------------------------
[~gopalv] That clears few doubts. But still the behaviour with numeral within
quotes (') in unclear. When checking the explain plan for both of them, it
seems to be not approximating for numbers greater than 18 digits.
eg. 1
select * from tab1 where col1 in ('1010000000421400010101');
`filterExpr: (col1) IN ('1010000000421400010101') (type: boolean)`
eg. 2
select * from tab1 where col1 = ('1010000000421400010101');
`filterExpr: (col1 = '1010000000421400010101') (type: boolean)`
Above, 1st example gives no output while the 2nd one gives expected return.
> Query on ORC table returns no results 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-results.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)
