jrossthomson / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
0 stars 0 forks source link

Error while testing kruskal_wallis udf #4

Closed boaguilar closed 3 years ago

boaguilar commented 3 years ago

While testing the code I got errors:

AssertionError: Access Denied: BigQuery BigQuery: Error getting metadata for external code resource, please verify you have provided a valid path and/or that you have access to the resource: ${JS_BUCKET}/jstat-v1.9.4.min.js

I am wondering if I am missing a step in the testing process.

jrossthomson commented 3 years ago

Hey Boris I pulled your branch to a new branch which has Ian's latest additions: add-boris I think if you follow the new instructions in contributing.md, you should be able to get the KW working. I think there are just some minor issues with SQL some of the UDFs you posted. I think the UI is a bit more liberal. Let me know if you want to get on a call to work on it together.

boaguilar commented 3 years ago

HI Ross, I got the pvalue test running without problems, so looks like the jStat library is working fine; but the kruskal_wallis function is still generating errors after I do bash tests/run.sh -k community_kruskal_wallis

E AssertionError: Function not found: cgc-05-0042.fn_test_local_test.pvalue at [35:27]

jrossthomson commented 3 years ago

Fixed as updating use of ENV variable.