Support Questions
Find answers, ask questions, and share your expertise

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

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

3 REPLIES 3

@Naresh Kumar Korvi

Let me know if below works

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

@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.

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