I have successfully created an external hive table from a druid datasource.
CREATE EXTERNAL TABLE druid_table_cstefan_test STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" = "wikipedia");
I am able to run queries from the hive-interactive shell. However, if I run queries
( or preview table ) from superset SQL lab it returns fail 22 ( see attached photo ).
Does anyone know anything about this error? And if yes, how can I fix this?
Unfortunately, I can't find something relative in the web.
Thanks in advance, every help is appreciated
hive-interactive = superset database name (backend: hive)
druid_table_cstefan_test = table name
As I see, if I try the below query, superset returns the results successfully
SELECT `added`, `channel`, `cityname`, `comment`, `countryisocode`, `countryname`, `deleted`, `delta`, `isanonymous`, `isminor`, `isnew`, `isrobot`, `isunpatrolled`, `metrocode`, `namespace`, `page`, `regionisocode`, `regionname`, `user` FROM default.druid_table_cstefan_test LIMIT 100
So I guess that the issue is due to the column __time , this column is auto-created from druid when I create the "druid datasource".
__time data_type is "timestamp with local time zone"
Is there any workaround?