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