no7dw commented on issue #4839: URL: https://github.com/apache/doris/issues/4839#issuecomment-1185311877
work around : add ` select * from between crate view xxx and xx union all yy` example ``` create view gaia_data__gaia.bsc_transactio_view_wade_2 as select * from( SELECT hash, block_timestamp , from_address , to_address , value FROM gaia_data__gaia.bsc_transactions where block_timestamp > '2022-03-30' order by block_timestamp desc limit 10, 50 union all SELECT hash, block_timestamp , from_address , to_address , value FROM gaia_data__gaia.bsc_transactions where block_timestamp > '2022-03-30' order by block_timestamp desc limit 10 ) bsc_u ``` -- 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]
