google / zetasql

ZetaSQL - Analyzer Framework for SQL
Apache License 2.0
2.28k stars 214 forks source link

JSON_ARRAY_FUNCTIONS language feature is not working #109

Closed masterlittle closed 1 year ago

masterlittle commented 2 years ago

Hi, I'm using AnalyzeStatement to parse sql query and am using custom options. `
public static AnalyzerOptions getAnalyzerOptions() { LanguageOptions languageOptions = new LanguageOptions(); languageOptions.enableLanguageFeature(ZetaSQLOptions.LanguageFeature.FEATURE_JSON_VALUE_EXTRACTION_FUNCTIONS); languageOptions.enableLanguageFeature(ZetaSQLOptions.LanguageFeature.FEATURE_JSON_ARRAY_FUNCTIONS); languageOptions.enableLanguageFeature(ZetaSQLOptions.LanguageFeature.FEATURE_V_1_3_QUALIFY); languageOptions.enableMaximumLanguageFeatures(); languageOptions.setSupportsAllStatementKinds(); languageOptions.setProductMode(ZetaSQLOptions.ProductMode.PRODUCT_EXTERNAL);

AnalyzerOptions options = new AnalyzerOptions();
options.setLanguageOptions(languageOptions);
options.setPruneUnusedColumns(true);
options.setAllowUndeclaredParameters(true);
return options;

} `

But I'm still seeing the error -

Function not found: JSON_EXTRACT_STRING_ARRAY; Did you mean json_extract_array?

Am I doing something wrong?

tha23rd commented 2 years ago

+1 on this one

cc @matthewcbrown

masterlittle commented 1 year ago

It's working now. Closing this