[HIVE-10706] Make vectorized_timestamp_funcs test more stable

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: UDF, Vectorization
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 14/May/15 04:40
• Updated: 16/Feb/16 23:51
• Resolved: 20/May/15 06:19

Description

TestCliDriver.testCliDriver_vectorized_timestamp_funcs failed recently
The problem is Double to Double numbers comparison without delta.

Running: diff -a /home/hiveptest/54.196.24.219-hiveptest-1/apache-github-source-source/itests/qtest/../../itests/qtest/target/qfile-results/clientpositive/vectorized_timestamp_funcs.q.out /home/hiveptest/54.196.24.219-hiveptest-1/apache-github-source-source/itests/qtest/../../ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out
729c729
< 1123143.8570000003
---
> 1123143.8569999998

I also noticed that last query results are different among TestCliDriver and TestSparkCliDriver tests (last line in vectorized_timestamp_funcs.q.out)

-- regular
2.8798560435897438E13	8.970772952794212E19	8.970772952794212E19	9.206845925236166E19	9.471416447815084E9	9.471416447815084E9	9.471416447815084E9	9.595231068211002E9

-- spark
2.8798560435897438E13	8.970772952794214E19	8.970772952794214E19	9.206845925236167E19	9.471416447815086E9	9.471416447815086E9	9.471416447815086E9	9.595231068211004E9

-- tez
2.8798560435897438E13	8.970772952794212E19	8.970772952794212E19	9.206845925236166E19	9.471416447815084E9	9.471416447815084E9	9.471416447815084E9	9.595231068211002E9

Issue Links

• relates to: HIVE-8211 Tez and Vectorization of SUM(timestamp) not vectorized -- can't execute correctly because aggregation output is double
• links to: https://reviews.apache.org/r/34197/