Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-1186

Cannot import Date type from PostgreSQL

    XMLWordPrintableJSON

    Details

      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,

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nphung Nicolas PHUNG
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: