Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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.

New Contributor

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

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.

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

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

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here