apache
Wrong request to the DB
Hello! I installed version 3.0.1 of Superset to display charts! I have a MongoDB database so that the superset can work with it, I installed Apache Drill 1.21.1
Everything works, but there is a problem with the Drill to Details functionality. When I click the "Drill To Detail" button I get this error: "Unexpected error: Error: The number that was passed in is not a number." If I look at Apache Drill's logs, a request comes:
SELECT COUNT() AS COUNT(*)
FROM mongo.events_base.events
LIMIT 50000
and indeed, if I check this request in the SQL Lab tab, it returns null
But! if I change to SELECT COUNT() AS COUNT it works well, it retunrs 919176
If I clicl the "View as table" it works well. And the request normal :
SELECT vendor AS vendor,
COUNT(*) AS count
FROM mongo.events_base.events
GROUP BY vendor
LIMIT 100
I would be very grateful for any help in this matter, we have not been able to get around this for 2-3 weeks
I'm tempted to close this as stale, but curious to hear if you're still facing this, or found an acceptable workaround. I'm also curious if @cgivre sees a way forward here.
@NomadBYlife Do you have to alias your columns as COUNT(*)? It seems like something post-Drill is not liking that alias and therefore the obvious workaround would be to use a different alias.
