[ https://issues.apache.org/jira/browse/IMPALA-8052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-8052. ----------------------------------- Resolution: Duplicate > Fail to run ExprTest.TimestampFunctions > --------------------------------------- > > Key: IMPALA-8052 > URL: https://issues.apache.org/jira/browse/IMPALA-8052 > Project: IMPALA > Issue Type: Bug > Affects Versions: Impala 3.1.0 > Reporter: Quanlong Huang > Priority: Major > > Encountered the following test errors from ExprTest.TimestampFunctions: > {code:java} > [ 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 > {code} > The errors only occur in my local machine. It can't be reproduced in Impala > Jenkins. The timezone of my machine is PST. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org