Mainer-g00t opened a new issue, #28798: URL: https://github.com/apache/superset/issues/28798
### Bug description When Pinot is used as a backed database, only the first metric is considered in Virtual Datasets ### How to reproduce the bug 1. Create a dummy dataset: SELECT 'a' dimension_1, 1 as metric_1, 2 as metric_2 2. Create a chart using that dataset (pivot table for example) with dimension_1 as dimension and add the 2 metrics <img width="319" alt="Screenshot 2024-06-01 at 07 50 47" src="https://github.com/apache/superset/assets/59738113/58fed8a6-250c-4183-b6be-6b85e7668580";> 3. Only the first metric is actually created <img width="709" alt="Screenshot 2024-06-01 at 07 50 57" src="https://github.com/apache/superset/assets/59738113/81da47cc-a1e5-475c-ad8d-e75e0f6c45b8";> 4. Query is re-written as: <img width="357" alt="Screenshot 2024-06-01 at 07 56 00" src="https://github.com/apache/superset/assets/59738113/eb351cea-b926-4ee7-9832-17065b740a6f";> ### Screenshots/recordings _No response_ ### Superset version 4.0.1 ### Python version 3.9 ### Node version 16 ### Browser Safari ### Additional context I tried the same dataset with postgres and presto backends and work as expected ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [X] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
