drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5222) C++ client unable to parse queries with table function
Date Wed, 25 Jan 2017 19:59:26 GMT

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

Krystal commented on DRILL-5222:
--------------------------------

Sorry, it's my bad.  I ran a query against a view created with the table function using relative
path (without the schema name) instead of the full path.  The ODBC session was not in the
schema but my sqlline/UI session was; thus resulting in the error. Need a better error message
in this case against the table function; will open a new bug for this. 

> 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)

Mime
View raw message