[ https://issues.apache.org/jira/browse/IMPALA-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-10350: ----------------------------------- Labels: correctness (was: ) > 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 > Labels: correctness > > 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. If the data was written by Hive then Impala > can read the 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: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org