Problem
User received Syntax error creating a view
Error:
ERROR:root:Response: {"message": "Call to execute_ddl failed: Could not execute ddl.\nDetail: AnalysisException: Syntax error in line 15:\ndb.table.metadata as metadata,\n ^\nEncountered: METADATA\nExpected: IDENTIFIER\n\nCAUSED BY: Exception: Syntax error\n"}
Answer
Metadata is a reserved word in the okera platform. Choose a different column name, or escape the column name with quotes, or skip the metadata column using ` (back ticks). A full list of reserved words can be found here.
Comments
0 comments
Please sign in to leave a comment.