[
https://issues.apache.org/jira/browse/IMPALA-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Borók-Nagy updated IMPALA-10350:
---------------------------------------
Description:
Impala might loses presision of double values. Reproduction:
{noformat}
create table double_tbl (d double) stored as textfile;
insert into double_tbl values (-0.43149576573887316);
{noformat}
Then inspect the data file:
{noformat}
$ hdfs dfs -cat
/test-warehouse/double_tbl/424097c644088674-c55b910100000000_175064830_data.0.txt
-0.4314957657388731{noformat}
The same happens if we store our data in Parquet.
Hive writes don't lose precision. Impala can read such values correctly:
{noformat}
$ bin/run-jdbc-client.sh -t NOSASL -q "select * from double_tbl;"
Using JDBC Driver Name: org.apache.hive.jdbc.HiveDriver
Connecting to: jdbc:hive2://localhost:21050/;auth=noSasl
Executing: select * from double_tbl
----[START]----
-0.43149576573887316
----[END]----{noformat}
was:
Impala might loses presision of double values. Reproduction:
{noformat}
create table double_tbl (d double) stored as textfile;
insert into double_tbl values (-0.43149576573887316);
{noformat}
Then inspect the data file:
{noformat}
$ hdfs dfs -cat
/test-warehouse/double_tbl/424097c644088674-c55b910100000000_175064830_data.0.txt
-0.4314957657388731{noformat}
The same happens if we store our data in Parquet.
Hive writes don't lose precision. Impala also loses precision on the read side
even if the data is written by Hive.
> Impala loses double precision on the write side
> -----------------------------------------------
>
> Key: IMPALA-10350
> URL: https://issues.apache.org/jira/browse/IMPALA-10350
> Project: IMPALA
> Issue Type: Bug
> Reporter: Zoltán Borók-Nagy
> Priority: Major
>
> Impala might loses presision of double values. Reproduction:
> {noformat}
> create table double_tbl (d double) stored as textfile;
> insert into double_tbl values (-0.43149576573887316);
> {noformat}
> Then inspect the data file:
> {noformat}
> $ hdfs dfs -cat
> /test-warehouse/double_tbl/424097c644088674-c55b910100000000_175064830_data.0.txt
> -0.4314957657388731{noformat}
> The same happens if we store our data in Parquet.
> Hive writes don't lose precision. Impala can read such values correctly:
> {noformat}
> $ bin/run-jdbc-client.sh -t NOSASL -q "select * from double_tbl;"
> Using JDBC Driver Name: org.apache.hive.jdbc.HiveDriver
> Connecting to: jdbc:hive2://localhost:21050/;auth=noSasl
> Executing: select * from double_tbl
> ----[START]----
> -0.43149576573887316
> ----[END]----{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
