superset sql lab preview table returns state fail error 22

[#1]

Hello HC,

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

[#2]

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?

[#3]

hi christos,

do u find any thing about this question ,please post the solution.

regards,

vamshi.