Closed
Description
When I do the insert statement，If the amount of data inserted is 0 rows，show load can not work well for this operation。
select * from detail;
+---------------------+------------+---------+-------------+---------+
| event_time | event_type | user_id | device_code | channel |
+---------------------+------------+---------+-------------+---------+
| 2021-01-01 00:00:00 | 1 | 2 | 3 | 4 |
+---------------------+------------+---------+-------------+---------+
insert into detail with label `test-0` select * from detail where user_id < 2;
Query OK, 0 rows affected (0.02 sec)
show load where label ='test-0';
Empty set (0.00 sec)
insert into detail with label `test-1` select * from detail where user_id = 2;
Query OK, 2 rows affected (0.04 sec)
{'label':'test-1', 'status':'VISIBLE', 'txnId':'1006'}
show load where label ='test-1';
| 30029 | test-1 | FINISHED | ETL:100%; LOAD:100% | INSERT | NULL | cluster:N/A; timeout(s):3600; max_filter_ratio:0.0 | NULL
| 2021-09-08 11:50:07 | 2021-09-08 11:50:07 | 2021-09-08 11:50:07 | 2021-09-08 11:50:07 | 2021-09-08 11:50:07 | |
{"Unfinished backends":{},"ScannedRows":0,"TaskNumber":0,"All backends":{},"FileNumber":0,"FileSize":0} |