[jira] [Commented] (DRILL-542) Drill fails to execute SUBSTRING function

["Yash Sharma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13988779#comment-13988779 ] 

Yash Sharma commented on DRILL-542:
-----------------------------------

Similar error:

0: jdbc:drill:zk=local> SELECT employee_id, first_name, substring(first_name, 3) FROM cp.`employee.json` where employee_id> 5 limit 10; 
23:53:18.451 [WorkManager-4] ERROR o.a.h.h.s.typeinfo.TypeInfoFactory - varchar type used with no type params
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "5bc349bf-b0ae-4dd5-bfe3-8b87334eee8d"
endpoint {
  address: "L-yash-tech"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < RuntimeException:[ varchar type used with no type params ]"
]
Error: exception while executing query (state=,code=0)


> Drill fails to execute SUBSTRING function 
> ------------------------------------------
>
>                 Key: DRILL-542
>                 URL: https://issues.apache.org/jira/browse/DRILL-542
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.0.0
>            Reporter: Krystal
>
> Ran the following query:
> select substring(name, 5) from dfs.`voter` where age < 20;
> The query just hangs.  The following error messages were observed in the drillbit.out:
> Exception in thread "WorkManager-5" java.lang.AssertionError: Was not expecting value 'ANY' for enumeration 'org.eigenbase.sql.type.SqlTypeName' in this context
> 	at org.eigenbase.util.Util.unexpected(Util.java:1837)
> 	at org.eigenbase.sql.type.SqlTypeTransforms$4.toVar(SqlTypeTransforms.java:131)
> 	at org.eigenbase.sql.type.SqlTypeTransforms$4.transformType(SqlTypeTransforms.java:104)
> 	at org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:62)
> 	at org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:453)
> 	at org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:420)
> 	at org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:291)
> 	at org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:207)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4033)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4020)
> 	at org.eigenbase.sql.SqlCall.accept(SqlCall.java:166)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1441)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1424)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:415)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3130)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2908)
> 	at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> 	at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:742)
> 	at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:135)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:707)
> 	at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:423)
> 	at net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:153)
> 	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:73)
> 	at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:350)
> 	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:175)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:744)



--
This message was sent by Atlassian JIRA
(v6.2#6252)