how to write a dsql when it need arithmetic in ORDER BY Component

srikalyc / Sql4D

Sql interface to druid.

Apache License 2.0

77 stars 41 forks source link

how to write a dsql when it need arithmetic in ORDER BY Component #88

Open guanboyu opened 9 years ago

guanboyu commented 9 years ago

Ex: SELECT page,country, LONG_SUM(count) AS edit_count,COUNT(*) AS call FROM wikipedia WHERE interval BETWEEN 2010-01-01T00:00:00.000Z AND 2020-01-01T00:00:00.000Z AND country='United States' BREAK BY 'minute' GROUP BY country ORDER BY edit_count/call DESC LIMIT 10 THEN edit_count/call;"

BUT IT DIDN'T Generate JSON For Druid Correctly