Support Questions

Find answers, ask questions, and share your expertise

superset works with hive ?

avatar
Expert Contributor

Hello,

I am fetching real time data using spark streaming and storing data into the druid. I will create Hive external table which points to hive data store. I want to perform data analysis using Hive LLAP. Is it possible to visualize hive result using superset ?

Thank You.

1 ACCEPTED SOLUTION

avatar
@heta desai

When a Hive external table is created, then the Hive table would be pointing to existing Druid data source and Superset can to viewed from Druid datasource and queried upon.

78611-screen-shot-2018-07-02-at-125230-pm.png

78612-screen-shot-2018-07-02-at-125257-pm.png

78613-screen-shot-2018-07-02-at-125406-pm.png

View solution in original post

3 REPLIES 3

avatar
@heta desai

When a Hive external table is created, then the Hive table would be pointing to existing Druid data source and Superset can to viewed from Druid datasource and queried upon.

78611-screen-shot-2018-07-02-at-125230-pm.png

78612-screen-shot-2018-07-02-at-125257-pm.png

78613-screen-shot-2018-07-02-at-125406-pm.png

avatar
Expert Contributor

@Sindhu Thank You.

avatar
Contributor

@Sindhu

hi sindhu,

what is the connection string for http mode of hive with kerberized cluster ,im unable to connect the sqlalchemy uri.for binary its working fine

please help me out.

i am getting below error to connect the http mode of hive (knox).

ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nTSocket read 0 bytes"}

thanks in advance