Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The mpp task may hang if it reads from many data source #3444

Closed
lilinghai opened this issue Nov 16, 2021 · 0 comments · Fixed by #3445 or #3465
Closed

The mpp task may hang if it reads from many data source #3444

lilinghai opened this issue Nov 16, 2021 · 0 comments · Fixed by #3445 or #3465

Comments

@lilinghai
Copy link

release-5.3
29606_BoardSiteMonitorTiflash.txt hangs 60mins and timeout

	id                                                     	task        	estRows   	operator info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	actRows	execution info                         	memory 	disk
	Projection_59                                          	root        	11        	Column#1875, Column#1874, Column#1878, Column#1879, Column#1880, Column#1881, Column#1882, Column#1883, Column#1884, Column#1885, Column#1886, Column#1887, Column#1888                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	time:1h0m0.1s, loops:1, Concurrency:OFF	16.3 KB	N/A
	└─TableReader_546                                      	root        	11        	data:ExchangeSender_545                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	time:1h0m0.1s, loops:1                 	N/A    	N/A
	  └─ExchangeSender_545                                 	cop[tiflash]	11        	ExchangeType: PassThrough                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	    └─Projection_541                                   	cop[tiflash]	11        	Column#1878, Column#1879, Column#1880, Column#1881, Column#1882, Column#1883, Column#1884, Column#1885, Column#1886, Column#1887, Column#1888, Column#1874, Column#1875                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	      └─HashAgg_542                                    	cop[tiflash]	11        	group by:Column#1874, Column#1875, funcs:sum(Column#2124)->Column#1878, funcs:sum(Column#2125)->Column#1879, funcs:sum(Column#2126)->Column#1880, funcs:sum(Column#2127)->Column#1881, funcs:sum(Column#2128)->Column#1882, funcs:sum(Column#2129)->Column#1883, funcs:sum(Column#2130)->Column#1884, funcs:sum(Column#2131)->Column#1885, funcs:sum(Column#2132)->Column#1886, funcs:sum(Column#2133)->Column#1887, funcs:sum(Column#2134)->Column#1888, funcs:firstrow(Column#1874)->Column#1874, funcs:firstrow(Column#1875)->Column#1875                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	        └─ExchangeReceiver_544                         	cop[tiflash]	11        	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	          └─ExchangeSender_543                         	cop[tiflash]	11        	ExchangeType: HashPartition, Hash Cols: [name: Column#1874, collate: N/A], [name: Column#1875, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	            └─HashAgg_63                               	cop[tiflash]	11        	group by:Column#2208, Column#2209, funcs:sum(Column#2197)->Column#2124, funcs:sum(Column#2198)->Column#2125, funcs:sum(Column#2199)->Column#2126, funcs:sum(Column#2200)->Column#2127, funcs:sum(Column#2201)->Column#2128, funcs:sum(Column#2202)->Column#2129, funcs:sum(Column#2203)->Column#2130, funcs:sum(Column#2204)->Column#2131, funcs:sum(Column#2205)->Column#2132, funcs:sum(Column#2206)->Column#2133, funcs:sum(Column#2207)->Column#2134                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             	0      	                                       	N/A    	N/A
	              └─Projection_572                         	cop[tiflash]	11        	cast(case(eq(Column#1877, order), Column#1876, 0), decimal(42,0) BINARY)->Column#2197, cast(case(eq(Column#1877, forecast_rec), Column#1876, 0), decimal(42,0) BINARY)->Column#2198, cast(case(eq(Column#1877, rec), Column#1876, 0), decimal(42,0) BINARY)->Column#2199, cast(case(eq(Column#1877, send), Column#1876, 0), decimal(42,0) BINARY)->Column#2200, cast(case(eq(Column#1877, rec_current), Column#1876, 0), decimal(42,0) BINARY)->Column#2201, cast(case(eq(Column#1877, disp), Column#1876, 0), decimal(42,0) BINARY)->Column#2202, cast(case(eq(Column#1877, order_disp), Column#1876, 0), decimal(42,0) BINARY)->Column#2203, cast(case(eq(Column#1877, forecast_disp), Column#1876, 0), decimal(42,0) BINARY)->Column#2204, cast(case(eq(Column#1877, stay_disp), Column#1876, 0), decimal(42,0) BINARY)->Column#2205, cast(case(eq(Column#1877, sign), Column#1876, 0), decimal(42,0) BINARY)->Column#2206, cast(case(eq(Column#1877, sign_current), Column#1876, 0), decimal(42,0) BINARY)->Column#2207, Column#1874, Column#1875	0      	                                       	N/A    	N/A
	                └─Union_540                            	cop[tiflash]	11        	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  ├─Projection_561                     	cop[tiflash]	1         	Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             	0      	                                       	N/A    	N/A
	                  │ └─Projection_450                   	cop[tiflash]	1         	case(gt(rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, 0), rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id)->Column#1874, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#168, order->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │   └─Projection_452                 	cop[tiflash]	1         	Column#168, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_453                  	cop[tiflash]	1         	group by:Column#2074, Column#2075, funcs:sum(Column#2076)->Column#168, funcs:firstrow(Column#2077)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2078)->rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, funcs:firstrow(Column#2079)->rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │       └─ExchangeReceiver_455       	cop[tiflash]	1         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │         └─ExchangeSender_454       	cop[tiflash]	1         	ExchangeType: HashPartition, Hash Cols: [name: Column#2074, collate: N/A], [name: Column#2075, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │           └─HashAgg_451            	cop[tiflash]	1         	group by:Column#2153, Column#2154, funcs:count(1)->Column#2076, funcs:firstrow(Column#2150)->Column#2077, funcs:firstrow(Column#2151)->Column#2078, funcs:firstrow(Column#2152)->Column#2079                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Projection_550       	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, case(gt(rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, 0), rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id)->Column#2153, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2154                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               	0      	                                       	N/A    	N/A
	                  │               └─Selection_86       	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 0), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   	0      	                                       	N/A    	N/A
	                  │                 └─TableFullScan_85 	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_562                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_456                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#339, forecast_rec->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               	0      	                                       	N/A    	N/A
	                  │   └─Projection_459                 	cop[tiflash]	1         	Column#339, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_457                  	cop[tiflash]	1         	group by:Column#2157, Column#2158, funcs:count(1)->Column#339, funcs:firstrow(Column#2155)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2156)->rtdb.zto_ssmx_bill_detail.forecast_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                  │       └─Projection_551             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2158                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_118     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_117     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.forecast_rec_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Selection_116        	cop[tiflash]	0         	eq(rtdb.zto_ssmx_bill_detail.bill_state, 0), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_115  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_563                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_464                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#509, rec->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │   └─Projection_467                 	cop[tiflash]	1         	Column#509, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_465                  	cop[tiflash]	1         	group by:Column#2161, Column#2162, funcs:count(1)->Column#509, funcs:firstrow(Column#2159)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2160)->rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                  │       └─Projection_552             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2162                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_155     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_154     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Selection_153        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 10), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_152  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_564                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_472                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#679, send->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │   └─Projection_475                 	cop[tiflash]	1         	Column#679, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_473                  	cop[tiflash]	1         	group by:Column#2165, Column#2166, funcs:count(1)->Column#679, funcs:firstrow(Column#2163)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2164)->rtdb.zto_ssmx_bill_detail.earliest_rec_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                  │       └─Projection_553             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2166                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_192     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_191     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Selection_190        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 22), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_189  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_565                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_480                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.rec_date, %Y-%m-%d)->Column#1875, Column#849, rec_current->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │   └─Projection_483                 	cop[tiflash]	1         	Column#849, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.rec_date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_481                  	cop[tiflash]	1         	group by:Column#2169, Column#2170, funcs:count(1)->Column#849, funcs:firstrow(Column#2167)->rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, funcs:firstrow(Column#2168)->rtdb.zto_ssmx_bill_detail.rec_date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          	0      	                                       	N/A    	N/A
	                  │       └─Projection_554             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, rtdb.zto_ssmx_bill_detail.rec_date, rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, date_format(rtdb.zto_ssmx_bill_detail.rec_date, %Y-%m-%d)->Column#2170                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_229     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_228     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.earliest_rec_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Selection_227        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 10), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL), gt(rtdb.zto_ssmx_bill_detail.rec_date, 1999-01-01 00:00:00.000000)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_226  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_566                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, cast(Column#1877, varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci)->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      	0      	                                       	N/A    	N/A
	                  │ └─Projection_488                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#1019, forecast_disp->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │   └─Projection_491                 	cop[tiflash]	1         	Column#1019, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_489                  	cop[tiflash]	1         	group by:Column#2173, Column#2174, funcs:count(1)->Column#1019, funcs:firstrow(Column#2171)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2172)->rtdb.zto_ssmx_bill_detail.forecast_disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               	0      	                                       	N/A    	N/A
	                  │       └─Projection_555             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2174                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_266     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_265     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │             └─Selection_264        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL), le(rtdb.zto_ssmx_bill_detail.bill_state, 40)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_263  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_567                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_496                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#1189, stay_disp->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	0      	                                       	N/A    	N/A
	                  │   └─Projection_499                 	cop[tiflash]	1         	Column#1189, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_497                  	cop[tiflash]	1         	group by:Column#2177, Column#2178, funcs:count(1)->Column#1189, funcs:firstrow(Column#2175)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2176)->rtdb.zto_ssmx_bill_detail.forecast_disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               	0      	                                       	N/A    	N/A
	                  │       └─Projection_556             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2178                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_303     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_302     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.forecast_disp_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │             └─Selection_301        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL), le(rtdb.zto_ssmx_bill_detail.bill_state, 32)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_300  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_568                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_504                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#1359, order_disp->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │   └─Projection_507                 	cop[tiflash]	1         	Column#1359, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_505                  	cop[tiflash]	1         	group by:Column#2181, Column#2182, funcs:count(1)->Column#1359, funcs:firstrow(Column#2179)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2180)->rtdb.zto_ssmx_bill_detail.disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │       └─Projection_557             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.disp_site_id, rtdb.zto_ssmx_bill_detail.disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2182                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_340     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_339     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.disp_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                  │             └─Selection_338        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 40), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_337  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_569                     	cop[tiflash]	1         	cast(Column#1874, bigint(20) BINARY)->Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       	0      	                                       	N/A    	N/A
	                  │ └─Projection_512                   	cop[tiflash]	1         	rtdb.zto_ssmx_bill_detail.disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#1529, disp->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │   └─Projection_515                 	cop[tiflash]	1         	Column#1529, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_513                  	cop[tiflash]	1         	group by:Column#2185, Column#2186, funcs:count(1)->Column#1529, funcs:firstrow(Column#2183)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2184)->rtdb.zto_ssmx_bill_detail.disp_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        	0      	                                       	N/A    	N/A
	                  │       └─Projection_558             	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.disp_site_id, rtdb.zto_ssmx_bill_detail.disp_site_id, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2186                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │         └─ExchangeReceiver_377     	cop[tiflash]	0         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │           └─ExchangeSender_376     	cop[tiflash]	0         	ExchangeType: HashPartition, Hash Cols: [name: rtdb.zto_ssmx_bill_detail.disp_site_id, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                  │             └─Selection_375        	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 40), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │               └─TableFullScan_374  	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  ├─Projection_570                     	cop[tiflash]	1         	Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             	0      	                                       	N/A    	N/A
	                  │ └─Projection_520                   	cop[tiflash]	1         	case(eq(rtdb.zto_ssmx_bill_detail.sign_site_id, 0), rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id)->Column#1874, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#1875, Column#1699, sign->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │   └─Projection_522                 	cop[tiflash]	1         	Column#1699, rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  │     └─HashAgg_523                  	cop[tiflash]	1         	group by:Column#2112, Column#2113, funcs:sum(Column#2114)->Column#1699, funcs:firstrow(Column#2115)->rtdb.zto_ssmx_bill_detail.order_create_date, funcs:firstrow(Column#2116)->rtdb.zto_ssmx_bill_detail.dpm_site_id, funcs:firstrow(Column#2117)->rtdb.zto_ssmx_bill_detail.sign_site_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            	0      	                                       	N/A    	N/A
	                  │       └─ExchangeReceiver_525       	cop[tiflash]	1         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                  │         └─ExchangeSender_524       	cop[tiflash]	1         	ExchangeType: HashPartition, Hash Cols: [name: Column#2112, collate: N/A], [name: Column#2113, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │           └─HashAgg_521            	cop[tiflash]	1         	group by:Column#2190, Column#2191, funcs:count(1)->Column#2114, funcs:firstrow(Column#2187)->Column#2115, funcs:firstrow(Column#2188)->Column#2116, funcs:firstrow(Column#2189)->Column#2117                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │             └─Projection_559       	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.order_create_date, rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id, case(eq(rtdb.zto_ssmx_bill_detail.sign_site_id, 0), rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id)->Column#2190, date_format(rtdb.zto_ssmx_bill_detail.order_create_date, %Y-%m-%d)->Column#2191                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                  │               └─Selection_411      	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 44), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                  │                 └─TableFullScan_410	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
	                  └─Projection_571                     	cop[tiflash]	1         	Column#1874, Column#1875, cast(Column#1876, bigint(21) BINARY)->Column#1876, Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             	0      	                                       	N/A    	N/A
	                    └─Projection_526                   	cop[tiflash]	1         	case(eq(rtdb.zto_ssmx_bill_detail.sign_site_id, 0), rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id)->Column#1874, date_format(rtdb.zto_ssmx_bill_detail.biz_sign_date, %Y-%m-%d)->Column#1875, Column#1870, sign_current->Column#1877                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                      └─Projection_528                 	cop[tiflash]	1         	Column#1870, rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id, rtdb.zto_ssmx_bill_detail.biz_sign_date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                        └─HashAgg_529                  	cop[tiflash]	1         	group by:Column#2118, Column#2119, funcs:sum(Column#2120)->Column#1870, funcs:firstrow(Column#2121)->rtdb.zto_ssmx_bill_detail.dpm_site_id, funcs:firstrow(Column#2122)->rtdb.zto_ssmx_bill_detail.sign_site_id, funcs:firstrow(Column#2123)->rtdb.zto_ssmx_bill_detail.biz_sign_date                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	0      	                                       	N/A    	N/A
	                          └─ExchangeReceiver_531       	cop[tiflash]	1         	                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     	0      	                                       	N/A    	N/A
	                            └─ExchangeSender_530       	cop[tiflash]	1         	ExchangeType: HashPartition, Hash Cols: [name: Column#2118, collate: N/A], [name: Column#2119, collate: N/A]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                              └─HashAgg_527            	cop[tiflash]	1         	group by:Column#2195, Column#2196, funcs:count(1)->Column#2120, funcs:firstrow(Column#2192)->Column#2121, funcs:firstrow(Column#2193)->Column#2122, funcs:firstrow(Column#2194)->Column#2123                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         	0      	                                       	N/A    	N/A
	                                └─Projection_560       	cop[tiflash]	0         	rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id, rtdb.zto_ssmx_bill_detail.biz_sign_date, case(eq(rtdb.zto_ssmx_bill_detail.sign_site_id, 0), rtdb.zto_ssmx_bill_detail.dpm_site_id, rtdb.zto_ssmx_bill_detail.sign_site_id)->Column#2195, date_format(rtdb.zto_ssmx_bill_detail.biz_sign_date, %Y-%m-%d)->Column#2196                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 	0      	                                       	N/A    	N/A
	                                  └─Selection_440      	cop[tiflash]	0         	ge(rtdb.zto_ssmx_bill_detail.bill_state, 44), ge(rtdb.zto_ssmx_bill_detail.order_create_date, NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  	0      	                                       	N/A    	N/A
	                                    └─TableFullScan_439	cop[tiflash]	1354394260	table:t, keep order:false, stats:pseudo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	0      	                                       	N/A    	N/A
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants