Sqoop processor is not working in certain scenario

Description

Hi Team,

We are facing this when we are trying to ingest data from MS SQL. Please follow below instruction to replicate :-

1 - We have a table in which there is a column name "Function" which is a reserve keyword in MS SQL.
2 - We have created a Sqoop feed to ingest the data from it and we have specified list of column which I want to ingest and column "Function" was in list.

Note :- In MS SQL, if you want to query the table which has reserved column name then you will have to write query like:- Select [ReserveColumnName] From XYZ. So you will have to put special column name in square bracket.

3 - Since we want to ingest certain column so we have mentioned the all the column name while creating feed including the special column ("Function") in square bracket.

4 - When we are starting the feed it failed with the message that column ("Function") does not exist.

Could you please fix this Sqoop processor issue?

Note:- If we are trying this sqoop ingestion from command line then it is working fine.

Environment

None

Assignee

Jagrut Sharma

Reporter

Ankit Tripathi

Labels

None

Reviewer

None

Story point estimate

None

Components

Priority

Medium
Configure