You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2018/05/31 21:38:01 UTC
[jira] [Updated] (DRILL-5777) Oracle JDBC Error while access
synonym
[ https://issues.apache.org/jira/browse/DRILL-5777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-5777:
--------------------------------
Component/s: Storage - JDBC
> Oracle JDBC Error while access synonym
> --------------------------------------
>
> Key: DRILL-5777
> URL: https://issues.apache.org/jira/browse/DRILL-5777
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - Java, Storage - JDBC
> Affects Versions: 1.10.0
> Reporter: Sudhir Kumar
> Priority: Major
>
> Error while accessing individual column in oracle table accessing via synonym.
> Query : select <column_name> from <storage_plugin_name>.<oracle_schema_name>.<oracle_synonym_name>
> Error:
> 1
> 2017-09-08 10:13:46,451 [264d3035-1605-9f5b-084f-09a1b525ef75:foreman] INFO o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1, column 8 to line 1, column 17: Column <column_name> not found in any table (From line 1, column 8 to line 1, column 17: Column <column_name> not found in any table)
> org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From line 1, column 8 to line 1, column 17: Column <column_name> not found in any table
> SQL Query null
> [Error Id: 2b7c7c2d-664e-4c90-ba20-67509de90f09 ]
> at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:544) ~[drill-common-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:178) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:622) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:192) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:164) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:131) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:79) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:1050) [drill-java-exec-1.10.0.jar:1.10.0]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:281) [drill-java-exec-1.10.0.jar:1.10.0]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [na:1.8.0_92]
> Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 17: Column 'TABLE_NAME' not found in any table
> at sun.reflect.GeneratedConstructorAccessor67.newInstance(Unknown Source) ~[na:na]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_92]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_92]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:765) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:753) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3974) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.EmptyScope.findQualifyingTableName(EmptyScope.java:108) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.DelegatingScope.findQualifyingTableName(DelegatingScope.java:112) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.ListScope.findQualifyingTableName(ListScope.java:150) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:154) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4460) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4440) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:274) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.expand(SqlValidatorImpl.java:4148) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:420) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3480) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3023) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:883) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:869) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:843) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:557) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:169) [drill-java-exec-1.10.0.jar:1.10.0]
> ... 10 common frames omitted
> Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'TABLE_NAME' not found in any table
> at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source) ~[na:na]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_92]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_92]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:514) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19]
> ... 32 common frames omitted
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)