Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
Impala 3.1.0
-
None
-
None
-
None
-
ghx-label-3
Description
Encountered the following test errors from ExprTest.TimestampFunctions:
[ RUN ] ExprTest.TimestampFunctions /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: -28800 Expected: expected_result Which is: 0 unix_timestamp(cast('1969-12-31 16:00:00' as timestamp)) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: -28800 Expected: expected_result Which is: 0 unix_timestamp('1969-12-31 16:00:00') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: -28800 Expected: expected_result Which is: 0 unix_timestamp('1969-12-31 16:00:00', 'yyyy-MM-dd HH:mm:ss') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: 0 Expected: expected_result Which is: 28800 unix_timestamp('1970-01-01', 'yyyy-MM-dd') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: 0 Expected: expected_result Which is: 28800 unix_timestamp('1970-01-01 10:10:10', 'yyyy-MM-dd') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:559: Failure Value of: ConvertValue<int64_t>(result) Actual: -28800 Expected: expected_result Which is: 0 unix_timestamp('1969-12-31 16:00:00 extra text', 'yyyy-MM-dd HH:mm:ss') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" cast(cast(0 as timestamp) as string) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" cast(cast(0 as timestamp) as string) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" from_unixtime(0) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" from_unixtime(cast(0 as bigint)) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" from_unixtime(0, 'yyyy-MM-dd HH:mm:ss') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 00:00:00" Expected: expected_result Which is: "1969-12-31 16:00:00" from_unixtime(cast(0 as bigint), 'yyyy-MM-dd HH:mm:ss') /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:289: Failure Value of: GetValue(expr, TYPE_STRING) Actual: "1970-01-01 08:00:00" Expected: expected_result Which is: "1970-01-01 00:00:00" cast(to_timestamp(28800) as string) /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:445: Failure Expected: (value) <= (end), actual: 1546742379 vs 1546713579 Google Test trace: /tmp/jenkins/workspace/impala-hulu/be/src/exprs/expr-test.cc:6572: [ FAILED ] ExprTest.TimestampFunctions (6409 ms) [ RUN ] ExprTest.ConditionalFunctions [ OK ] ExprTest.ConditionalFunctions (1623 ms) [ RUN ] ExprTest.ConditionalFunctionIsTrue [ OK ] ExprTest.ConditionalFunctionIsTrue (105 ms) [ RUN ] ExprTest.ConditionalFunctionIsFalse [ OK ] ExprTest.ConditionalFunctionIsFalse (105 ms) [ RUN ] ExprTest.ConditionalFunctionIsNotTrue [ OK ] ExprTest.ConditionalFunctionIsNotTrue (105 ms) [ RUN ] ExprTest.ConditionalFunctionIsNotFalse [ OK ] ExprTest.ConditionalFunctionIsNotFalse (102 ms) [ RUN ] ExprTest.ResultsLayoutTest [ OK ] ExprTest.ResultsLayoutTest (0 ms) [ RUN ] ExprTest.DecimalFunctions [ OK ] ExprTest.DecimalFunctions (2990 ms) [ RUN ] ExprTest.DecimalOverflowCastsDecimalV1 [ OK ] ExprTest.DecimalOverflowCastsDecimalV1 (357 ms) [ RUN ] ExprTest.DecimalOverflowCastsDecimalV2 [ OK ] ExprTest.DecimalOverflowCastsDecimalV2 (323 ms) [ RUN ] ExprTest.NullValueFunction [ OK ] ExprTest.NullValueFunction (393 ms) [ RUN ] ExprTest.NonNullValueFunction [ OK ] ExprTest.NonNullValueFunction (387 ms) [ RUN ] ExprTest.UdfInterfaceBuiltins [ OK ] ExprTest.UdfInterfaceBuiltins (77 ms) [ RUN ] ExprTest.MADlib [ OK ] ExprTest.MADlib (66 ms) [ RUN ] ExprTest.BitByteBuiltins [ OK ] ExprTest.BitByteBuiltins (839 ms) [ RUN ] ExprTest.UuidTest [ OK ] ExprTest.UuidTest (87 ms) [ RUN ] ExprTest.DateTruncTest [ OK ] ExprTest.DateTruncTest (454 ms) [ RUN ] ExprTest.JsonTest [ OK ] ExprTest.JsonTest (559 ms) [----------] 52 tests from ExprTest (90247 ms total) [----------] Global test environment tear-down [==========] 52 tests from 1 test case ran. (90247 ms total) [ PASSED ] 51 tests. [ FAILED ] 1 test, listed below: [ FAILED ] ExprTest.TimestampFunctions 1 FAILED TEST
The errors only occur in my local machine. It can't be reproduced in Impala Jenkins. The timezone of my machine is PST.
Attachments
Issue Links
- duplicates
-
IMPALA-8043 ExprTest fails on Ubuntu 16 when the timezone is America/Los_Angeles
- Resolved