Cloudera Labs
Provide feedback on Cloudera Labs
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Envelope: spaces in fields name

SOLVED Go to solution
Highlighted

Envelope: spaces in fields name

New Contributor

Hi, I'm trying to use Envelope to read one csv file and, after some checks on fields format (step "StepOfChecks"), write two csv files: the first one with "ok data" and the second one with "ko data". My csv source has fields names on 1st row but these names contain spaces. How can I make a "select [field 1], [field 2] from StepOfChecks where..." by query.literal ? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Envelope: spaces in fields name

Rising Star
I haven't had a chance to try this, but usually you can use backticks for that, for example:

SELECT `field 1`, `field 2` FROM StepOfChecks WHERE...
1 REPLY 1

Re: Envelope: spaces in fields name

Rising Star
I haven't had a chance to try this, but usually you can use backticks for that, for example:

SELECT `field 1`, `field 2` FROM StepOfChecks WHERE...