[
https://issues.apache.org/jira/browse/TAJO-825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007627#comment-14007627
]
Hudson commented on TAJO-825:
-----------------------------
FAILURE: Integrated in Tajo-master-build #221 (See
[https://builds.apache.org/job/Tajo-master-build/221/])
TAJO-825: Datetime type refactoring. (Hyoungjun Kim via jihoon) (jihoonson: rev
526dca28b50d10973735accc87adc787de2db09d)
* tajo-common/src/test/java/org/apache/tajo/util/TestDateTimeUtil.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToDate.java
* tajo-common/src/main/java/org/apache/tajo/datum/Int4Datum.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/ExprAnnotator.java
* CHANGES
* tajo-common/src/main/java/org/apache/tajo/datum/IntervalDatum.java
*
tajo-catalog/tajo-catalog-server/src/main/java/org/apache/tajo/catalog/CatalogServer.java
* tajo-common/src/main/java/org/apache/tajo/util/TimeStampUtil.java
* tajo-core/src/test/java/org/apache/tajo/engine/eval/TestSQLDateTimeTypes.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToTimestampInt.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DatePartFromDate.java
* tajo-common/src/main/java/org/apache/tajo/datum/DatumFactory.java
* tajo-core/src/test/java/org/apache/tajo/engine/eval/ExprTestBase.java
* tajo-common/src/test/java/org/apache/tajo/util/TestTimeStampUtil.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DatePartFromTimestamp.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestDateDatum.java
* tajo-common/src/main/java/org/apache/tajo/datum/Float8Datum.java
* tajo-storage/src/test/java/org/apache/tajo/storage/TestStorages.java
* tajo-common/src/main/java/org/apache/tajo/datum/DateDatum.java
* tajo-common/src/main/java/org/apache/tajo/datum/Float4Datum.java
*
tajo-storage/src/main/java/org/apache/tajo/storage/TextSerializerDeserializer.java
* tajo-core/src/test/java/org/apache/tajo/engine/eval/TestIntervalType.java
* tajo-common/src/main/java/org/apache/tajo/datum/TimeDatum.java
* tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeConstants.java
* tajo-core/src/test/java/org/apache/tajo/engine/eval/TestSQLExpression.java
* tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeUtil.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/UniformRangePartition.java
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestTimestampDatum.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestIntervalDatum.java
* tajo-common/src/test/java/org/apache/tajo/util/TestDateTimeFormat.java
* tajo-common/src/main/java/org/apache/tajo/json/DatumAdapter.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DateTimePartFromUnixTimeStamp.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToTimestampText.java
* tajo-client/src/main/java/org/apache/tajo/jdbc/TajoResultSetBase.java
* tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeFormat.java
* tajo-common/src/main/java/org/apache/tajo/util/datetime/TimeMeta.java
*
tajo-core/src/test/java/org/apache/tajo/engine/function/TestDateTimeFunctions.java
* tajo-common/src/test/java/org/apache/tajo/datum/TestTimeDatum.java
* tajo-common/src/main/java/org/apache/tajo/datum/Int2Datum.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestSortQuery.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DatePartFromTime.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToTimestamp.java
* tajo-common/src/main/java/org/apache/tajo/datum/Int8Datum.java
*
tajo-common/src/main/java/org/apache/tajo/exception/ValueOutOfRangeException.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/ToCharTimestamp.java
* tajo-common/src/main/java/org/apache/tajo/datum/TimestampDatum.java
TAJO-825: Datetime type refactoring. (fixed missing changes) (jihoonson: rev
5bdfe887a4eeb54f830369804e82d6baec4e7a5f)
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DateTimePartFromUnixTimestamp.java
*
tajo-core/src/main/java/org/apache/tajo/engine/function/datetime/DateTimePartFromUnixTimeStamp.java
> Datetime type refactoring.
> --------------------------
>
> Key: TAJO-825
> URL: https://issues.apache.org/jira/browse/TAJO-825
> Project: Tajo
> Issue Type: Improvement
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Attachments: TAJO-825.patch, TAJO-825_1.patch, TAJO-825_2.patch,
> TAJO-825_3.patch
>
>
> Currently Tajo uses Joda time library for Datetime related features.
> I tested Joda library with a next test code. It is difficult to express
> various time range with Joda library.
> So I propose that Tajo uses PostgreSQL style date/time features. I already
> migrated PostgreSQL's date/time code to Tajo. I will attach that patch soon.
> {code}
> Calendar cal = Calendar.getInstance();
> cal.set(Calendar.YEAR, 1582);
> cal.set(Calendar.MONTH, 9);
> cal.set(Calendar.DAY_OF_MONTH, 14);
> SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
> DateTime defaultCalDate = new DateTime(1582, 10, 14, 10, 0, 0, 0);
> Chronology julianChrono = JulianChronology.getInstance();
> DateTime julianCalDate = new DateTime(1582, 10, 14, 10, 0, 0, 0,
> julianChrono);
> System.out.println("Java Calendar :" + df.format(cal.getTime()));
> System.out.println("ISO Calendar : " + defaultCalDate);
> System.out.println("Julian Calendar: " + julianCalDate);
> System.out.println("ISO Calendar's dayOfWeek: " +
> defaultCalDate.getDayOfWeek());
> System.out.println("Julian Calendar's dayOfWeek: " +
> julianCalDate.getDayOfWeek());
> System.out.println("ISO Calendar's getCenturyOfEra: " +
> defaultCalDate.getCenturyOfEra());
> System.out.println("Julian Calendar's getCenturyOfEra: " +
> julianCalDate.getCenturyOfEra());
> {code}
> {noformat}
> Java Calendar :1582-10-24 16:49:35
> ISO Calendar : 1582-10-14T10:00:00.000+08:27:52
> Julian Calendar: 1582-10-14T10:00:00.000+08:27:52
> ISO Calendar's dayOfWeek: 4
> Julian Calendar's dayOfWeek: 7
> ISO Calendar's getYearOfCentury: 15
> Julian Calendar's getYearOfCentury: 16
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
