ypankovych commented on issue #14043:
URL: https://github.com/apache/superset/issues/14043#issuecomment-817573828


   Even more, superset does generate correct query when I do:
   
![image](https://user-images.githubusercontent.com/31005942/114359287-766c6f80-9b7c-11eb-82f5-bea9eff4c693.png)Here's
 generated query:
   ``sql
   SELECT virtual_table.internal_0 AS "virtual_table.internal_0"
   FROM
     (select *
      from public.invoice_invoice i
      left join public.olap_table_41_invoice_attrs ia on ia.id = i.id) AS 
virtual_table
   WHERE invoice_date >= TO_DATE('2021-04-05', 'YYYY-MM-DD')
     AND invoice_date < TO_DATE('2021-04-12', 'YYYY-MM-DD')
   LIMIT 10000;
   ```
   It does work in SQL lab but throws an error on filtering. 


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

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to