Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

superset sql lab preview table returns state fail error 22

Explorer

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


download.png
2 REPLIES 2

Explorer

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?

hi christos,

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

regards,

vamshi.