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

[elkarel]

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!

[EricL]

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

[elkarel]

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

[EricL]

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:

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