QUALIFY not supported in latest java version
tha23rd opened this issue · 1 comments
tha23rd commented
Hi all, seeing:
com.google.zetasql.SqlException: QUALIFY is not supported
In the latest Java version
I'm simply calling:
Analyzer.extractTableNamesFromStatement(sql)
Where
sql =
String sql = "select owner_id, created_at_utc as ts, my_id,\n" +
" FROM my_table\n" +
" WHERE 1=1\n" +
" QUALIFY RANK() OVER(PARTITION BY my_id ORDER BY timestamp) = 1";
Seems like we probably need a way to enable language features when calling extractTableNamesFromStatement
Thanks!
tha23rd commented
Solved this:
You can pass your own instance of AnalyzerOptions into Analyzer.extractTableNamesFromStatement()