hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saurabh Mishra (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16138) Query on ORC table returns no results when specifying a DECIMAL(25) column in a the where clause.
Date Wed, 08 Mar 2017 11:44:37 GMT

    [ 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)

Mime
View raw message