anilvpatel21 commented on issue #13312:
URL: https://github.com/apache/superset/issues/13312#issuecomment-792602134
@mikekytyzov In the above case, Sub Query is not generated when applying
series limit in clickhouse db. It might be because Window function is not
supported in the clickhouse.(Guess)
As a work around, you may apply actual query & create datasource with `Limit
By` functionality. And then apply dummy query on the top of the datasource
using visualisation (viz. of line chart).
Example: `SELECT colnames FROM tbl (clickhouse db) WHERE time_received >=
toDateTime('{{ from_dttm }}')
AND time_received < toDateTime('{{ to_dttm }}') LIMIT 5 BY time_received`
-- Here time_recieved is the time column. Using this as a datasource, you will
achieve it.
@junlincc Its not working in v1.0.1 also.
----------------------------------------------------------------
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]
