[ https://issues.apache.org/jira/browse/DRILL-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15766721#comment-15766721 ]
Roman commented on DRILL-4963: ------------------------------ Found similar case with different error: Run query for first time: {code:sql} select subqueryudf(t1.first_name, t2.last_name) from cp.`employee.json` t1 inner join (select last_name, subqueryudf(first_name, last_name) as full_name from cp.`employee.json`) t2 on subqueryudf(t1.first_name, t1.last_name)=t2.full_name order by t1.employee_id limit 1; {code} Error: VALIDATION ERROR: From line 1, column 248 to line 1, column 249: Table 't1' not found SQL Query null And second time: {code:sql} select subqueryudf(t1.first_name, t2.last_name) from cp.`employee.json` t1 inner join (select last_name, subqueryudf(first_name, last_name) as full_name from cp.`employee.json`) t2 on subqueryudf(t1.first_name, t1.last_name)=t2.full_name order by t1.employee_id limit 1; {code} +---------------+ | EXPR$0 | +---------------+ | Sheri Nowmer | +---------------+ 1 row selected (0.3 seconds) > Issues when overloading Drill native functions with dynamic UDFs > ---------------------------------------------------------------- > > Key: DRILL-4963 > URL: https://issues.apache.org/jira/browse/DRILL-4963 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.9.0 > Reporter: Roman > Assignee: Arina Ielchiieva > Attachments: test_overloading-1.0-sources.jar, > test_overloading-1.0.jar > > > I created jar file which overloads 3 DRILL native functions > (LOG(VARCHAR-REQUIRED), CURRENT_DATE(VARCHAR-REQUIRED) and > ABS(VARCHAR-REQUIRED,VARCHAR-REQUIRED)) and registered it as dynamic UDF. > If I try to use my functions I will get errors: > {code:xml} > SELECT CURRENT_DATE('test') FROM (VALUES(1)); > {code} > Error: FUNCTION ERROR: CURRENT_DATE does not support operand types (CHAR) > SQL Query null > {code:xml} > SELECT ABS('test','test') FROM (VALUES(1)); > {code} > Error: FUNCTION ERROR: ABS does not support operand types (CHAR,CHAR) > SQL Query null > {code:xml} > SELECT LOG('test') FROM (VALUES(1)); > {code} > Error: SYSTEM ERROR: DrillRuntimeException: Failure while materializing > expression in constant expression evaluator LOG('test'). Errors: > Error in expression at index -1. Error: Missing function implementation: > castTINYINT(VARCHAR-REQUIRED). Full expression: UNKNOWN EXPRESSION. > But if I rerun all this queries after "DrillRuntimeException", they will run > correctly. It seems that Drill have not updated the function signature before > that error. Also if I add jar as usual UDF (copy jar to > /drill_home/jars/3rdparty and restart drillbits), all queries will run > correctly without errors. -- This message was sent by Atlassian JIRA (v6.3.4#6332)