Hey Team, I am trying simple SQL query with Table API, But I am getting below error while trying to access inner object Object:

{
  "field1": "keyur",
  "inner": {
    "fieldInner": "inner"
  }
}

Query:

"SELECT * FROM Log WHERE inner.fieldInner='inner'

Error: Exception in thread “main” org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered “inner” at line 1, column 25. Was expecting one of: “CURSOR” ... “EXISTS” ... “NOT” ... “ROW” ... “UNIQUE” ... “(” ... “+” ... “-” ... “INTERVAL” ... <UNSIGNED_INTEGER_LITERAL> ... <DECIMAL_NUMERIC_LITERAL> ... <APPROX_NUMERIC_LITERAL> ... <BINARY_STRING_LITERAL> ... <PREFIXED_STRING_LITERAL> ...

Most likely

inner

is a reserved keyword, so you'll need to include backticks

"SELECT * FROM Log WHERE `inner`.`fieldInner`='inner'

Ohh, I see Thanks @Martijn Visser Solved my issue