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

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

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

Good point.