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.
