mismatched input

Wilber — Fri, 24 Jul 2020 03:23:31 GMT

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')

Re: mismatched input

Wilber — Fri, 24 Jul 2020 19:37:56 GMT

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

question Re: mismatched input in Support Questions

mismatched input

Re: mismatched input