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 <[email protected]> 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 >
