I am trying to ingest data from progress datasource and I have few fields with names like Sales-uk due to hyphen sqoop is throwing me an error It seems like you are looking up a column that does not
[2018-05-10 15:05:09,149] {base_task_runner.py:95} INFO - Subtask: [2018-05-10 15:05:09,148] {sqoop_hook.py:101} INFO - 18/05/10 15:05:09 ERROR util.SqlTypeMap: exist in the table. Please ensure that you've specified
[2018-05-10 15:05:09,149] {base_task_runner.py:95} INFO - Subtask: [2018-05-10 15:05:09,148] {sqoop_hook.py:101} INFO - 18/05/10 15:05:09 ERROR util.SqlTypeMap: correct column names in Sqoop options.
[2018-05-10 15:05:09,149] {base_task_runner.py:95} INFO - Subtask: [2018-05-10 15:05:09,148] {sqoop_hook.py:101} INFO - 18/05/10 15:05:09 ERROR tool.ImportTool: Import failed: column not found: `notes-id`
I can do this through query option but my framework doesn't allow me to use query function in sqoop, can you please suggest is there any other way around this please?