When I try to sql query a druid datasource, this error is thrown:
select * from table
Unrecognized token ‘select’: was expecting (‘true’, ‘false’ or ‘null’) at [Source: (StringReader); line: 1, column: 7]
Is it even possible to sql query a druid datasource via metabase?
I can do that via Druid console though.
By the way I have a table containing a list of sales. Each sale has a category and a selling price. I need to get the avarage price of each category. In sql I’d do something like:
SELECT AVG(price) FROM table GROUP BY category
Any chance I can do this without sql on metabase?