This page was moved to https://api-docs.treasuredata.com/en/tools/presto/presto_troubleshooting/#presto-error---mismatched-input-xxxx-expecting---syntax-error
Description
For example, the query below will simply cause the error in title:
Example:
SELECT * from tbl SELECT;
Error Message:
line 1:15: mismatched input 'SELECT'. Expecting: '(', 'LATERAL', 'UNNEST', <identifier>
Cause
A keyword is detected in SQL, while it should not be there as per SQL grammar. As result a compile error as titled, will be output.
Resolution
Locate the keyword by information in error message (in this case 'line 1:15'), then check and fix it.
SELECT * from tbl;
Note / Related Information
N/A