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.

mismatched input

Solved Go to solution
Highlighted

mismatched input

Explorer

Can anyone tell me what I'm doing wrong. 

I'm getting the following error from the table creation below - 

 

FAILED: ParseException line 8:37 mismatched input 'TREX' expecting ) near ''\\', bp.step_parameter_name) \n
WHERE prm.data_source = '' in function specification")

 

 

CREATE TABLE new_table AS SELECT DISTINCT
prm.source AS source,
bp.process_stage AS process_stage
FROM table1 AS prm
LEFT JOIN table2 AS bp
ON (prm.parameter = CONCAT(bp.step_path, '\\', bp.step_parameter_name))
WHERE (prm.data_source = 'TDATA' OR prm.data_source = 'Docs')

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: mismatched input

Explorer

Disregard; syntax is good.  I was using Python's f-string and forgot to escape the backslash.

View solution in original post

1 REPLY 1
Highlighted

Re: mismatched input

Explorer

Disregard; syntax is good.  I was using Python's f-string and forgot to escape the backslash.

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here