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 >> 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
> ORDER BY ppu DESC;
>

Good point.
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