Drill, mail # dev - Re: Facing issues while implementing Math functions - 2014-03-01, 15:53
Solr & Elasticsearch trainings in New York & San Francisco [more info][hide]
 Search Hadoop and all its subprojects:

Switch to Threaded View
Copy link to this message
-
Re: Facing issues while implementing Math functions
Hi Anil,

I think custom functions within SQL are not supported yet. There is a
separate JIRA for that. You can test by creating a physical plan that uses
your function. An example of physical plan
is: <gitclone>/exec/java-exec/src/test/resources/functions/testSubstring.json.
In the "project" operator change expr from "substr" to your function. Once
you create a physical plan either you can submit it through
"./bin/submit_plan" or write a unittest that submits this plan. I prefer
the latter as you anyway need a unittest that tests your code in order to
submit the patch. Example unittest for testSubstring.json file is:
<gitclone>/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/TestSimpleFunctions.java,
look at testSubstring.

Thanks
Venki
On Sat, Mar 1, 2014 at 6:16 AM, AnilKumar B <[EMAIL PROTECTED]> wrote:
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB