[ 
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

Reply via email to