Hi team, I’m using Superset query a pinot table, b...
# troubleshootingt
troywinter
03/11/2021, 3:57 AMHi team, I’m using Superset query a pinot table, but the explore button are disabled for pinot table, other data sources works fine. Anyone know the reason?
x
Xiang Fu
03/11/2021, 8:10 AM
Hmm, does run work?
Xiang Fu
03/11/2021, 8:11 AM
Do you know what’s the call triggered for other data sources when click on the explorer
t
troywinter
03/11/2021, 8:12 AMRun works, and it can return the right result.
troywinter
03/11/2021, 8:15 AMI don’t know, maybe it’s because I’m using a pre-1.0 version of superset? What version of Superset officially support pinot?
x
Xiang Fu
03/11/2021, 10:08 PM
it’s from long back 1.0 should have the support
Xiang Fu
03/11/2021, 10:08 PM
as long as you installed the pinotdb lib
Xiang Fu
03/13/2021, 5:23 AM
I figured that the
EXPLOREXiang Fu
03/13/2021, 5:23 AM
So the suggestion is to use presto-pinot connector and here you can explore a presto table
Xiang Fu
03/13/2021, 5:24 AM
which underlying querying pinot
Xiang Fu
03/13/2021, 5:24 AM
E.g.
Xiang Fu
03/13/2021, 5:25 AM
Then goes to:
Xiang Fu
03/13/2021, 5:26 AM
here is the generated query for the
EXPLOREt
troywinter
03/13/2021, 5:36 AMthanks, I will try using presto in superset.