Data ingestion from SqlServer into hive using Sqoop with spaces in column names.

[#1]

Could someone please help me, Data ingestion from SqlServer into hive using Sqoop with spaces in column names.

I've tried:
1. --query "select `column name` " --didn't work
2. --columns " `column name` " -- didn't work

[#2]

@Naresh Kumar Korvi

Let me know if below works

--columns \\\"column name\\\"

[#3]

@Rahul Pathak

I've tried this approach as well, it didn't work. But i'm able to query in sql using [column name].

This didn't worked either when i used in sqoop.

[#4]

I could able to resolve myself. I had to type each column manually, it worked!.