[
https://issues.apache.org/jira/browse/TAJO-2110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15259776#comment-15259776
]
Hudson commented on TAJO-2110:
------------------------------
FAILURE: Integrated in Tajo-master-CODEGEN-build #716 (See
[https://builds.apache.org/job/Tajo-master-CODEGEN-build/716/])
TAJO-2110: Fix incorrect DateTime and remove hard coded tests. (jhkim: rev
aad78a4e7d8c2c2161bfb149e1d1343fb4352d59)
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalContext.java
* tajo-client/src/main/java/org/apache/tajo/client/ClientParameters.java
* tajo-cli/src/main/java/org/apache/tajo/cli/tsql/commands/DescTableCommand.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/raw/TestDirectRawFile.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalNode.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestLeftOuterHashJoinExec.java
* tajo-plan/src/test/java/org/apache/tajo/plan/TestLogicalNode.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/CastEval.java
*
tajo-catalog/tajo-catalog-common/src/test/java/org/apache/tajo/catalog/TestTableMeta.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestProgressExternalSortExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/index/TestBSTIndex.java
*
tajo-core-tests/src/test/resources/results/testDDLBuilder/testBuildDDLQuotedTableName2.result
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestRightOuterHashJoinExec.java
* tajo-client/src/main/java/org/apache/tajo/client/QueryClientImpl.java
*
tajo-catalog/tajo-catalog-server/src/test/java/org/apache/tajo/catalog/TestCatalog.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestPatternMatchingPredicates.java
* tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result
* tajo-plan/src/main/java/org/apache/tajo/plan/TablePropertyUtil.java
*
tajo-core-tests/src/test/resources/results/testDDLBuilder/testBuildDDLForExternalTable.result
*
tajo-storage/tajo-storage-common/src/main/java/org/apache/tajo/storage/TextSerializerDeserializer.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/index/TestSingleCSVFileBSTIndex.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/ColPartitionStoreExec.java
*
tajo-core-tests/src/test/resources/results/TestSelectQuery/testTimezonedTable2.result
* tajo-common/src/test/java/org/apache/tajo/util/TestDateTimeUtil.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/json/JsonLineSerializer.java
* tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeUtil.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/CurrentTime.java
* tajo-docs/src/main/sphinx/time_zone.rst
* tajo-core-tests/src/test/java/org/apache/tajo/engine/util/BenchmarkSort.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/ExternalSortExec.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToCharTimestamp.java
*
tajo-storage/tajo-storage-common/src/main/java/org/apache/tajo/storage/StorageUtil.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/TestEvalNodeToExprConverter.java
* tajo-plan/src/main/java/org/apache/tajo/plan/function/GeneralFunction.java
* tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestTimezone.java
*
tajo-catalog/tajo-catalog-common/src/test/java/org/apache/tajo/catalog/TestTableDesc.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestIntervalDatum.java
* tajo-cluster-tests/src/test/java/org/apache/tajo/BackendTestingUtil.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/orc/ORCAppender.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/RangeShuffleFileWriteExec.java
* tajo-core-tests/src/test/java/org/apache/tajo/worker/TestTaskExecutor.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestLineReader.java
*
tajo-core-tests/src/test/java/org/apache/tajo/master/TestExecutionBlockCursor.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestJsonFunctions.java
* tajo-core-tests/src/test/java/org/apache/tajo/cli/tsql/TestTajoCli.java
*
tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/eval/TestSQLExpression.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/eval/TestEvalTreeUtil.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestMergeScanner.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/codegen/TestEvalCodeGenerator.java
* tajo-common/src/main/java/org/apache/tajo/datum/TimestampDatum.java
* tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestTajoJdbc.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/thirdparty/orc/TreeReaderFactory.java
* tajo-cli/src/main/java/org/apache/tajo/cli/tsql/CliClientParamsFactory.java
* tajo-jdbc/src/test/java/org/apache/tajo/jdbc/TestResultSet.java
* tajo-client/src/main/java/org/apache/tajo/client/CatalogAdminClientImpl.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/TestLogicalPlanner.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestHashJoinExec.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestTimeDatum.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/GeneralFunctionEval.java
* tajo-core-tests/src/test/java/org/apache/tajo/engine/eval/TestPredicates.java
* tajo-core/src/main/java/org/apache/tajo/master/exec/QueryExecutor.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/TestLogicalOptimizer.java
* CHANGES
* tajo-client/src/main/java/org/apache/tajo/client/TajoClientUtil.java
* tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result
*
tajo-core-tests/src/test/resources/results/testDDLBuilder/testBuildDDLForBaseTable.result
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/CurrentDate.java
* tajo-plan/src/main/java/org/apache/tajo/plan/serder/EvalNodeSerializer.java
* tajo-common/src/main/java/org/apache/tajo/TajoConstants.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestSortIntersectExec.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/TestJoinOrderAlgorithm.java
* tajo-core-tests/src/test/java/org/apache/tajo/engine/eval/ExprTestBase.java
*
tajo-core-tests/src/test/resources/results/testDDLBuilder/testBuildDDLQuotedTableName1.result
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DatePartFromTime.java
* tajo-cluster-tests/src/test/java/org/apache/tajo/TajoTestingCluster.java
* tajo-common/src/main/java/org/apache/tajo/datum/DatumFactory.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/StoreTableExec.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/function/FunctionInvokeContext.java
* tajo-core-tests/src/test/java/org/apache/tajo/cli/tools/TestDDLBuilder.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/function/ClassBasedScalarFunctionInvoke.java
* tajo-docs/src/main/sphinx/jdbc_driver.rst
* tajo-common/src/main/java/org/apache/tajo/datum/TimeDatum.java
* tajo-core/src/main/java/org/apache/tajo/benchmark/TPCH.java
* tajo-plan/src/main/java/org/apache/tajo/plan/ExprAnnotator.java
* tajo-plan/src/main/java/org/apache/tajo/plan/verifier/ExprsVerifier.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestDateDatum.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/HashShuffleFileWriteExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestFileSystems.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/function/stream/TextFieldSerializerDeserializer.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestDateTimeFunctions.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestRightOuterMergeJoinExec.java
* tajo-core/src/main/java/org/apache/tajo/worker/TaskAttemptContext.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestPhysicalPlanner.java
* tajo-client/src/main/java/org/apache/tajo/client/ClientParameterHelper.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestHashSemiJoinExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/json/TestJsonSerDe.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestRadixSort.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/orc/OrcScanner.java
* tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DatePartFromTimestamp.java
* tajo-common/src/main/java/org/apache/tajo/datum/IntervalDatum.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/AddDays.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/avro/TestAvroUtil.java
* tajo-plan/src/main/proto/Plan.proto
* tajo-common/src/main/java/org/apache/tajo/datum/DateDatum.java
* tajo-common/src/main/java/org/apache/tajo/datum/Datum.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestStorages.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestTimestampDatum.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/thirdparty/orc/WriterImpl.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestSortExec.java
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/InsertRowsExec.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestMergeJoinExec.java
* tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result
* tajo-core/src/main/java/org/apache/tajo/master/exec/CreateTableExecutor.java
* tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result
* tajo-common/src/main/java/org/apache/tajo/util/datetime/TimeMeta.java
*
tajo-catalog/tajo-catalog-common/src/main/java/org/apache/tajo/catalog/CatalogUtil.java
*
tajo-catalog/tajo-catalog-server/src/test/java/org/apache/tajo/catalog/TestCatalogAgainstCaseSensitivity.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/AddMonths.java
* tajo-cluster-tests/src/test/java/org/apache/tajo/QueryTestCaseBase.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/text/TextFieldSerializerDeserializer.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/exprrewrite/rules/ConstantFolding.java
* tajo-core-tests/src/test/java/org/apache/tajo/cli/tools/TestTajoDump.java
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/json/JsonLineDeserializer.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestStringOperatorsAndFunctions.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestExternalSortExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestCompressionStorages.java
*
tajo-core-tests/src/test/resources/results/TestJsonWithTimezone/testTimezonedTable2.result
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestJsonWithTimezone.java
* tajo-client/src/main/java/org/apache/tajo/jdbc/WaitingResultSet.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestConditionalExpressions.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToTimestampText.java
* tajo-core-tests/src/test/java/org/apache/tajo/storage/TestQueryOnOrcFile.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestFullOuterHashJoinExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestDelimitedTextFile.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestHashAntiJoinExec.java
*
tajo-storage/tajo-storage-hdfs/src/test/java/org/apache/tajo/storage/TestFileTablespace.java
* tajo-client/src/main/java/org/apache/tajo/jdbc/TajoResultSetBase.java
* tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/physical/TestFullOuterMergeJoinExec.java
* tajo-core-tests/src/test/java/org/apache/tajo/storage/TestRowFile.java
*
tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result
*
tajo-plan/src/main/java/org/apache/tajo/plan/function/python/PythonScriptEngine.java
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/planner/TestPlannerUtil.java
> Fix incorrect DateTime and remove hard coded tests
> --------------------------------------------------
>
> Key: TAJO-2110
> URL: https://issues.apache.org/jira/browse/TAJO-2110
> Project: Tajo
> Issue Type: Bug
> Components: Data Type, Storage, Unit Test
> Affects Versions: 0.12.0
> Reporter: Jinho Kim
> Assignee: Jinho Kim
> Priority: Critical
>
> Currently, Most DateTime tests are not work correctly. because timezone is
> hardcode to the GMT for testing.
> if you run CTAS, the result data will be incorrect. we should remove the
> hardcoded timezone in TajoTestingCluster
> Here is some examples:
> Example 1
> {noformat}
> if you run CTAS, the result data will be incorrect
> default> create table test1 (col1 TIMESTAMP);
> default> insert overwrite into test1 select '2016-04-04 00:00:00'::TIMESTAMP;
> default> select * from test1;
> col1
> -------------------------------
> 2016-04-04 00:00:00
> (1 rows, 0.057 sec, 0 B selected)
> default> create table test2 as select * from test1;
> [=========================================>] 100% 0.105 sec
> (1 rows, 0.105 sec, 20 B inserted)
> default> select * from test2;
> col1
> -------------------------------
> 2016-04-03 15:00:00
> {noformat}
> Example 2
> {noformat}
> default> select '2016-04-04 01:00:00'::TIMESTAMP - interval '1 hour';
> ?minus
> -------------------------------
> 2016-04-04 09:00:00
> (1 rows, 0.005 sec, 0 B selected)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
