sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1186) Cannot import Date type from PostgreSQL
Date Wed, 04 Sep 2013 06:54:52 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-1186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13757506#comment-13757506
] 

Jarek Jarcec Cecho commented on SQOOP-1186:
-------------------------------------------

[~nphung], would you mind attaching entire Sqoop log generated with parameter {{--verbose}}?
When executed from Oozie the log will be available in the launcher map task.
                
> Cannot import Date type from PostgreSQL
> ---------------------------------------
>
>                 Key: SQOOP-1186
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1186
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/postgresql, hive-integration
>    Affects Versions: 1.99.1
>         Environment: CDH 4.3.1 with sqoop2-1.99.1+116
> Debian 6 Squeeze
> PostgreSQL 9.2.4
>            Reporter: Nicolas PHUNG
>              Labels: cast, date, hive, postgresql, table, type
>
> Hello,
> When I'm trying to import a postgreSQL table with a date column (as date datatype in
postgreSQL) via sqoop to a Hive Table, I got the following error :
> {noformat}
> Query f8473c7df5a8f4de:e7f6334cfbf9c9b1 100% Complete (1 out of 1)
> Backend 0:Error converting column: 2 TO INT (Data is: 2013-08-01)
> Error converting column: 3 TO INT (Data is: null)
> Error converting column: 4 TO INT (Data is: null)
> file: hdfs://masternode.lan:8020/user/hive/warehouse/information/part-m-00000
> record: 1,Information Center 1,2013-08-01,null,null
> {noformat}
> It seems you can't import postgreSQL date format via Sqoop to a Hive Table. Is it normal
? Is this the correct way to import a date column to the Hive table data format ?
> Regards,

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message