francisoliverlee edited a comment on issue #5041: URL: https://github.com/apache/incubator-doris/issues/5041#issuecomment-741464158
checked, like https://github.com/apache/incubator-doris/issues/4716, the sql is as bellowing, happened always ```SQL SELECT DISTINCT worksheet_1917_.`type` FROM ( SELECT * FROM ( ( select to_date(schedule_date) schedule_date, levelsn1 level, 'allday' as type, allday_opened as opened, allday_booked as booked, allday_level_booking_rate / 100 as booking_rate, allday_available as available, available_class_24h as 24h_available_class from vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da ) union all ( select to_date(schedule_date) schedule_date, levelsn1 level, 'pt' as type, pt_opened as opened, pt_booked as booked, pt_level_booking_rate / 100 as booking_rate, pt_available as available, pt24h_available_class as 24h_available_class from vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da ) ) as temp ) as worksheet_1917_ limit 100 ``` ---------------------------------------------------------------- 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]
