[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15345410#comment-15345410 ] Sergey Shelukhin commented on HIVE-11802: - Backported both commits to 1.3 and 1.2.2 > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: lijp > Fix For: 1.3.0, 2.0.0, 1.2.2 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14945997#comment-14945997 ] Sergio Peña commented on HIVE-11802: [~cwsteinbach] I've been thinking on this patch regarding the use of {{new Double(field.toString())}}, and it might cause a extra performance overhead because the conversion from Float -> String -> Double everytime we send values through JDBC. What do you think about this? Should we revert this bug, and figure out another way to fix it? > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14951535#comment-14951535 ] Carl Steinbach commented on HIVE-11802: --- I think this is a case where correctness is more important than performance. Let's aim first for the former, and once it's achieved we can worry about the latter. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15091679#comment-15091679 ] lijp commented on HIVE-11802: - TO:Mr Sergio Peña About HIVE-11802,I wanted to get some help. Like following ,I can not get the patches about HIVE-11802,could you help me to provide the URL ? Forward to get your help. The following lists all Apache Hive Jiras included in CDH 5.5.0 that are not included in the Apache Hive base version 1.1.0. The hive-1.1.0-cdh5.5.0.CHANGES.txt file lists all changes included in CDH 5.5.0. The patch for each change can be found in the cloudera/patches directory in the release tarball. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: lijp > Fix For: 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15092210#comment-15092210 ] Sergio Peña commented on HIVE-11802: Hi [~lijp87], the URL is https://issues.apache.org/jira/secure/attachment/12755814/HIVE-11802.3.patch > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: lijp > Fix For: 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14741770#comment-14741770 ] Carl Steinbach commented on HIVE-11802: --- I guess the fact that the patch doesn't include any test updates means that there's no test coverage for this right now? If that's the case can you add some? Also, does the HiveCLI behave correctly in this scenario, and is there any test coverage provided for this there? > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.1.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14742126#comment-14742126 ] Hive QA commented on HIVE-11802: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12755466/HIVE-11802.1.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 9424 tests executed *Failed tests:* {noformat} org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5256/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5256/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5256/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12755466 - PreCommit-HIVE-TRUNK-Build > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.1.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14742346#comment-14742346 ] Sergio Peña commented on HIVE-11802: [~cwsteinbach] I submitted another patch with the unit tests. This issue happens only on beeline and JDBC connections. The values are correctly displayed on HiveCli. I believe the correct precision is corrected when converting the values to JSON string. But on JDBC, the values are sent with a different precision to the client. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.2.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14742374#comment-14742374 ] Hive QA commented on HIVE-11802: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12755592/HIVE-11802.2.patch {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 9442 tests executed *Failed tests:* {noformat} org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5263/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5263/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5263/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12755592 - PreCommit-HIVE-TRUNK-Build > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.2.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14742769#comment-14742769 ] Carl Steinbach commented on HIVE-11802: --- Thanks for adding a test. Here's some feedback: * TestColumn is missing an ASF header. * TestColumn doesn't prove that beeline returns correct results. What we need is an end-to-end test that validates the output of beeline. There's an existing test driver (TestBeeLineDriver) that was included in the original HiveServer2 patch. The goal was to make it easy to write end-to-end Beeline tests in the style of the existing qfile tests. There's also a set of sample data files in files/types/primitives that cover all primitive types, and an initialization file (data/scripts/q_test_init.sql) that creates a 'primitives' table on top of it. I think we'd get more complete and easier to maintain test coverage with less code by resurrecting TestBeeLineDriver and writing a new beeline qfile test that runs a 'SELECT *' query against the primitives table. I suspect the original HS2 patch even had a qfile test for this, but I'm too depressed to look. It would be awesome if you want to fix this, but all that really stands in the way of a +1 is adding the missing ASF header. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.2.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744186#comment-14744186 ] Sergio Peña commented on HIVE-11802: Thanks [~cwsteinbach] for the recommendation for the tests. However, I think there is still an issue with TestBeelineDriver that it gets stuck on Hive QA (see HIVE-10884). I enabled the driver on Jenkins before, but there are still issues with it. We're not sure what it is yet. I will need to disable it, and fix it later. In the mean time, it would be great to have this patch committed so that users can benefit from it. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744787#comment-14744787 ] Carl Steinbach commented on HIVE-11802: --- +1. Can you commit this yourself? > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745009#comment-14745009 ] Hive QA commented on HIVE-11802: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12755814/HIVE-11802.3.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 9443 tests executed *Failed tests:* {noformat} TestCustomAuthentication - did not produce a TEST-*.xml file org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation org.apache.hive.hcatalog.streaming.TestStreaming.testInterleavedTransactionBatchCommits {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5279/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5279/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5279/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12755814 - PreCommit-HIVE-TRUNK-Build > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746221#comment-14746221 ] Prasanth Jayachandran commented on HIVE-11802: -- [~spena] fyi.. this breaks compilation in JDK 8. The FloatingDecimal(float) constructor is removed in JDK 8. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 1.3.0, 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746268#comment-14746268 ] Sergio Peña commented on HIVE-11802: Thanks [~prasanth_j] > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 1.3.0, 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746348#comment-14746348 ] Sergey Shelukhin commented on HIVE-11802: - should we revert this meanwhile? or is the patch forthcoming > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 1.3.0, 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
[ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746358#comment-14746358 ] Sergio Peña commented on HIVE-11802: There's a patch forthcoming. I found the fix. > Float-point numbers are displayed with different precision in Beeline/JDBC > -- > > Key: HIVE-11802 > URL: https://issues.apache.org/jira/browse/HIVE-11802 > Project: Hive > Issue Type: Bug >Affects Versions: 1.2.1 >Reporter: Sergio Peña >Assignee: Sergio Peña > Fix For: 1.3.0, 2.0.0 > > Attachments: HIVE-11802.3.patch > > > When inserting float-point numbers to a table, the values displayed on > beeline or jdbc are with different precision. > How to reproduce: > {noformat} > 0: jdbc:hive2://localhost:1> create table decimals (f float, af > array, d double, ad array) stored as parquet; > No rows affected (0.294 seconds) > 0: jdbc:hive2://localhost:1> insert into table decimals select 1.10058, > array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1; > ... > No rows affected (20.089 seconds) > 0: jdbc:hive2://localhost:1> select f, af, af[0], d, ad[0] from decimals; > +-++-+-+-+--+ > | f | af | _c2 |d| _c4 | > +-++-+-+-+--+ > | 1.1005799770355225 | [1.10058] | 1.1005799770355225 | 2.0133 | 2.0133 | > +-++-+-+-+--+ > {noformat} > When displaying arrays, the values are displayed correctly, but if I print a > specific element, it is then displayed with more decimal positions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)