You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2019/01/07 17:13:00 UTC
[jira] [Resolved] (IMPALA-8052) Fail to run
ExprTest.TimestampFunctions
[ 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org