Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot use user defined functions in ETL process #5236

Closed
AlessioDeAngelis opened this issue Oct 28, 2015 · 1 comment
Closed

Cannot use user defined functions in ETL process #5236

AlessioDeAngelis opened this issue Oct 28, 2015 · 1 comment
Assignees
Labels

Comments

@AlessioDeAngelis
Copy link

Hello,
I created with Studio a dummy javascript function test() that simply returns 0.
It works perfectly when I call it in STUDIO in a simple query
SELECT test() FROM V.
However, when I try to call it within the etl process, orientdb doesn't recognize it.

{ "field": {"fieldName": "test", "expression": "eval('test()')" } }

{ "field": {"fieldName": "test", "expression": "test()" } }

In both cases I have the following error:

Error in Pipeline execution: com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing command at position #0: Error on parsing query
Query: test()
------^
ETL process halted: com.orientechnologies.orient.etl.OETLProcessHaltedException: Halt
Exception in thread "main" com.orientechnologies.orient.etl.OETLProcessHaltedException: Halt
at com.orientechnologies.orient.etl.OETLPipeline.execute(OETLPipeline.java:149)
at com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:458)

Caused by: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: No function with name 'test', available names are : [outv,percentile,ifnull,both,last,count,set,traversedvertex,sum,bothv,date,shortestpath,distinct,mode,distance,document,if,gremlin,map,bothe,avg,dijkstra,min,encode,coalesce,max,eval,traversedelement,ine,label,variance,list,format,in,concat,decimal,difference,symmetricdifference,median,decode,unionall,sysdate,intersect,inv,stddev,uuid,traversededge,oute,first,out]

Is there another way to call user defined functions?
Thank you.
Alessio

@tanhv90
Copy link

tanhv90 commented Oct 14, 2016

Hello @luigidellaquila ,

How about the current status of this issue?
I'm facing same problem on 2.2.11.

Best regards,
Tan

@laa laa closed this as completed Aug 4, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

5 participants