Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.4.3
-
None
-
CDH 4.3.1 with sqoop2-1.99.1+116
Debian 6 Squeeze
PostgreSQL 9.2.4
Description
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 :
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
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,