Call math functions from UDFs

Quansight / omnisci

Explorations on using MapD and Jupyter together.

4 stars 1 forks source link

Call math functions from UDFs #81

Closed pearu closed 4 years ago

pearu commented 4 years ago

Originally raised in https://github.com/Quansight/pearu-issues/issues/20

Example case:

@omnisci
def mysin(x):
    return math.sin(x)  # or numpy.sin(x)

query = 'select x, mysin(x) from mytable'
# executing query should return sin values

Todo:

[x] identify the problem if any
[x] fix it

Background: UDF definitions should be able to use any functions that are made available in the omniscidb LLVM IR module linkage phase.

pearu commented 4 years ago

https://github.com/xnd-project/rbc/issues/40 https://github.com/xnd-project/rbc/issues/38 https://github.com/xnd-project/rbc/issues/32 https://github.com/xnd-project/rbc/issues/31

guilhermeleobas commented 4 years ago

[x] xnd-project/rbc#40 - Add NumPy types to rbc typesystem.
[x] xnd-project/rbc#38 - List of NumPy math functions that Omniscidb supports. Closed in favor of xnd-project/rbc#31
[x] xnd-project/rbc#32 - Resolves the infinity recursion when registering UDFs with specific names.
[ ] xnd-project/rbc#31 - Contains a list of numpy functions that Omniscidb supports.

We can close this issue and open a new open for xnd-project/rbc#31.

Edit: We can put a list of numpy functions that should be good to have and aim for those in this new issue.