This is an automated email from the ASF dual-hosted git repository. alsay pushed a commit to branch bucket_variable_name in repository https://gitbox.apache.org/repos/asf/datasketches-bigquery.git
commit a3faa4e5438508f6a29aab5da066e975a26f4380 Author: AlexanderSaydakov <[email protected]> AuthorDate: Fri Oct 18 11:51:31 2024 -0700 renamed GCS_BUCKET to JS_BUCKET to match BigQuery build process --- README.md | 4 ++-- cpc/sqlx/cpc_sketch_agg_int64_lgk_seed.sqlx | 4 ++-- cpc/sqlx/cpc_sketch_agg_string_lgk_seed.sqlx | 4 ++-- cpc/sqlx/cpc_sketch_agg_union_lgk_seed.sqlx | 4 ++-- cpc/sqlx/cpc_sketch_get_estimate_and_bounds_seed.sqlx | 2 +- cpc/sqlx/cpc_sketch_get_estimate_seed.sqlx | 2 +- cpc/sqlx/cpc_sketch_to_string_seed.sqlx | 2 +- cpc/sqlx/cpc_sketch_union_lgk_seed.sqlx | 2 +- fi/sqlx/frequent_strings_sketch_build.sqlx | 4 ++-- fi/sqlx/frequent_strings_sketch_get_result.sqlx | 2 +- fi/sqlx/frequent_strings_sketch_merge.sqlx | 4 ++-- fi/sqlx/frequent_strings_sketch_to_string.sqlx | 2 +- hll/sqlx/hll_sketch_agg_int64_lgk_type.sqlx | 4 ++-- hll/sqlx/hll_sketch_agg_string_lgk_type.sqlx | 4 ++-- hll/sqlx/hll_sketch_agg_union_lgk_type.sqlx | 4 ++-- hll/sqlx/hll_sketch_get_estimate.sqlx | 2 +- hll/sqlx/hll_sketch_get_estimate_and_bounds.sqlx | 2 +- hll/sqlx/hll_sketch_to_string.sqlx | 2 +- hll/sqlx/hll_sketch_union_lgk_type.sqlx | 2 +- kll/sqlx/kll_sketch_float_build.sqlx | 4 ++-- kll/sqlx/kll_sketch_float_get_cdf.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_max_value.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_min_value.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_n.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_normalized_rank_error.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_num_retained.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_pmf.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_quantile.sqlx | 2 +- kll/sqlx/kll_sketch_float_get_rank.sqlx | 2 +- kll/sqlx/kll_sketch_float_kolmogorov_smirnov.sqlx | 2 +- kll/sqlx/kll_sketch_float_merge.sqlx | 4 ++-- kll/sqlx/kll_sketch_float_to_string.sqlx | 2 +- theta/sqlx/theta_sketch_a_not_b_seed.sqlx | 2 +- theta/sqlx/theta_sketch_agg_int64_lgk_seed_p.sqlx | 4 ++-- theta/sqlx/theta_sketch_agg_string_lgk_seed_p.sqlx | 4 ++-- theta/sqlx/theta_sketch_agg_union_lgk_seed.sqlx | 4 ++-- theta/sqlx/theta_sketch_get_estimate_and_bounds_seed.sqlx | 2 +- theta/sqlx/theta_sketch_get_estimate_seed.sqlx | 2 +- theta/sqlx/theta_sketch_get_num_retained_seed.sqlx | 2 +- theta/sqlx/theta_sketch_get_theta_seed.sqlx | 2 +- theta/sqlx/theta_sketch_intersection_seed.sqlx | 2 +- theta/sqlx/theta_sketch_jaccard_similarity_seed.sqlx | 2 +- theta/sqlx/theta_sketch_to_string_seed.sqlx | 2 +- theta/sqlx/theta_sketch_union_lgk_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_a_not_b_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_agg_int64_lgk_seed_p_mode.sqlx | 4 ++-- tuple/sqlx/tuple_sketch_int64_agg_string_lgk_seed_p_mode.sqlx | 4 ++-- tuple/sqlx/tuple_sketch_int64_agg_union_lgk_seed_mode.sqlx | 4 ++-- tuple/sqlx/tuple_sketch_int64_filter_low_high_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_from_theta_sketch_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_get_estimate_and_bounds_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_get_estimate_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_get_num_retained_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_get_sum_estimate_and_bounds_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_get_theta_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_intersection_seed_mode.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_jaccard_similarity_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_to_string_seed.sqlx | 2 +- tuple/sqlx/tuple_sketch_int64_union_lgk_seed_mode.sqlx | 2 +- 59 files changed, 76 insertions(+), 76 deletions(-) diff --git a/README.md b/README.md index 3181270..b044c1b 100644 --- a/README.md +++ b/README.md @@ -41,13 +41,13 @@ page for how to contact us. ## Building, Installing, and Testing - Requires setting environment variables - - GCS_BUCKET: to hold compiled artifacts + - JS_BUCKET: to hold compiled artifacts - BQ_PROJECT: location of stored SQL functions (routines) - BQ_DATASET: location of stored SQL functions (routines) ``` make # performs compilation -make install # upload to $GCS_BUCKET & create functions in $BQ_PROJECT.$BQ_DATASET +make install # upload to $JS_BUCKET & create functions in $BQ_PROJECT.$BQ_DATASET make test # runs predefined tests in BQ ``` diff --git a/cpc/sqlx/cpc_sketch_agg_int64_lgk_seed.sqlx b/cpc/sqlx/cpc_sketch_agg_int64_lgk_seed.sqlx index 57f4ffa..cdb7860 100644 --- a/cpc/sqlx/cpc_sketch_agg_int64_lgk_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_agg_int64_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(value INT64, params STRUCT<lg_k B RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.mjs"], + library=["gs://$JS_BUCKET/cpc_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given INT64 column. Param value: the INT64 column of identifiers. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/CPC/CpcSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/cpc_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/cpc_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/cpc/sqlx/cpc_sketch_agg_string_lgk_seed.sqlx b/cpc/sqlx/cpc_sketch_agg_string_lgk_seed.sqlx index 259b177..2ab31b3 100644 --- a/cpc/sqlx/cpc_sketch_agg_string_lgk_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_agg_string_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(str STRING, params STRUCT<lg_k BY RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.mjs"], + library=["gs://$JS_BUCKET/cpc_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given STRING column. Param str: the STRING column of identifiers. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/CPC/CpcSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/cpc_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/cpc_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/cpc/sqlx/cpc_sketch_agg_union_lgk_seed.sqlx b/cpc/sqlx/cpc_sketch_agg_union_lgk_seed.sqlx index 0b8f80c..9a035a7 100644 --- a/cpc/sqlx/cpc_sketch_agg_union_lgk_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_agg_union_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, params STRUCT<lg_k RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.mjs"], + library=["gs://$JS_BUCKET/cpc_sketch.mjs"], description = '''Creates a sketch that represents the union of the given column of sketches. Param sketch: the column of sketches. Each as BYTES. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/CPC/CpcSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/cpc_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/cpc_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/cpc/sqlx/cpc_sketch_get_estimate_and_bounds_seed.sqlx b/cpc/sqlx/cpc_sketch_get_estimate_and_bounds_seed.sqlx index d47be0c..8127b60 100644 --- a/cpc/sqlx/cpc_sketch_get_estimate_and_bounds_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_get_estimate_and_bounds_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, num_std_devs BYTEINT, seed IN RETURNS STRUCT<estimate FLOAT64, lower_bound FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.js"], + library=["gs://$JS_BUCKET/cpc_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Gets cardinality estimate and bounds from given sketch. diff --git a/cpc/sqlx/cpc_sketch_get_estimate_seed.sqlx b/cpc/sqlx/cpc_sketch_get_estimate_seed.sqlx index 90722ad..aa560a1 100644 --- a/cpc/sqlx/cpc_sketch_get_estimate_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_get_estimate_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.js"], + library=["gs://$JS_BUCKET/cpc_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Gets cardinality estimate and bounds from given sketch. diff --git a/cpc/sqlx/cpc_sketch_to_string_seed.sqlx b/cpc/sqlx/cpc_sketch_to_string_seed.sqlx index 3d74051..eb58d61 100644 --- a/cpc/sqlx/cpc_sketch_to_string_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_to_string_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.js"], + library=["gs://$JS_BUCKET/cpc_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/cpc/sqlx/cpc_sketch_union_lgk_seed.sqlx b/cpc/sqlx/cpc_sketch_union_lgk_seed.sqlx index 5089d5e..f31eeb5 100644 --- a/cpc/sqlx/cpc_sketch_union_lgk_seed.sqlx +++ b/cpc/sqlx/cpc_sketch_union_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, lg_k BYTEINT, RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/cpc_sketch.js"], + library=["gs://$JS_BUCKET/cpc_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar union of the two given sketches. diff --git a/fi/sqlx/frequent_strings_sketch_build.sqlx b/fi/sqlx/frequent_strings_sketch_build.sqlx index 00f9541..eb5a4c7 100644 --- a/fi/sqlx/frequent_strings_sketch_build.sqlx +++ b/fi/sqlx/frequent_strings_sketch_build.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(item STRING, weight INT64, lg_max RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/fs_sketch.mjs"], + library=["gs://$JS_BUCKET/fs_sketch.mjs"], description = '''Creates a sketch that represents frequencies of the given column. Param item: the column of STRING values. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/Frequency/FrequencySketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/fs_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/fs_sketch.mjs"; var Module = await ModuleFactory(); // UDAF interface diff --git a/fi/sqlx/frequent_strings_sketch_get_result.sqlx b/fi/sqlx/frequent_strings_sketch_get_result.sqlx index 4637646..3fb86e6 100644 --- a/fi/sqlx/frequent_strings_sketch_get_result.sqlx +++ b/fi/sqlx/frequent_strings_sketch_get_result.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, error_type STRING, threshold RETURNS ARRAY<STRUCT<item STRING, estimate INT64, lower_bound INT64, upper_bound INT64>> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/fs_sketch.js"], + library=["gs://$JS_BUCKET/fs_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns an array of rows that include frequent items, estimates, lower and upper bounds given an error_type and a threshold. diff --git a/fi/sqlx/frequent_strings_sketch_merge.sqlx b/fi/sqlx/frequent_strings_sketch_merge.sqlx index ac8ec4e..069dfbb 100644 --- a/fi/sqlx/frequent_strings_sketch_merge.sqlx +++ b/fi/sqlx/frequent_strings_sketch_merge.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, lg_max_map_size BYT RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/fs_sketch.mjs"], + library=["gs://$JS_BUCKET/fs_sketch.mjs"], description = '''Merges sketches from the given column. Param sketch: the column of values. @@ -34,7 +34,7 @@ For more information: - https://datasketches.apache.org/docs/Frequency/FrequencySketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/fs_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/fs_sketch.mjs"; var Module = await ModuleFactory(); // UDAF interface diff --git a/fi/sqlx/frequent_strings_sketch_to_string.sqlx b/fi/sqlx/frequent_strings_sketch_to_string.sqlx index 2243e0f..6e6466f 100644 --- a/fi/sqlx/frequent_strings_sketch_to_string.sqlx +++ b/fi/sqlx/frequent_strings_sketch_to_string.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/fs_sketch.js"], + library=["gs://$JS_BUCKET/fs_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/hll/sqlx/hll_sketch_agg_int64_lgk_type.sqlx b/hll/sqlx/hll_sketch_agg_int64_lgk_type.sqlx index b806472..cbc79e0 100644 --- a/hll/sqlx/hll_sketch_agg_int64_lgk_type.sqlx +++ b/hll/sqlx/hll_sketch_agg_int64_lgk_type.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(value INT64, params STRUCT<lg_k B RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.mjs"], + library=["gs://$JS_BUCKET/hll_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given INT64 column. Param value: the INT64 column of identifiers. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/HLL/HllSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/hll_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/hll_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(12); diff --git a/hll/sqlx/hll_sketch_agg_string_lgk_type.sqlx b/hll/sqlx/hll_sketch_agg_string_lgk_type.sqlx index afba618..547cfd9 100644 --- a/hll/sqlx/hll_sketch_agg_string_lgk_type.sqlx +++ b/hll/sqlx/hll_sketch_agg_string_lgk_type.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(str STRING, params STRUCT<lg_k BY RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.mjs"], + library=["gs://$JS_BUCKET/hll_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given STRING column. Param str: the STRING column of identifiers. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/HLL/HllSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/hll_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/hll_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(12); diff --git a/hll/sqlx/hll_sketch_agg_union_lgk_type.sqlx b/hll/sqlx/hll_sketch_agg_union_lgk_type.sqlx index 0a86e4f..ebc2faa 100644 --- a/hll/sqlx/hll_sketch_agg_union_lgk_type.sqlx +++ b/hll/sqlx/hll_sketch_agg_union_lgk_type.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, params STRUCT<lg_k RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.mjs"], + library=["gs://$JS_BUCKET/hll_sketch.mjs"], description = '''Creates a sketch that represents the union of the given column of sketches. Param sketch: the column of sketches. Each as BYTES. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/HLL/HllSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/hll_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/hll_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(12); diff --git a/hll/sqlx/hll_sketch_get_estimate.sqlx b/hll/sqlx/hll_sketch_get_estimate.sqlx index 6605806..67a1e6b 100644 --- a/hll/sqlx/hll_sketch_get_estimate.sqlx +++ b/hll/sqlx/hll_sketch_get_estimate.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.js"], + library=["gs://$JS_BUCKET/hll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/hll/sqlx/hll_sketch_get_estimate_and_bounds.sqlx b/hll/sqlx/hll_sketch_get_estimate_and_bounds.sqlx index cb69563..03002dd 100644 --- a/hll/sqlx/hll_sketch_get_estimate_and_bounds.sqlx +++ b/hll/sqlx/hll_sketch_get_estimate_and_bounds.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, num_std_devs BYTEINT) RETURNS STRUCT<estimate FLOAT64, lower_bound FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.js"], + library=["gs://$JS_BUCKET/hll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Gets cardinality estimate and bounds from given sketch. diff --git a/hll/sqlx/hll_sketch_to_string.sqlx b/hll/sqlx/hll_sketch_to_string.sqlx index cd83b2a..2758db6 100644 --- a/hll/sqlx/hll_sketch_to_string.sqlx +++ b/hll/sqlx/hll_sketch_to_string.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.js"], + library=["gs://$JS_BUCKET/hll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/hll/sqlx/hll_sketch_union_lgk_type.sqlx b/hll/sqlx/hll_sketch_union_lgk_type.sqlx index 5f5fc38..4ecaa3c 100644 --- a/hll/sqlx/hll_sketch_union_lgk_type.sqlx +++ b/hll/sqlx/hll_sketch_union_lgk_type.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, lg_k BYTEINT, RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/hll_sketch.js"], + library=["gs://$JS_BUCKET/hll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the union of the two given sketches. diff --git a/kll/sqlx/kll_sketch_float_build.sqlx b/kll/sqlx/kll_sketch_float_build.sqlx index e8eae78..0185062 100644 --- a/kll/sqlx/kll_sketch_float_build.sqlx +++ b/kll/sqlx/kll_sketch_float_build.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(value FLOAT64, k INT NOT AGGREGAT RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.mjs"], + library=["gs://$JS_BUCKET/kll_sketch.mjs"], description = '''Creates a sketch that represents the distribution of the given column. Param value: the column of FLOAT64 values. @@ -34,7 +34,7 @@ For more information: - https://datasketches.apache.org/docs/KLL/KLLSketch.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/kll_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/kll_sketch.mjs"; var Module = await ModuleFactory(); const default_k = Number(Module.DEFAULT_K); diff --git a/kll/sqlx/kll_sketch_float_get_cdf.sqlx b/kll/sqlx/kll_sketch_float_get_cdf.sqlx index 35eb6e5..eb8b091 100644 --- a/kll/sqlx/kll_sketch_float_get_cdf.sqlx +++ b/kll/sqlx/kll_sketch_float_get_cdf.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, split_points ARRAY<FLOAT64>, RETURNS ARRAY<FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns an approximation to the Cumulative Distribution Function (CDF) of the input stream as an array of cumulative probabilities defined by the given split_points. diff --git a/kll/sqlx/kll_sketch_float_get_max_value.sqlx b/kll/sqlx/kll_sketch_float_get_max_value.sqlx index 1bf4d48..d28087c 100644 --- a/kll/sqlx/kll_sketch_float_get_max_value.sqlx +++ b/kll/sqlx/kll_sketch_float_get_max_value.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the maximum value of the input stream. diff --git a/kll/sqlx/kll_sketch_float_get_min_value.sqlx b/kll/sqlx/kll_sketch_float_get_min_value.sqlx index 9e4aa62..7ff670f 100644 --- a/kll/sqlx/kll_sketch_float_get_min_value.sqlx +++ b/kll/sqlx/kll_sketch_float_get_min_value.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the minimum value of the input stream. diff --git a/kll/sqlx/kll_sketch_float_get_n.sqlx b/kll/sqlx/kll_sketch_float_get_n.sqlx index 346c886..d61aa0f 100644 --- a/kll/sqlx/kll_sketch_float_get_n.sqlx +++ b/kll/sqlx/kll_sketch_float_get_n.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS INT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the length of the input stream. diff --git a/kll/sqlx/kll_sketch_float_get_normalized_rank_error.sqlx b/kll/sqlx/kll_sketch_float_get_normalized_rank_error.sqlx index 2d276df..b7ba158 100644 --- a/kll/sqlx/kll_sketch_float_get_normalized_rank_error.sqlx +++ b/kll/sqlx/kll_sketch_float_get_normalized_rank_error.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, pmf BOOL) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the approximate rank error of the given sketch normalized as a fraction between zero and one. Param sketch: the given sketch as BYTES. diff --git a/kll/sqlx/kll_sketch_float_get_num_retained.sqlx b/kll/sqlx/kll_sketch_float_get_num_retained.sqlx index b9c83f8..40563b8 100644 --- a/kll/sqlx/kll_sketch_float_get_num_retained.sqlx +++ b/kll/sqlx/kll_sketch_float_get_num_retained.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS INT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the number of retained items (samples) in the sketch. diff --git a/kll/sqlx/kll_sketch_float_get_pmf.sqlx b/kll/sqlx/kll_sketch_float_get_pmf.sqlx index ee050fc..35a07bb 100644 --- a/kll/sqlx/kll_sketch_float_get_pmf.sqlx +++ b/kll/sqlx/kll_sketch_float_get_pmf.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, split_points ARRAY<FLOAT64>, RETURNS ARRAY<FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns an approximation to the Probability Mass Function (PMF) of the input stream as an array of probability masses defined by the given split_points. diff --git a/kll/sqlx/kll_sketch_float_get_quantile.sqlx b/kll/sqlx/kll_sketch_float_get_quantile.sqlx index 008db3d..5b1e759 100644 --- a/kll/sqlx/kll_sketch_float_get_quantile.sqlx +++ b/kll/sqlx/kll_sketch_float_get_quantile.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, rank FLOAT64, inclusive BOOL) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a value from the sketch that is the best approximation to a value from the original stream with the given rank. diff --git a/kll/sqlx/kll_sketch_float_get_rank.sqlx b/kll/sqlx/kll_sketch_float_get_rank.sqlx index ae16a1e..4f937f2 100644 --- a/kll/sqlx/kll_sketch_float_get_rank.sqlx +++ b/kll/sqlx/kll_sketch_float_get_rank.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, value FLOAT64, inclusive BOOL RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns an approximation to the normalized rank, on the interval [0.0, 1.0], of the given value. diff --git a/kll/sqlx/kll_sketch_float_kolmogorov_smirnov.sqlx b/kll/sqlx/kll_sketch_float_kolmogorov_smirnov.sqlx index 4c0798e..6c45e8e 100644 --- a/kll/sqlx/kll_sketch_float_kolmogorov_smirnov.sqlx +++ b/kll/sqlx/kll_sketch_float_kolmogorov_smirnov.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, pvalue FLOAT6 RETURNS BOOL LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Performs the Kolmogorov-Smirnov Test between two KLL sketches of type FLOAT64. If the given sketches have insufficient data or if the sketch sizes are too small, this will return false. diff --git a/kll/sqlx/kll_sketch_float_merge.sqlx b/kll/sqlx/kll_sketch_float_merge.sqlx index 8b7ecb3..6cf2b9b 100644 --- a/kll/sqlx/kll_sketch_float_merge.sqlx +++ b/kll/sqlx/kll_sketch_float_merge.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, k INT NOT AGGREGATE RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.mjs"], + library=["gs://$JS_BUCKET/kll_sketch.mjs"], description = '''Merges sketches from the given column. Param sketch: the column of values. @@ -34,7 +34,7 @@ For more information: - https://datasketches.apache.org/docs/KLL/KLLSketch.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/kll_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/kll_sketch.mjs"; var Module = await ModuleFactory(); const default_k = Number(Module.DEFAULT_K); diff --git a/kll/sqlx/kll_sketch_float_to_string.sqlx b/kll/sqlx/kll_sketch_float_to_string.sqlx index 05ad279..08f8c73 100644 --- a/kll/sqlx/kll_sketch_float_to_string.sqlx +++ b/kll/sqlx/kll_sketch_float_to_string.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/kll_sketch.js"], + library=["gs://$JS_BUCKET/kll_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/theta/sqlx/theta_sketch_a_not_b_seed.sqlx b/theta/sqlx/theta_sketch_a_not_b_seed.sqlx index 88571e7..39566e6 100644 --- a/theta/sqlx/theta_sketch_a_not_b_seed.sqlx +++ b/theta/sqlx/theta_sketch_a_not_b_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64) RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar set difference: sketchA and not sketchB. diff --git a/theta/sqlx/theta_sketch_agg_int64_lgk_seed_p.sqlx b/theta/sqlx/theta_sketch_agg_int64_lgk_seed_p.sqlx index c343d80..be80885 100644 --- a/theta/sqlx/theta_sketch_agg_int64_lgk_seed_p.sqlx +++ b/theta/sqlx/theta_sketch_agg_int64_lgk_seed_p.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(value INT64, params STRUCT<lg_k B RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.mjs"], + library=["gs://$JS_BUCKET/theta_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given INT64 column. Param value: the INT64 column of identifiers. @@ -36,7 +36,7 @@ For more information: - https://datasketches.apache.org/docs/Theta/ThetaSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/theta_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/theta_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/theta/sqlx/theta_sketch_agg_string_lgk_seed_p.sqlx b/theta/sqlx/theta_sketch_agg_string_lgk_seed_p.sqlx index 65435ed..a92f0fb 100644 --- a/theta/sqlx/theta_sketch_agg_string_lgk_seed_p.sqlx +++ b/theta/sqlx/theta_sketch_agg_string_lgk_seed_p.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(str STRING, params STRUCT<lg_k BY RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.mjs"], + library=["gs://$JS_BUCKET/theta_sketch.mjs"], description = '''Creates a sketch that represents the cardinality of the given STRING column. Param str: the STRING column of identifiers. @@ -36,7 +36,7 @@ For more information: - https://datasketches.apache.org/docs/Theta/ThetaSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/theta_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/theta_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/theta/sqlx/theta_sketch_agg_union_lgk_seed.sqlx b/theta/sqlx/theta_sketch_agg_union_lgk_seed.sqlx index 0f46797..a7af908 100644 --- a/theta/sqlx/theta_sketch_agg_union_lgk_seed.sqlx +++ b/theta/sqlx/theta_sketch_agg_union_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, params STRUCT<lg_k RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.mjs"], + library=["gs://$JS_BUCKET/theta_sketch.mjs"], description = '''Creates a sketch that represents the union of the given column of sketches. Param sketch: the column of sketches. Each as BYTES. @@ -35,7 +35,7 @@ For more information: - https://datasketches.apache.org/docs/Theta/ThetaSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/theta_sketch.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/theta_sketch.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/theta/sqlx/theta_sketch_get_estimate_and_bounds_seed.sqlx b/theta/sqlx/theta_sketch_get_estimate_and_bounds_seed.sqlx index a23ab12..6429f5e 100644 --- a/theta/sqlx/theta_sketch_get_estimate_and_bounds_seed.sqlx +++ b/theta/sqlx/theta_sketch_get_estimate_and_bounds_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, num_std_devs BYTEINT, seed IN RETURNS STRUCT<estimate FLOAT64, lower_bound FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Gets cardinality estimate and bounds from given sketch. diff --git a/theta/sqlx/theta_sketch_get_estimate_seed.sqlx b/theta/sqlx/theta_sketch_get_estimate_seed.sqlx index c851990..1e51917 100644 --- a/theta/sqlx/theta_sketch_get_estimate_seed.sqlx +++ b/theta/sqlx/theta_sketch_get_estimate_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Gets cardinality estimate and bounds from given sketch. diff --git a/theta/sqlx/theta_sketch_get_num_retained_seed.sqlx b/theta/sqlx/theta_sketch_get_num_retained_seed.sqlx index 3337aa2..bb0eea1 100644 --- a/theta/sqlx/theta_sketch_get_num_retained_seed.sqlx +++ b/theta/sqlx/theta_sketch_get_num_retained_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS INT LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the number of retained entries in the given sketch. diff --git a/theta/sqlx/theta_sketch_get_theta_seed.sqlx b/theta/sqlx/theta_sketch_get_theta_seed.sqlx index b219801..3c4293f 100644 --- a/theta/sqlx/theta_sketch_get_theta_seed.sqlx +++ b/theta/sqlx/theta_sketch_get_theta_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns theta (effective sampling rate) as a fraction from 0 to 1. diff --git a/theta/sqlx/theta_sketch_intersection_seed.sqlx b/theta/sqlx/theta_sketch_intersection_seed.sqlx index b219916..8e4763a 100644 --- a/theta/sqlx/theta_sketch_intersection_seed.sqlx +++ b/theta/sqlx/theta_sketch_intersection_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64) RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar intersection of the two given sketches. diff --git a/theta/sqlx/theta_sketch_jaccard_similarity_seed.sqlx b/theta/sqlx/theta_sketch_jaccard_similarity_seed.sqlx index eb586a4..2e8673b 100644 --- a/theta/sqlx/theta_sketch_jaccard_similarity_seed.sqlx +++ b/theta/sqlx/theta_sketch_jaccard_similarity_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64) RETURNS STRUCT<lower_bound FLOAT64, estimate FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes the Jaccard similarity index with upper and lower bounds. The Jaccard similarity index J(A,B) = (A ^ B)/(A U B) is used to measure how similar the two sketches are to each other. diff --git a/theta/sqlx/theta_sketch_to_string_seed.sqlx b/theta/sqlx/theta_sketch_to_string_seed.sqlx index 353c6a2..ec2e3bc 100644 --- a/theta/sqlx/theta_sketch_to_string_seed.sqlx +++ b/theta/sqlx/theta_sketch_to_string_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a summary string that represents the state of the given sketch. diff --git a/theta/sqlx/theta_sketch_union_lgk_seed.sqlx b/theta/sqlx/theta_sketch_union_lgk_seed.sqlx index dbec694..eaad4f1 100644 --- a/theta/sqlx/theta_sketch_union_lgk_seed.sqlx +++ b/theta/sqlx/theta_sketch_union_lgk_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, lg_k BYTEINT, RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/theta_sketch.js"], + library=["gs://$JS_BUCKET/theta_sketch.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar union of the two given sketches. diff --git a/tuple/sqlx/tuple_sketch_int64_a_not_b_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_a_not_b_seed.sqlx index b069b20..e480824 100644 --- a/tuple/sqlx/tuple_sketch_int64_a_not_b_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_a_not_b_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64) RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar set difference of sketchA and not sketchB. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_agg_int64_lgk_seed_p_mode.sqlx b/tuple/sqlx/tuple_sketch_int64_agg_int64_lgk_seed_p_mode.sqlx index 12d292c..16b1654 100644 --- a/tuple/sqlx/tuple_sketch_int64_agg_int64_lgk_seed_p_mode.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_agg_int64_lgk_seed_p_mode.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(key INT64, value INT64, params ST RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.mjs"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.mjs"], description = '''Builds a Tuple Sketch from an INT64 Key column and an INT64 value column. Multiple values for the same key are aggregated using one of the selectable operations: { SUM, MIN, MAX, ONE (constant 1) }. Note that cardinality estimation accuracy, plots, error tables, and sampling probability p are the same as the Theta Sketch. @@ -41,7 +41,7 @@ For more information: - https://datasketches.apache.org/docs/Tuple/TupleSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/tuple_sketch_int64.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/tuple_sketch_int64.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/tuple/sqlx/tuple_sketch_int64_agg_string_lgk_seed_p_mode.sqlx b/tuple/sqlx/tuple_sketch_int64_agg_string_lgk_seed_p_mode.sqlx index 2fb7747..2cba857 100644 --- a/tuple/sqlx/tuple_sketch_int64_agg_string_lgk_seed_p_mode.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_agg_string_lgk_seed_p_mode.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(key STRING, value INT64, params S RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.mjs"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.mjs"], description = '''Builds a Tuple Sketch from an STRING Key column and an INT64 value column. Multiple values for the same key are aggregated using one of the selectable operations: SUM, MIN, MAX, ONE. Note that cardinality estimation accuracy, plots, error tables, and sampling probability p are the same as the Theta Sketch. @@ -41,7 +41,7 @@ For more information: - https://datasketches.apache.org/docs/Tuple/TupleSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/tuple_sketch_int64.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/tuple_sketch_int64.mjs"; var Module = await ModuleFactory(); const default_lg_k = Number(Module.DEFAULT_LG_K); const default_seed = BigInt(Module.DEFAULT_SEED); diff --git a/tuple/sqlx/tuple_sketch_int64_agg_union_lgk_seed_mode.sqlx b/tuple/sqlx/tuple_sketch_int64_agg_union_lgk_seed_mode.sqlx index 3a720b4..fdc2ed5 100644 --- a/tuple/sqlx/tuple_sketch_int64_agg_union_lgk_seed_mode.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_agg_union_lgk_seed_mode.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE AGGREGATE FUNCTION ${self()}(sketch BYTES, params STRUCT<lg_k RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.mjs"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.mjs"], description = '''Builds a Tuple Sketch that represents the UNION of the given column of Tuple Sketches. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. This function only applies to Tuple Sketches with an INT64 summary column. @@ -38,7 +38,7 @@ For more information: - https://datasketches.apache.org/docs/Tuple/TupleSketches.html ''' ) AS R""" -import ModuleFactory from "gs://$GCS_BUCKET/tuple_sketch_int64.mjs"; +import ModuleFactory from "gs://$JS_BUCKET/tuple_sketch_int64.mjs"; var Module = await ModuleFactory(); function ensureUnion(state) { diff --git a/tuple/sqlx/tuple_sketch_int64_filter_low_high_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_filter_low_high_seed.sqlx index f0f6edd..5bbf16f 100644 --- a/tuple/sqlx/tuple_sketch_int64_filter_low_high_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_filter_low_high_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, low INT64, high INT64, seed I RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a Tuple Sketch computed from the given sketch filtered by the given low and high values. This returns a compact tuple sketch that contains the subset of rows of the give sketch where the diff --git a/tuple/sqlx/tuple_sketch_int64_from_theta_sketch_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_from_theta_sketch_seed.sqlx index 6878e6f..333dd40 100644 --- a/tuple/sqlx/tuple_sketch_int64_from_theta_sketch_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_from_theta_sketch_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, value INT64, seed INT64) RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Converts the given Theta Sketch into a Tuple Sketch with a INT64 summary column set to the given INT64 value. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_get_estimate_and_bounds_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_get_estimate_and_bounds_seed.sqlx index 9884fc9..3582495 100644 --- a/tuple/sqlx/tuple_sketch_int64_get_estimate_and_bounds_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_get_estimate_and_bounds_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, num_std_devs BYTEINT, seed IN RETURNS STRUCT<estimate FLOAT64, lower_bound FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the cardinality estimate and bounds from the given Tuple Sketch. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_get_estimate_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_get_estimate_seed.sqlx index 2228e37..bf993f6 100644 --- a/tuple/sqlx/tuple_sketch_int64_get_estimate_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_get_estimate_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the cardinality estimate of the given Tuple Sketch. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_get_num_retained_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_get_num_retained_seed.sqlx index 313c369..e99eb01 100644 --- a/tuple/sqlx/tuple_sketch_int64_get_num_retained_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_get_num_retained_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS INT LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the number of retained entries in the given sketch. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_get_sum_estimate_and_bounds_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_get_sum_estimate_and_bounds_seed.sqlx index a90526c..c7f8957 100644 --- a/tuple/sqlx/tuple_sketch_int64_get_sum_estimate_and_bounds_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_get_sum_estimate_and_bounds_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, num_std_devs BYTEINT, seed IN RETURNS STRUCT<sum_estimate FLOAT64, sum_lower_bound FLOAT64, sum_upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns the estimate and bounds for the sum of the INT64 summary column scaled to the original population from the given Tuple Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_get_theta_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_get_theta_seed.sqlx index 9f33fec..30b338a 100644 --- a/tuple/sqlx/tuple_sketch_int64_get_theta_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_get_theta_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS FLOAT64 LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns theta (effective sampling rate) as a fraction from 0 to 1. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_intersection_seed_mode.sqlx b/tuple/sqlx/tuple_sketch_int64_intersection_seed_mode.sqlx index 3e1c42f..4f9ae7b 100644 --- a/tuple/sqlx/tuple_sketch_int64_intersection_seed_mode.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_intersection_seed_mode.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64, m RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a sketch that represents the scalar intersection of sketchA and sketchB. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_jaccard_similarity_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_jaccard_similarity_seed.sqlx index 06412a2..aa1d6ad 100644 --- a/tuple/sqlx/tuple_sketch_int64_jaccard_similarity_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_jaccard_similarity_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, seed INT64) RETURNS STRUCT<lower_bound FLOAT64, estimate FLOAT64, upper_bound FLOAT64> LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes the Jaccard similarity index with upper and lower bounds. The Jaccard similarity index J(A,B) = (A ^ B)/(A U B) is used to measure how similar the two sketches are to each other. diff --git a/tuple/sqlx/tuple_sketch_int64_to_string_seed.sqlx b/tuple/sqlx/tuple_sketch_int64_to_string_seed.sqlx index 9ee21bc..eebb0b5 100644 --- a/tuple/sqlx/tuple_sketch_int64_to_string_seed.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_to_string_seed.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketch BYTES, seed INT64) RETURNS STRING LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Returns a human readable STRING that is a short summary of the state of this sketch. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. diff --git a/tuple/sqlx/tuple_sketch_int64_union_lgk_seed_mode.sqlx b/tuple/sqlx/tuple_sketch_int64_union_lgk_seed_mode.sqlx index 52c3944..cedd7b1 100644 --- a/tuple/sqlx/tuple_sketch_int64_union_lgk_seed_mode.sqlx +++ b/tuple/sqlx/tuple_sketch_int64_union_lgk_seed_mode.sqlx @@ -23,7 +23,7 @@ CREATE OR REPLACE FUNCTION ${self()}(sketchA BYTES, sketchB BYTES, lg_k BYTEINT, RETURNS BYTES LANGUAGE js OPTIONS ( - library=["gs://$GCS_BUCKET/tuple_sketch_int64.js"], + library=["gs://$JS_BUCKET/tuple_sketch_int64.js"], js_parameter_encoding_mode='STANDARD', description = '''Computes a Tuple Sketch that represents the UNION of sketchA and sketchB. Note that cardinality estimation accuracy, plots, and error tables are the same as the Theta Sketch. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
