Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

superset sql lab preview table returns state fail error 22

Highlighted

superset sql lab preview table returns state fail error 22

New Contributor

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

Re: superset sql lab preview table returns state fail error 22

New Contributor

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?

Re: superset sql lab preview table returns state fail error 22

New Contributor

hi christos,

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

regards,

vamshi.