Run simple SELECT for druid in metabase

Get Help
1

Hi everyone.

I am getting below error when i try to run a simple select statement like “Select * from…” for Druid in Metabase.

Unrecognized token ‘select’: was expecting (‘true’, ‘false’ or ‘null’) at [Source: java.io.StringReader@323004dc; line: 1, column: 7]

I am using the version Druid 0.16 and Metabase 0.31.2

Any help is greatly appreciated.

2

@renjithpaul That’s an almost two year old release of Metabase. Latest is 0.36.7
Metabase currently only supports native query (JSON) syntax for Druid.

3

Thanks.We are planing to upgrade it tomorrow.
Oh…so there is no way we can do the normal “select * …” thing on metabase in the latest version ?

4

@renjithpaul I don’t think so. Native query was the only way to query Druid until they introduced DruidSQL. I don’t have Druid setup, so you’ll have to test yourself.

5

Thanks @flamber

6

We use Druid too as a database and I can confirm that JSON SQL is the only way to write a native SQL for Druid.
What we do if we don’t know the JSON is use a DruidSQLconsole to write the SELECT * query and then view/export it as JSON. That result can be copy/pasted to Metabase.

1 Like
7

Thanks Danny