Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> Re: [jira] [Commented] (DRILL-159) 1.sql


Copy link to this message
-
Re: [jira] [Commented] (DRILL-159) 1.sql
instead that 1.sql, if i use 'select * from lineitem', it works.
console output:
10:14:41.459 [main] DEBUG o.a.drill.optiq.EnumerableDrillRel - implementing enumerable

{"head":{"type":"APACHE_DRILL_LOGICAL","version":"1","generator":{"type":"manual","info":"na"}},"storage":{"donuts-json":{"type":"classpath"},"queue":{"type":"queue"}},"query":[{"op":"sequence","do":[{"op":"scan","memo":"initial_scan","ref":"_MAP","storageengine":"donuts-json","selection":{"path":"/lineitem.tbl.1.json","type":"JSON"}},{"op":"project","projections":[{"expr":"_MAP","ref":"output._MAP"}]},{"op":"store","storageengine":"queue","memo":"output sink","target":{"number":0}}]}]}
10:14:42.501 [main] DEBUG o.a.drill.common.config.DrillConfig - Loading configs at the following URLs [file:/home/svaddi/OpenSource/incubator-drill/sandbox/prototype/common/target/classes/drill-module.conf, file:/home/svaddi/OpenSource/incubator-drill/sandbox/prototype/exec/ref/target/classes/drill-module.conf]
10:14:43.318 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase - Adding Logical Operator sub types: [class org.apache.drill.common.logical.data.Limit, class org.apache.drill.common.logical.data.Project, class org.apache.drill.common.logical.data.CollapsingAggregate, class org.apache.drill.common.logical.data.WindowFrame, class org.apache.drill.common.logical.data.Transform, class org.apache.drill.common.logical.data.Union, class org.apache.drill.common.logical.data.Filter, class org.apache.drill.common.logical.data.Join, class org.apache.drill.common.logical.data.Sequence, class org.apache.drill.common.logical.data.Flatten, class org.apache.drill.common.logical.data.Store, class org.apache.drill.common.logical.data.RunningAggregate, class org.apache.drill.common.logical.data.Segment, class org.apache.drill.common.logical.data.Scan, class org.apache.drill.common.logical.data.Order, class org.apache.drill.common.logical.data.Constant]
10:14:43.321 [main] DEBUG o.a.d.c.l.StorageEngineConfigBase - Adding Storage Engine Configs including [class org.apache.drill.exec.ref.rse.ConsoleRSE$ConsoleRSEConfig, class org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig, class org.apache.drill.exec.ref.rse.FileSystemRSE$FileSystemRSEConfig, class org.apache.drill.exec.ref.rse.QueueRSE$QueueRSEConfig]
10:14:43.403 [main] DEBUG org.apache.drill.common.JSONOptions - Creating Deserializer.
10:14:43.411 [main] DEBUG org.apache.drill.common.JSONOptions - Creating Deserializer.
10:14:43.545 [main] DEBUG org.apache.drill.common.JSONOptions - Creating Deserializer.
10:14:43.551 [main] DEBUG org.apache.drill.common.JSONOptions - Creating Deserializer.
10:14:43.660 [main] DEBUG o.a.drill.common.config.DrillConfig - Loading configs at the following URLs [file:/home/svaddi/OpenSource/incubator-drill/sandbox/prototype/common/target/classes/drill-module.conf, file:/home/svaddi/OpenSource/incubator-drill/sandbox/prototype/exec/ref/target/classes/drill-module.conf]
10:14:43.669 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase - Adding Logical Operator sub types: [class org.apache.drill.common.logical.data.Limit, class org.apache.drill.common.logical.data.Project, class org.apache.drill.common.logical.data.CollapsingAggregate, class org.apache.drill.common.logical.data.WindowFrame, class org.apache.drill.common.logical.data.Transform, class org.apache.drill.common.logical.data.Union, class org.apache.drill.common.logical.data.Filter, class org.apache.drill.common.logical.data.Join, class org.apache.drill.common.logical.data.Sequence, class org.apache.drill.common.logical.data.Flatten, class org.apache.drill.common.logical.data.Store, class org.apache.drill.common.logical.data.RunningAggregate, class org.apache.drill.common.logical.data.Segment, class org.apache.drill.common.logical.data.Scan, class org.apache.drill.common.logical.data.Order, class org.apache.drill.common.logical.data.Constant]
10:14:43.671 [main] DEBUG o.a.d.c.l.StorageEngineConfigBase - Adding Storage Engine Configs including [class org.apache.drill.exec.ref.rse.ConsoleRSE$ConsoleRSEConfig, class org.apache.drill.exec.ref.rse.ClasspathRSE$ClasspathRSEConfig, class org.apache.drill.exec.ref.rse.FileSystemRSE$FileSystemRSEConfig, class org.apache.drill.exec.ref.rse.QueueRSE$QueueRSEConfig]
10:14:43.686 [main] DEBUG o.a.drill.exec.ref.rse.RSERegistry - Loading storage engines [class org.apache.drill.exec.ref.rse.ClasspathRSE, class org.apache.drill.exec.ref.rse.ConsoleRSE, class org.apache.drill.exec.ref.rse.QueueRSE, class org.apache.drill.exec.ref.rse.FileSystemRSE]
10:14:43.727 [main] DEBUG o.apache.drill.exec.ref.ROPConverter - There is no convertSpecific method for type class org.apache.drill.common.logical.data.Project.  Looking for a generic option...
10:14:43.789 [pool-1-thread-1] DEBUG o.a.drill.exec.ref.BasicStatusHandle - Progressed 0 bytes, 1 records.
10:14:43.791 [pool-1-thread-1] DEBUG o.a.drill.exec.ref.rops.BaseSinkROP - Breaking because no more records were found.
===========RunOutcome [outcome=SUCCESS, bytes=0, records=1, exception=null]
{comment=egular courts above the, committedDate=1996-02-12, discount=0.04, extendedPrice=21168.23, lineNumber=1, lineStatus=O, orderKey=1, partKey=155190, quantity=17, receivedDate=1996-03-22, returnFlag=N, shippingDate=1996-03-13, shippingInstructions=DELIVER IN PERSON, shippingMode=TRUCK, supplierKey=7706, tax=0.02}

 
Thanking you.
With Regards
Sree
________________________________
 From: Sree Vaddi (JIRA) <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2013 8:49 AM
Subject: [jira] [Commented] (DRILL-159) 1.sql
 
    [ https://issues.apache.org/jira/browse/DRILL-159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13723977#comment-13723977 ]

Sree Vaddi commented on DRILL-159:

org.eigenbase.sql.validate.ListScope.findQualifyingTableName() method.

loop at #112, returning count as 0.

switch at #119,
org.eigenbase.sql.validate.EmptyScope.findQualifyingTableNa