[jira] [Created] (SQOOP-1186) Cannot import Date type from PostgreSQL

["Nicolas PHUNG (JIRA)" <ji...@apache.org>]

Nicolas PHUNG created SQOOP-1186:
------------------------------------

             Summary: 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


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