You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Cheolsoo Park (Updated) (JIRA)" <ji...@apache.org> on 2012/03/14 07:11:43 UTC

[jira] [Updated] (SQOOP-451) Add new options for format masks for date, time, and timestamp

     [ https://issues.apache.org/jira/browse/SQOOP-451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Cheolsoo Park updated SQOOP-451:
--------------------------------

    Description: 
Add new options via which the user can specify format masks for date, time, and timestamp columns.

The propose is to add pattern matching code to the toString() method of SqoopRecorder so that when the output is written to files, it can be modified accordingly.


  was:
Oracle compatibility tests are fragile since the output format of timestamp from the DB varies depending on versions. To test different versions effectively, we should make the output more deterministic.

This issue was originally raised by SQOOP-449, and using regular expressions in compatibility tests was suggested. But after discussion with Arvind and Bilung, we decided to add a format string for the date type to the select query for the Oracle DB so that the output format can be consistent.

        Summary: Add new options for format masks for date, time, and timestamp  (was: Add format string to select query for Oracle DB)
    
> Add new options for format masks for date, time, and timestamp
> --------------------------------------------------------------
>
>                 Key: SQOOP-451
>                 URL: https://issues.apache.org/jira/browse/SQOOP-451
>             Project: Sqoop
>          Issue Type: Improvement
>            Reporter: Cheolsoo Park
>            Assignee: Cheolsoo Park
>            Priority: Minor
>
> Add new options via which the user can specify format masks for date, time, and timestamp columns.
> The propose is to add pattern matching code to the toString() method of SqoopRecorder so that when the output is written to files, it can be modified accordingly.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira