You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2017/01/25 20:59:27 UTC
[jira] [Closed] (DRILL-5222) C++ client unable to parse queries
with table function
[ https://issues.apache.org/jira/browse/DRILL-5222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-5222.
--------------------------
Resolution: Not A Bug
> C++ client unable to parse queries with table function
> ------------------------------------------------------
>
> Key: DRILL-5222
> URL: https://issues.apache.org/jira/browse/DRILL-5222
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - C++
> Affects Versions: 1.10.0
> Reporter: Krystal
>
> The following query failed from was odbc and custom C++ client app:
> SQL>select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', lineDelimiter=>'\r\n'))
> 1: SQLPrepare = [MapR][Drill] (1040) Drill failed to execute the query: select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', lineDelimiter=>'\r\n'))
> [30027]Query execution error. Details:[
> SYSTEM ERROR: SqlValidatorException: No match found for function signature table_function/cr_lf.csv(type => <CHARACTER>, lineDelimiter => <CHARACTER>)
> Here is the stack trace:
> {code}
> SYSTEM ERROR: SqlValidatorException: No match found for function signature table_function/cr_lf.csv(type => , lineDelimiter => )
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: No match found for function signature table_function/cr_lf.csv(type => , lineDelimiter => )
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1145
> java.util.concurrent.ThreadPoolExecutor$Worker.run():615
> java.lang.Thread.run():745
> Caused By (org.apache.drill.exec.exception.FunctionNotFoundException) No match found for function signature table_function/cr_lf.csv(type => , lineDelimiter => )
> org.apache.drill.exec.planner.sql.SqlConverter.validate():170
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():122
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():96
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1017
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1145
> java.util.concurrent.ThreadPoolExecutor$Worker.run():615
> java.lang.Thread.run():745
> Caused By (org.apache.calcite.runtime.CalciteContextException) From line 1, column 45 to line 1, column 107: No match found for function signature table_function/cr_lf.csv(type => , lineDelimiter => )
> sun.reflect.NativeConstructorAccessorImpl.newInstance0():-2
> sun.reflect.NativeConstructorAccessorImpl.newInstance():57
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
> java.lang.reflect.Constructor.newInstance():526
> org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405
> org.apache.calcite.sql.SqlUtil.newContextException():765
> org.apache.calcite.sql.SqlUtil.newContextException():753
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3974
> org.apache.calcite.sql.validate.SqlValidatorImpl.handleUnresolvedFunction():1583
> org.apache.calcite.sql.SqlFunction.deriveType():278
> org.apache.calcite.sql.SqlFunction.deriveType():222
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4337
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4324
> org.apache.calcite.sql.SqlCall.accept():130
> org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl():1501
> org.apache.calcite.sql.validate.ProcedureNamespace.validateImpl():53
> org.apache.calcite.sql.validate.AbstractNamespace.validate():86
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
> org.apache.calcite.sql.validate.AbstractNamespace.validate():86
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
> org.apache.calcite.sql.validate.AbstractNamespace.validate():86
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869
> org.apache.calcite.sql.SqlSelect.validate():210
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():843
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate():557
> org.apache.drill.exec.planner.sql.SqlConverter.validate():164
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():122
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():96
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1017
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1145
> java.util.concurrent.ThreadPoolExecutor$Worker.run():615
> java.lang.Thread.run():745
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)