Comments (5)
If you're modifying js_libs.yaml, you need to build from scratch in your own project using the cloudbuild.yaml file in udfs/ directory.
For example, from the udfs/ directory run the following:
gcloud builds submit . --substitutions _JS_BUCKET=gs://YOUR_BUCKET/PATH/TO/JS_LIBS,_BQ_LOCATION=US-CENTRAL1
from bigquery-utils.
Thanks! I just tried that command, which looks like it built the proper steps. However, I still got an error. See below.
(Note that earlier I tried the cloud build based on the README but that one didn't work gcloud builds submit . --config=deploy.yaml --substitutions _PROJECT_ID=abc,_BQ_LOCATION=US-CENTRAL1,_JS_BUCKET=gs://your_bucket/path/to/libs
. The command you provided above started working, but then got the error)
Starting Step #1 - "install_npm_packages"
Step #1 - "install_npm_packages": Already have image (with digest): gcr.io/bqutil/bq_udf_ci
Step #1 - "install_npm_packages": npm ERR! code 1
Step #1 - "install_npm_packages": npm ERR! path /workspace/node_modules/fast-text-v1.0.2
Step #1 - "install_npm_packages": npm ERR! command failed
Step #1 - "install_npm_packages": npm ERR! command sh -c node-gyp rebuild
Step #1 - "install_npm_packages": npm ERR! make: Entering directory '/workspace/node_modules/fast-text-v1.0.2/build'
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/args.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/dictionary.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/fasttext.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/matrix.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/model.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/productquantizer.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/qmatrix.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/utils.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/lib/src/vector.o
Step #1 - "install_npm_packages": npm ERR! CXX(target) Release/obj.target/fasttext/src/nodeArgument.o
Step #1 - "install_npm_packages": npm ERR! make: Leaving directory '/workspace/node_modules/fast-text-v1.0.2/build'
Step #1 - "install_npm_packages": npm ERR! gyp info it worked if it ends with ok
Step #1 - "install_npm_packages": npm ERR! gyp info using [email protected]
Step #1 - "install_npm_packages": npm ERR! gyp info using [email protected] | linux | x64
Step #1 - "install_npm_packages": npm ERR! gyp info find Python using Python version 3.7.3 found at "/usr/bin/python3"
Step #1 - "install_npm_packages": npm ERR! gyp http GET https://nodejs.org/download/release/v16.9.1/node-v16.9.1-headers.tar.gz
Step #1 - "install_npm_packages": npm ERR! gyp http 200 https://nodejs.org/download/release/v16.9.1/node-v16.9.1-headers.tar.gz
Step #1 - "install_npm_packages": npm ERR! gyp http GET https://nodejs.org/download/release/v16.9.1/SHASUMS256.txt
Step #1 - "install_npm_packages": npm ERR! gyp http 200 https://nodejs.org/download/release/v16.9.1/SHASUMS256.txt
Step #1 - "install_npm_packages": npm ERR! (node:27) [DEP0150] DeprecationWarning: Setting process.config is deprecated. In the future the property will be read-only.
Step #1 - "install_npm_packages": npm ERR! (Use `node --trace-deprecation ...` to show where the warning was created)
Step #1 - "install_npm_packages": npm ERR! gyp info spawn /usr/bin/python3
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args [
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/gyp/gyp_main.py',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args 'binding.gyp',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-f',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args 'make',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-I',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '/workspace/node_modules/fast-text-v1.0.2/build/config.gypi',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-I',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/addon.gypi',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-I',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '/builder/home/.cache/node-gyp/16.9.1/include/node/common.gypi',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dlibrary=shared_library',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dvisibility=default',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dnode_root_dir=/builder/home/.cache/node-gyp/16.9.1',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dnode_gyp_dir=/usr/lib/node_modules/npm/node_modules/node-gyp',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dnode_lib_file=/builder/home/.cache/node-gyp/16.9.1/<(target_arch)/node.lib',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dmodule_root_dir=/workspace/node_modules/fast-text-v1.0.2',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Dnode_engine=v8',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '--depth=.',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '--no-parallel',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '--generator-output',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args 'build',
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args '-Goutput_dir=.'
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args ]
Step #1 - "install_npm_packages": npm ERR! gyp info spawn make
Step #1 - "install_npm_packages": npm ERR! gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
Step #1 - "install_npm_packages": npm ERR! ../lib/src/args.cc: In member function 'void fasttext::Args::parseArgs(const std::vector<std::__cxx11::basic_string<char> >&)':
Step #1 - "install_npm_packages": npm ERR! ../lib/src/args.cc:162:19: warning: catching polymorphic type 'class std::out_of_range' by value [-Wcatch-value=]
Step #1 - "install_npm_packages": npm ERR! } catch (std::out_of_range) {
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~~~~~~
Step #1 - "install_npm_packages": npm ERR! In file included from /builder/home/.cache/node-gyp/16.9.1/include/node/v8.h:30,
Step #1 - "install_npm_packages": npm ERR! from /builder/home/.cache/node-gyp/16.9.1/include/node/node.h:63,
Step #1 - "install_npm_packages": npm ERR! from ../src/nodeArgument.cc:8:
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h: In function 'void v8::internal::PerformCastCheck(T*)':
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:38: error: 'remove_cv_t' is not a member of 'std'
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~~~~~
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:38: note: suggested alternative: 'remove_cv'
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~~~~~
Step #1 - "install_npm_packages": npm ERR! remove_cv
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:38: error: 'remove_cv_t' is not a member of 'std'
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:38: note: suggested alternative: 'remove_cv'
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~~~~~
Step #1 - "install_npm_packages": npm ERR! remove_cv
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:50: error: template argument 2 is invalid
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:63: error: '::Perform' has not been declared
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8-internal.h:489:63: note: suggested alternative: 'perror'
Step #1 - "install_npm_packages": npm ERR! !std::is_same<Data, std::remove_cv_t<T>>::value>::Perform(data);
Step #1 - "install_npm_packages": npm ERR! ^~~~~~~
Step #1 - "install_npm_packages": npm ERR! perror
Step #1 - "install_npm_packages": npm ERR! ../src/nodeArgument.cc: In member function 'v8::Local<v8::Object> NodeArgument::NodeArgument::mapToObject(std::map<std::__cxx11::basic_string<char>, std::__cxx11::basic_string<char> >)':
Step #1 - "install_npm_packages": npm ERR! ../src/nodeArgument.cc:211:7: warning: ignoring return value of 'v8::Maybe<bool> v8::Object::Set(v8::Local<v8::Context>, v8::Local<v8::Value>, v8::Local<v8::Value>)', declared with attribute warn_unused_result [-Wunused-result]
Step #1 - "install_npm_packages": npm ERR! );
Step #1 - "install_npm_packages": npm ERR! ^
Step #1 - "install_npm_packages": npm ERR! In file included from /builder/home/.cache/node-gyp/16.9.1/include/node/node.h:63,
Step #1 - "install_npm_packages": npm ERR! from ../src/nodeArgument.cc:8:
Step #1 - "install_npm_packages": npm ERR! /builder/home/.cache/node-gyp/16.9.1/include/node/v8.h:3961:37: note: declared here
Step #1 - "install_npm_packages": npm ERR! V8_WARN_UNUSED_RESULT Maybe<bool> Set(Local<Context> context,
Step #1 - "install_npm_packages": npm ERR! ^~~
Step #1 - "install_npm_packages": npm ERR! make: *** [fasttext.target.mk:150: Release/obj.target/fasttext/src/nodeArgument.o] Error 1
Step #1 - "install_npm_packages": npm ERR! gyp ERR! build error
Step #1 - "install_npm_packages": npm ERR! gyp ERR! stack Error: `make` failed with exit code: 2
Step #1 - "install_npm_packages": npm ERR! gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23)
Step #1 - "install_npm_packages": npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:394:28)
Step #1 - "install_npm_packages": npm ERR! gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:290:12)
Step #1 - "install_npm_packages": npm ERR! gyp ERR! System Linux 5.10.0-18-cloud-amd64
Step #1 - "install_npm_packages": npm ERR! gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
Step #1 - "install_npm_packages": npm ERR! gyp ERR! cwd /workspace/node_modules/fast-text-v1.0.2
Step #1 - "install_npm_packages": npm ERR! gyp ERR! node -v v16.9.1
Step #1 - "install_npm_packages": npm ERR! gyp ERR! node-gyp -v v7.1.2
Step #1 - "install_npm_packages": npm ERR! gyp ERR! not ok
Step #1 - "install_npm_packages":
Step #1 - "install_npm_packages": npm ERR! A complete log of this run can be found in:
Step #1 - "install_npm_packages": npm ERR! /builder/home/.npm/_logs/2022-12-01T03_29_21_009Z-debug.log
Finished Step #1 - "install_npm_packages"
ERROR
ERROR: build step 1 "gcr.io/bqutil/bq_udf_ci" failed: step exited with non-zero status: 1
This is my js_libs.yaml file:
compromise:
versions:
- 11.14.3
js-levenshtein:
versions:
- 1.1.6
jstat:
versions:
- 1.9.3
- 1.9.4
cld:
versions:
- 2.8.4
languagedetect:
versions:
- 2.0.0
fast-text:
versions:
- 1.0.2
from bigquery-utils.
cld and fast-text are the problematic libraries.
It builds successfully without those 2
Our build process uses webpack to create one js file for UDFs to reference, can you try and see if you can build those 2 libs using webpack outside our UDF build process. I think the issue stems from a compatibility issue between those libs and webpack
from bigquery-utils.
Thanks! I was able to get it to work after removing cld and fast-text. I haven't tried manually webpacking them, but will do so. Also, I may try to add those to the "minify" exception list to see if that might help. But I can add one at a time and see what breaks.
Appreciate the help here!
from bigquery-utils.
Am closing this issue. We were able to get the build working properly.
(Note, we did test cld and it did not work to webpack it manually. There was some webpack error)
from bigquery-utils.
Related Issues (20)
- UDF: "url_param" is missing for first query HOT 1
- Documentation for new users is difficult to follow HOT 4
- Missing values are not taken into account in UDF "median".
- System Table Dashboards - Load Slot Estimator
- Incorrect BigQuery billing analytics SQL script HOT 1
- Dataset - Job Concurrency Slow Job - change_timestamp Unavailable in INFORMATION_SCHEMA.RESERVATIONS HOT 1
- Why is slot_count negative when action <> 'UPDATE'? HOT 5
- Security Policy violation Binary Artifacts HOT 129
- Unable to view the images in bigquery-utils folder. HOT 1
- Request: Handling for objects in json_extract_values function HOT 2
- Ensure all UDFs have description set in their DDL HOT 2
- Add UDFs for generating deep links to tables and jobs HOT 1
- Some of the hyperlink is not working
- Add report showing projects using on demand slots
- Missing Datasource for Hourly Utilization Heatmap section
- Discussion: Create bqutil UDFs in all other non-US datasets HOT 1
- Bug: Jaccard UDF giving incorrect results in some cases HOT 1
- BigQuery UDFs not available outside the US and documentation unclear? HOT 1
- Export data as protocol buffer does not work for more than one field HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bigquery-utils.