New Contributor
Posts: 2
Registered: ‎05-02-2018
Accepted Solution

Envelope: spaces in fields name

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

Cloudera Employee
Posts: 50
Registered: ‎08-26-2015

Re: Envelope: spaces in fields name

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...