[
https://issues.apache.org/jira/browse/TAJO-825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14019032#comment-14019032
]
Jaehwa Jung commented on TAJO-825:
----------------------------------
Currently, tajo-branch-0.8.1 'mvn clean install' failed as follows:
{code:xml}
Results :
Tests in error:
testGroupByWithNullData9(org.apache.tajo.engine.query.TestGroupByQuery):
org.apache.tajo.engine.exception.VerifyException: relation "default.table1"
does not exist(..)
Tests run: 784, Failures: 0, Errors: 1, Skipped: 0
{code}
We need to apply this patch to tajo-branch-0.8.1.
> 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)
