CODEWITHSUNDEEP
javascriptgoogle-bigqueryuser-defined-functionsint64
Guig
Guig

Reputation: 10197

output INT64 from js UDF

I'm trying to use BigQuery's INT64 type to hold bit encoded information. I have to use a javascript udf function and I'd like to use all the 64 bits.

My issue is that javascript only deals with int32 so 1 << 32 == 1 and I'm not sure how to use the full 64 range that BigQuery supports in the udf.

Upvotes: 0

Views: 181

Answers (1)

I&#241;igo
I&#241;igo

Reputation: 2670

It’s not possible to directly convert Big Query’s INT64 type to JavaScript UDF, neither as input nor output, as JavaScript does not support 64-bit integer type [1]. You could use FLOAT64 instead, as far as the values are less than 2^53 - 1, since it follows the IEEE 754-2008 standard for double precision [2]. You can also use a string containing the number value. Here is the documentation for supported external UDF data types [3].

Upvotes: 1

Related Questions