Reply
Explorer
Posts: 10
Registered: ‎04-28-2016

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

[ Edited ]

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!

Cloudera Employee
Posts: 295
Registered: ‎03-23-2015

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

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
Explorer
Posts: 10
Registered: ‎04-28-2016

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

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
Highlighted
Cloudera Employee
Posts: 295
Registered: ‎03-23-2015

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

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.

Announcements