[GitHub] [superset] cxplonka opened a new issue #16897: ApacheDrill: Column 'method__' is ambiguous

[GitBox <gi...@apache.org>]

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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org

[GitHub] [superset] raupat commented on issue #16897: ApacheDrill: Column 'method__' is ambiguous

[GitBox <gi...@apache.org>]

raupat commented on issue #16897:
URL: https://github.com/apache/superset/issues/16897#issuecomment-1083165561


   A workaround for this problem ist proposed in #17035 by not setting up a series limit. The Join Subquery will not be added and therefore the error will not occur.
   
   The missing "anon_1" reference in the join condition is however still a bug from my point of view, when using a series limit.
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org