Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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
Frequent Visitor

@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