google/zetasql

QUALIFY not supported in latest java version

tha23rd opened this issue · 1 comments

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!

Solved this:

You can pass your own instance of AnalyzerOptions into Analyzer.extractTableNamesFromStatement()