- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mismatched input
- Labels:
-
Apache Hive
Created ‎07-23-2020 08:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')
Created ‎07-24-2020 12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Disregard; syntax is good. I was using Python's f-string and forgot to escape the backslash.
Created ‎07-24-2020 12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Disregard; syntax is good. I was using Python's f-string and forgot to escape the backslash.
