cxplonka opened a new issue #16897:
URL: https://github.com/apache/superset/issues/16897
Hello Superset-Team,
when i use time series chart to query apache drill then this statement(see
bottom) is generated, but apache drill give me an error "VALIDATION ERROR: From
line 17, column 37 to line 17, column 44: Column 'method__' is ambiguous".
Everything works fine when we use "anon_1.method__". Is there a possiblity to
fix this problem?
thanks and best greets
christian
```sql
SELECT NEARESTDATE(`eventDateTime`, 'DAY') AS __timestamp,
`method` AS `method`,
sum(duration) AS `SUM(duration)`
FROM
(select *
from dfs.`/data/server.log`
where duration > 0) AS virtual_table
JOIN
(SELECT `method` AS method__,
sum(duration) AS mme_inner__
FROM
(select *
from dfs.`/data/server.log`
where duration > 0) AS virtual_table
GROUP BY `method`
ORDER BY mme_inner__ DESC
LIMIT 5) AS anon_1 ON `method` = method__
GROUP BY `method`,
NEARESTDATE(`eventDateTime`, 'DAY')
LIMIT 10000
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
