You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by Gaurav Kohli <ga...@gmail.com> on 2013/08/21 00:19:56 UTC
Sqlline how-to not working
Hey,
I am trying to follow the Sqlline How-to
https://cwiki.apache.org/confluence/display/DRILL/Demo+HowTo, but I am
facing issue in "select * from donuts; ".I am getting
"org.apache.drill.exec.exception.SetupException: Failure finding
StorageEngine constructor for config
org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig@6a6877c1"
exception
complete stacktrace:
org.apache.drill.exec.exception.OptimizerException: Failure while
attempting to retrieve storage engine.
at
org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:113)
at
org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:93)
at org.apache.drill.common.logical.data.Scan.accept(Scan.java:59)
at
org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitStore(BasicOptimizer.java:122)
at
org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitStore(BasicOptimizer.java:93)
at org.apache.drill.common.logical.data.Store.accept(Store.java:61)
at org.apache.drill.exec.opt.BasicOptimizer.optimize(BasicOptimizer.java:61)
at org.apache.drill.exec.work.foreman.Foreman.convert(Foreman.java:234)
at
org.apache.drill.exec.work.foreman.Foreman.parseAndRunLogicalPlan(Foreman.java:168)
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:151)
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:722)
Caused by: org.apache.drill.exec.exception.SetupException: Failure finding
StorageEngine constructor for config
org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig@6a6877c1
at
org.apache.drill.exec.store.StorageEngineRegistry.getEngine(StorageEngineRegistry.java:70)
at
org.apache.drill.exec.server.DrillbitContext.getStorageEngine(DrillbitContext.java:85)
at
org.apache.drill.exec.ops.QueryContext.getStorageEngine(QueryContext.java:53)
at
org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:110)
... 12 more
Exception in thread "WorkManager-1" java.util.NoSuchElementException
at java.util.ArrayList$Itr.next(ArrayList.java:794)
at
org.apache.drill.exec.work.foreman.Foreman.runPhysicalPlan(Foreman.java:187)
at
org.apache.drill.exec.work.foreman.Foreman.parseAndRunLogicalPlan(Foreman.java:170)
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:151)
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:722)
If I run "!tables" , I do see the list of tables and details around them,
but now able to figure out the reason for this exception. Any suggestion
how to run select query or is it something which is broken and needs to
fixed.
Regards,
Gaurav
--
"I'm a great believer in luck, and I find the harder I work, the more I
have of it."-Thomas Jefferson
Re: Sqlline how-to not working
Posted by Jacques Nadeau <ja...@apache.org>.
Can you try with the pre_exec_merge tag? I'm not sure anyone has run that
script with the latest codebase.
Thanks,
Jacques
On Tue, Aug 20, 2013 at 3:19 PM, Gaurav Kohli <ga...@gmail.com> wrote:
> Hey,
>
> I am trying to follow the Sqlline How-to
> https://cwiki.apache.org/confluence/display/DRILL/Demo+HowTo, but I am
> facing issue in "select * from donuts; ".I am getting
> "org.apache.drill.exec.exception.SetupException: Failure finding
> StorageEngine constructor for config
> org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig@6a6877c1"
> exception
>
>
> complete stacktrace:
>
> org.apache.drill.exec.exception.OptimizerException: Failure while
> attempting to retrieve storage engine.
> at
>
> org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:113)
> at
>
> org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:93)
> at org.apache.drill.common.logical.data.Scan.accept(Scan.java:59)
> at
>
> org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitStore(BasicOptimizer.java:122)
> at
>
> org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitStore(BasicOptimizer.java:93)
> at org.apache.drill.common.logical.data.Store.accept(Store.java:61)
> at
> org.apache.drill.exec.opt.BasicOptimizer.optimize(BasicOptimizer.java:61)
> at org.apache.drill.exec.work.foreman.Foreman.convert(Foreman.java:234)
> at
>
> org.apache.drill.exec.work.foreman.Foreman.parseAndRunLogicalPlan(Foreman.java:168)
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:151)
> 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:722)
> Caused by: org.apache.drill.exec.exception.SetupException: Failure finding
> StorageEngine constructor for config
> org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig@6a6877c1
> at
>
> org.apache.drill.exec.store.StorageEngineRegistry.getEngine(StorageEngineRegistry.java:70)
> at
>
> org.apache.drill.exec.server.DrillbitContext.getStorageEngine(DrillbitContext.java:85)
> at
>
> org.apache.drill.exec.ops.QueryContext.getStorageEngine(QueryContext.java:53)
> at
>
> org.apache.drill.exec.opt.BasicOptimizer$LogicalConverter.visitScan(BasicOptimizer.java:110)
> ... 12 more
> Exception in thread "WorkManager-1" java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:794)
> at
>
> org.apache.drill.exec.work.foreman.Foreman.runPhysicalPlan(Foreman.java:187)
> at
>
> org.apache.drill.exec.work.foreman.Foreman.parseAndRunLogicalPlan(Foreman.java:170)
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:151)
> 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:722)
>
> If I run "!tables" , I do see the list of tables and details around them,
> but now able to figure out the reason for this exception. Any suggestion
> how to run select query or is it something which is broken and needs to
> fixed.
>
> Regards,
> Gaurav
>
> --
>
> "I'm a great believer in luck, and I find the harder I work, the more I
> have of it."-Thomas Jefferson
>