I'm not quite sure what's happening here. The query should work, but maybe it is returning so many rows that Druid is crashing. (SQL doesn't eliminate duplicates, so it's returning one row per page event, and there are many events per page.) Did you consider using "distinct"?
select distinct "page" from "wikiticker"; That actually means exactly the same as select "page" from "wikiticker" group by "page"; but is more concise to type. Julian On Mon, Mar 13, 2017 at 8:28 PM, Guodong Li <[email protected]> wrote: > Hi team, > > I’m a freshman in Calcite and we are looking for a stable framework to query > data from druid. I found I cannot get result by using simple query like > SELECT “col” FROM “table”, I have to add “GROUP BY” on. > > e.g. I’m querying on a sample data named ‘wikiticker’ which supllied by Druid. > > When I execute query - select "page" from "wikiticker" group by "page"; > > I can get 30000+ rows, but no result by using - > > 0: jdbc:calcite:schemaFactory=org.apache.calc> select "page" from > "wikiticker"; > +------+ > | page | > +------+ > +------+ > > > I’m not sure every statement has a GROUP BY in query, so how to fix that? > > Thanks, > Guodong > > >
