Support Questions
Find answers, ask questions, and share your expertise

superset works with hive ?

Solved Go to solution

superset works with hive ?

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

Accepted Solutions

Re: superset works with hive ?

@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

Re: superset works with hive ?

@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

Re: superset works with hive ?

Expert Contributor

@Sindhu Thank You.

Re: superset works with hive ?

@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