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

Switch to Plain View
Drill >> mail # dev >> sqlline broken?


+
Ted Dunning 2013-07-21, 21:32
+
Jacques Nadeau 2013-07-22, 00:18
Copy link to this message
-
Re: sqlline broken?
On Sun, Jul 21, 2013 at 5:18 PM, Jacques Nadeau <[EMAIL PROTECTED]> wrote:

> maybe try with a mvn clean install and let all tests run.
>
> I did a clean checkout and query worked.
>

Changing sqlline to restrict the class path seems to make it more robust to
these effects.

> Also, we haven't added syntactic sugar yet so you need to do:
>
> >>select _MAP['type'] from donuts
>
> instead of
>
> >>select type from donuts
>

Yeah... saw that already.
> Note that you can use subqueries to clean things up a bit.
>
> SELECT ppu, count(1) AS cnt FROM
>   (SELECT _MAP['ppu'] AS ppu, _MAP['type'] AS type FROM donuts)y
> GROUP BY ppu
> ORDER BY ppu DESC;
>

Good point.
+
Jacques Nadeau 2013-07-22, 01:13
+
Ted Dunning 2013-07-22, 02:17
+
Jacques Nadeau 2013-07-22, 02:34
+
Ted Dunning 2013-07-22, 01:52