AnsweredAssumed Answered

getting error- ERROR tool.ImportTool: Imported Failed: No column by the name entity_idfound while importing data when trying map-column-hive in sqoop import

Question asked by kjasthi on Oct 23, 2017
Latest reply on Oct 24, 2017 by cathy

I am trying to import from oracle to hive. without --map-column-hive 'ae_header_id=bigint,application_id=smallint,entity_id=bigint,event_id=bigint,accounting_date=date,gl_transfer_date=timestamp' \ its loading fine but getting error only with map-column-hive.

source and destination tables are having same column names.

sqoop version 1.4.6 and hive 2.1

Outcomes