5,523 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
85
views
Passing Parameters to a User Defined Function from within a Snowflake Stored Procedure
I have an interesting issue with passing parameters to a udf from within a stored procedure. I can pass one parameter and send a valid string value for the second parameter, and it works fine. See ...
0
votes
1
answer
110
views
Does Databricks Spark SQL evaluate all CASE branches for UDFs?
I'm using Databricks SQL and have SQL UDFs for GeoIP / ISP lookups.
Each UDF branches on IPv4 vs IPv6 using a CASE expression like:
CASE
WHEN ip_address LIKE '%:%:%' THEN -- IPv6 path
...
...
0
votes
0
answers
69
views
How to achieve dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a Table Valued Function (TVF) that takes an array of IDs as input.
source_table: A very large table (TBs) partitioned by day on capturedTimestamp.
selection_table: A small lookup table that ...
Tooling
0
votes
3
replies
48
views
How to enforce dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a table-valued function (TVF) that takes an array of IDs as input.
source_table: a very large table (TBs) partitioned by day on capturedTimestamp
selection_table: a small lookup table that ...
Advice
0
votes
0
replies
27
views
Fluent UDF to set the particle z position to its initial z position
I need to fix the particle position in the z direction to its initial value. The following is the UDF I tried:
#include "udf.h"
#include "dpm.h"
DEFINE_DPM_SCALAR_UPDATE(...
1
vote
1
answer
208
views
An R-function for Creating a String
When typing
gsub(" ", "", gsub("\"", "", deparse(quote(2025-B3))))
the output is [1] "2025-B3"
Typing
gsub(" ", "", gsub(&...
0
votes
0
answers
88
views
Cannot successfully create the simplest LibreOffice extension for UDF's
New here. Beginner with Python and LibreOffice. Some experience with C#.
OS: Win 11
LO: 25.8
I have been trying to learn how to create a LO extension to provide UDF's for use in LO Calc. I have dozens ...
2
votes
1
answer
109
views
Why UDF returns NULL for multi-row query but not for single row?
I ran the following query to retrieve data for a single investment ID:
select *, getProductClass(InstrumentID, etf_option_mapper) as ProductClass
from investor_pos
where InvestorID = '7399000270'
...
0
votes
1
answer
258
views
polars map_batches return_dtype argument for arrays
I am applying a user defined function (UDF) to a polars dataframe using the map_batches function (c.p. https://docs.pola.rs/user-guide/expressions/user-defined-python-functions/#combining-multiple-...
0
votes
0
answers
23
views
Why does the object ‘date’ trigger ‘neither XDB connection nor function’ error in my function?
I’m encountering an error when defining a query function in DolphinDB. Here’s my scenario:
Table Definition:
dt = 2025年01月01日T01:01:51.100 2025年01月02日T01:01:51.000 2025年01月03日T04:01:51.900
sym = ["...
1
vote
1
answer
134
views
How do I load joblib file on spark?
I have following Code. It reads a pre-existing file for a ML model. I am trying to run it on databricks on multiple cases
import numpy as np
import joblib
class WeightedEnsembleRegressor:
"&...
0
votes
1
answer
62
views
The "Sheet" function in Uno FunctionAccess always returns "2"
This function:
Function SheetIndex() As Long
Dim oFunctionAccess As Object
oFunctionAccess = CreateUnoService("com.sun.star.sheet.FunctionAccess")
SheetIndex = oFunctionAccess....
0
votes
1
answer
91
views
MyEval creates a circular reference, how is this possible?
When there are multiple cells using this UDF, they give results but they are recalculated endlessly and most of the time most of the cells give circular reference error (Err:522):
Option Explicit
...
0
votes
1
answer
75
views
Use threading for UDF in databricks to use new api token
I have a dataframe that needs to be used row-wise for API calls. Therefore I implemented a UDF for it. It takes each row uses the data from that row to make an api call and stores an id from the ...
1
vote
1
answer
73
views
Function to add a command line to an existing function [closed]
I need to write a function to add a particular command/string of characters to an existing function.
Consider this function:
constraint = function(cov_matrix,max_variance){
function(x){
f = NULL
g =...