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

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

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
Highlighted

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

@Naresh Kumar Korvi

Let me know if below works

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

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

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

Highlighted

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

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