Lake Formation Data Filter error: Column comparision is currently not supported.

0

Following example from https://docs.aws.amazon.com/lake-formation/latest/dg/setup-data-filters.html, I'm trying to to create a new data filter, but receiving error:

 Expression has EQ operator with column comparisons. Column comparision is currently not supported.

Test_table is governed parquet table, user has a full administrative rights. What could be wrong?

Here is a screenshot: Create data filter error

已提问 1 年前469 查看次数
2 回答
0

Ok, this is a self-answer. Apparently, Row Filter Expression failed due to use of double-quoted string , instead of single quoted.

Replacing confidential1="US" with confidential1='US' solved the problem.

Unfortunately, error message is not helpful and have to be replaced with a better explanation of the problem.

已回答 1 年前
  • It's true that it's not obvious but if you see the description, it says that you are writing a SQL condition. In SQL '' is a string and "" is the way you escape a column name

0

HI, as you have correctly pointed out, the error is due to in SQL syntax strings in double quotes "" are treated as column names. Use single quotes should resolve this issue. Please feel free to response or open a support ticket if you have any follow up questions. We are happy to help you out!

AWS
Ethan_H
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则