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
Sree V 2013-07-30, 19:20
Sure, Ted.  sqls will be in their own files read into the tests/programs, at final checkin.

"select * from lineitem" works, as i said before.

"select quantity from lineitem" fails with this same error. (one column select)
"select orderKey, tax from lineitem" fails with the same error. (two or more columns select)
"select li.lineStatus from lineitem li" fails with the same error. (table name reference)
"select lineitem.partKey from lineitem" fails with the same error. (table name itself)
V
________________________________
 From: Ted Dunning <[EMAIL PROTECTED]>
To: drill <[EMAIL PROTECTED]>; Sree V <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2013 11:24 AM
Subject: Re: [jira] [Commented] (DRILL-159) 1.sql
 

Does it work if you put table qualifiers on all variables?

Also, I recommend that you put the queries in test resource files rather
than into strings in your code. That makes it much easier to edit and read
the queries.

It also makes it much easier to parametrize the tests.

On Tue, Jul 30, 2013 at 10:18 AM, Sree V <[EMAIL PROTECTED]> wrote:

> 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,