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.

Hue's Sqoop step: How to paste blank spaces in arguments

Hue's Sqoop step: How to paste blank spaces in arguments

Explorer

In a Sqoop step, if I paste "a, b, c" into the arguments, it will automatically create 3 arguments in UI.

Cool feature, but only until you use SQL..

 

I have a rather complex query and it not only slices the query by white spaces, creating meaningless arguments, but also overwrites the preexisting ones.

 

In CDH 5.10.1 this feature wasn't present, but I experience it in 5.13.0.

 

Any ideas how to workaround this? I tried to replace white characters with "\040" but that did not work.

The only idea I've got is to export the workflow to JSON, edit and import back, which is quite unconfortable. Better still than edit the SQL manually.

 

Thanks!

3 REPLIES 3
Highlighted

Re: Hue's Sqoop step: How to paste blank spaces in arguments

Guru
Hi, can you please provide a screenshot to confirm which page you are referring to? Sqoop1 editor page, Oozie workflow editor or other pages?

Thanks

Re: Hue's Sqoop step: How to paste blank spaces in arguments

Explorer

Hello Eric,

 

1. Just create a blank Sqoop step in a new  workflow.

 

2. Then, add any number of arguments to it.

 

3. Paste the following string to any of the arguments: "a b c"

 

4. You'll see previous args were overwritten by a b and c.

 

Thanks


Screenshot at 2018-05-14 15:09:18.png

Re: Hue's Sqoop step: How to paste blank spaces in arguments

Guru

OK, I see what you mean.

 

I have tested and confirm that if you paste it, it will expand them into arguments. But looks like if you type in manually, it should be fine, see below screenshot:

 

Screen Shot 2018-05-15 at 5.22.14 pm.png

 

How long is your argument string? If not too long, maybe just type in manually for now.