You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/07/28 12:50:03 UTC

[GitHub] [superset] StephLec76 opened a new issue #15924: Unexpected DATETIME column happened to query when running the chart

StephLec76 opened a new issue #15924:
URL: https://github.com/apache/superset/issues/15924


   I'm using a dataset with many DATETIME columns (3 to be precise). Data coming from ElasticSearch.
   
   I'm currently working with a bar chart (the issue is reproducable with other charts as well). I'm setting the "Time Column" element I want to filter my data on.
   
   I expect that when running (press "Run" button) the chart, only the column I've picked (for the time section) is used to "compute" the query. 
   
   But unfortunately the computed query is happened with one unexpected DATETIME column.
   
   Therefore the resulting chart is wrong according to criterias.
   
   Here is the "TIME COLUMN" item selected
   ![time column selected](https://user-images.githubusercontent.com/88092697/127323711-b3b5d51c-06a9-40ee-8a2a-05e65739585d.PNG)
   
   Here is the query (retrieved by clicking on "View query" in the burger menu on top of the chart) that is performed against my dataset:
   ![created date passed](https://user-images.githubusercontent.com/88092697/127324029-197a5032-a495-449f-9447-f09e742af439.PNG)
   
   So the steps are:
   1. get a dataset which contains many DATETIME columns
   2. create a bar chart
   3. select one column for the Time section
   4. Run the chart
   5. Check the computed query
   
   
   ### Environment
   
   - superset version: 1.2.0
   - python version: 2.7.5
   
   


-- 
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] villebro commented on issue #15924: Unexpected DATETIME column happened to query when running the chart

Posted by GitBox <gi...@apache.org>.
villebro commented on issue #15924:
URL: https://github.com/apache/superset/issues/15924#issuecomment-888295992


   This sounds highly irregular! @StephLec76 are you able to reproduce this on master?


-- 
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] StephLec76 commented on issue #15924: Unexpected DATETIME column happened to query when running the chart

Posted by GitBox <gi...@apache.org>.
StephLec76 commented on issue #15924:
URL: https://github.com/apache/superset/issues/15924#issuecomment-914076723


   Hi,
   
   I took a look to source code to try to figure out how to fix the issue.
   It looks to complex in regards of my skills.
   
   Is there any chance, someone could take a look and either fix it or provide further details about how the issue occur so that people could work it around?
   
   Thanks in advance to anyone who would provide a feedback on this ticket


-- 
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] junlincc commented on issue #15924: Unexpected DATETIME column happened to query when running the chart

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #15924:
URL: https://github.com/apache/superset/issues/15924#issuecomment-888644619


   @StephLec76 thanks for reporting, if you have the capacity to work on it, we will be happy to review the PR, otherwise we will look into it in 3-4 weeks. 


-- 
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] StephLec76 commented on issue #15924: Unexpected DATETIME column happened to query when running the chart

Posted by GitBox <gi...@apache.org>.
StephLec76 commented on issue #15924:
URL: https://github.com/apache/superset/issues/15924#issuecomment-888321509


   Yes the issue is still reproducable on master.


-- 
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] StephLec76 commented on issue #15924: Unexpected DATETIME column happened to query when running the chart

Posted by GitBox <gi...@apache.org>.
StephLec76 commented on issue #15924:
URL: https://github.com/apache/superset/issues/15924#issuecomment-888831668


   I'll do my best in term of skills and time in regards to this 3-4 weeks time window


-- 
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