superset works with hive ?

[#1]

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.

[#2 · Accepted solution]

@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

[#3]

@Sindhu Thank You.

[#4]

@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