Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB