[
https://issues.apache.org/jira/browse/DRILL-399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921688#comment-13921688
]
Ramana Inukonda Nagaraj commented on DRILL-399:
-----------------------------------------------
Stack trace in drillbit.log
16:12:09.299 [WorkManager Event Thread] DEBUG
o.apache.drill.exec.work.WorkManager - Starting pending task
org.apache.drill.exec.work.foreman.Foreman@4167292
16:12:09.305 [WorkManager-3] DEBUG o.a.d.e.s.dfs.WorkspaceSchemaFactory -
Failed to create DrillTable with root / and name /region.parquet
java.io.IOException: Failure trying to load file /region.parquet
at
org.apache.drill.exec.store.ClassPathFileSystem.getFileStatus(ClassPathFileSystem.java:83)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.dfs.shim.fallback.FallbackFileSystem.getFileStatus(FallbackFileSystem.java:79)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.dfs.FileSelection.create(FileSelection.java:118)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory.create(WorkspaceSchemaFactory.java:71)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory.create(WorkspaceSchemaFactory.java:35)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.ExpandingConcurrentMap.getNewEntry(ExpandingConcurrentMap.java:83)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.ExpandingConcurrentMap.containsKey(ExpandingConcurrentMap.java:64)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
org.apache.drill.exec.planner.sql.ExpandingConcurrentMap$DelegatingKeySet.contains(ExpandingConcurrentMap.java:160)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at com.google.common.collect.Maps$AsMapView.containsKey(Maps.java:788)
[guava-14.0.1.jar:na]
at net.hydromatic.optiq.util.CompositeMap.get(CompositeMap.java:91)
[optiq-core-0.4.18.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTableFrom(OptiqCatalogReader.java:89)
[optiq-core-0.4.18.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:70)
[optiq-core-0.4.18.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:43)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:67)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:742)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2672)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2899)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:742)
[optiq-core-0.4.18.jar:na]
at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:135)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:707)
[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:423)
[optiq-core-0.4.18.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:153)
[optiq-core-0.4.18.jar:na]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:76)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:350)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:175)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
Caused by: java.lang.IllegalArgumentException: resource region.parquet not
found.
at
com.google.common.base.Preconditions.checkArgument(Preconditions.java:119)
~[guava-14.0.1.jar:na]
at com.google.common.io.Resources.getResource(Resources.java:191)
~[guava-14.0.1.jar:na]
at
org.apache.drill.exec.store.ClassPathFileSystem.getFileStatus(ClassPathFileSystem.java:77)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
... 32 common frames omitted
16:12:09.312 [WorkManager-3] ERROR o.a.drill.exec.work.foreman.Foreman - Error
fb08254d-df19-4991-8c0c-f434b801ef38: Failure while parsing sql.
org.eigenbase.sql.validate.SqlValidatorException: Table '/region.parquet' not
found
at
org.eigenbase.resource.EigenbaseResource$_Def9.ex(EigenbaseResource.java:1378)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:69)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:742)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2672)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2899)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:742)
~[optiq-core-0.4.18.jar:na]
at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:135)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:707)
~[optiq-core-0.4.18.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:423)
~[optiq-core-0.4.18.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:153)
~[optiq-core-0.4.18.jar:na]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:76)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:350)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:175)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> Specifying schema=dfs and not specifying schema at query does not work
> ----------------------------------------------------------------------
>
> Key: DRILL-399
> URL: https://issues.apache.org/jira/browse/DRILL-399
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ramana Inukonda Nagaraj
>
> Repro steps:
> Start sqlline
> bin/sqlline -u jdbc:drill:schema=dfs -n admin -p admin
> 0: jdbc:drill:schema=dfs> select * from `/region.parquet`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "76bae1a1-3b86-4dc8-9cd4-6e42cb7fe900"
> endpoint {
> address: "perfnode166.perf.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line
> 1, column 31 ] < EigenbaseContextException:[ From line 1, column 15 to line
> 1, column 31 ] < SqlValidatorException:[ Table \'/region.parquet\' not found
> ]"
> ]
> Error: exception while executing query (state=,code=0)
> This works though.
> 0: jdbc:drill:schema=dfs> select * from dfs.`region.parquet`;
> Also, specifying cp as schema works.
> [root@perfnode166 drill]# bin/sqlline -u jdbc:drill:schema=cp -n admin -p
> admin
> 0: jdbc:drill:schema=cp> select * from `employee.json`;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
