drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yash Sharma <yash...@gmail.com>
Subject Questions about Drill Substr function
Date Sat, 03 May 2014 19:23:57 GMT
Team, I am focusing on drill funcs specially Substr function.

I am targeting to fix these issues for this task:
1. https://issues.apache.org/jira/browse/DRILL-543
2. https://issues.apache.org/jira/browse/DRILL-573
3. https://issues.apache.org/jira/browse/DRILL-542
4. Implementing substr(<parameter>, start) func

So I have few questions for the same:

1.I get this exception sometimes:
EigenbaseContextException:[ From line 1, column 8 to line 1, column 22 ] <
SqlValidatorException:[ No match found for function signature substr(<ANY>,

I guess its because Optiq does not consider substr as a valid
token/function. How can we add the new names to optiq's permitted keywords.
How can I go ahead fixing this.

2. Have also stumbled across similar error:
ERROR o.a.h.h.s.typeinfo.TypeInfoFactory - varchar type used with no type
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query
message: "Failure while running fragment. < RuntimeException:[ varchar type
used with no type params ]"

This happens there is no Drill Func match found - and there is a search for
the func in Hive. The error pops out of hive.
Was thinking of placing an exception handling and having a more proper
message that would let the user know that the func is not available rather
that Hive's internal exception messages.


Will keep posting my findings & doubts.


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message