This page was moved to https://api-docs.treasuredata.com/en/tools/presto/presto_troubleshooting/#presto-error---column-xxxx-cannot-be-resolved---syntax-errorIf you receive this error message, you can take actions to resolve the issue.
The following is an example.
Based on the example, the following queries can cause the error: Column 'xxxx' cannot be resolved:
SELECT id1 FROM tbl; Column 'id1' cannot be resolved
SELECT id FROM tbl WHERE id="123" ; Column '123' cannot be resolved
Column 'id1' does not exist (the column specified in the SQL query is incorrect).
Double quotations are used to contain the string in the WHERE clause. Double quotations can be used only to specify the column name.
Use correct column name in SQL query.
SELECT id FROM tbl;
Use single quotations around strings values.
Do not use any quotations when specifying a number.
SELECT id FROM tbl WHERE id=123 ;