为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
-
【TiDB 版本】：3.0 ga 版本
-
【问题描述】：
1.这个问题非常奇怪
问题描述
1.基于表A，一直跑着一个sql，使用kettle 执行，获取数据，昨天新建了表B，但是发现今天表A的sql，一直无法返回结果，使用kettle的tableinput，查看showprocesslit，sql一直存在，这个时候，从cpu和内存看，都执行完成了，很长时间之后，showprocesslist 的sql 消失，但是还是无结果。今天把昨天新建的表B，删除了，竟然A的sql 回复了。 想不明白。
完全没有关系的2个表，咋会影响呢 -
2.表A的sql：
SELECT billid,Max(StartTime) as StartTime,MIN(soc) AS rbsoc,MAX(soc) AS RESOC,
MAX(HighestTemperature) AS RHT,MIN(lowestTemperature) AS RLT,
MAX(HighestTemperature-lowestTemperature) AS RDiffT,
MAX(HighestVoltage) AS RSHV,MIN(LowestVoltage) AS RSLV,
MAX(HighestVoltage-LowestVoltage) AS RDifV,
IFNULL(
(
ROUND(max(CurrentElectricMeter))-ROUND(max(BillInitElectricMeter))
),0) AS RPower,
MAX(DemandVoltage) AS MaxDV, MIN(DemandVoltage) AS MinDV,MAX(DemandVoltageDemandCurrent) AS MaxDP,
MAX(DirectPower) AS MaxAP, SUM(DemandVoltageDemandCurrent) AS DPower,SUM(DirectPower) AS APower,
MAX(DirectVoltageDirectCurrent) AS MaxPower,MAX(DirectVoltage) AS MaxRv,MAX(DirectCurrent) AS MaxRc,
MAX(DemandCurrent) AS MaxDC,ROUND(AVG(DemandVoltageDemandCurrent),2) as AvgDP,ROUND(AVG(DirectPower),2) as AvgPower,
ROUND(sum(DemandVoltage),2) as SumDV,ROUND(sum(DemandCurrent),2) as SumDC,
ROUND(sum(DirectVoltage),2) as SumAV,ROUND(SUM(DirectCurrent),2) as SumAC
FROM ETL_SingleCharging
WHERE upttime>=DATE_FORMAT(DATE_ADD(current_date(),INTERVAL -2 DAY),‘%Y-%m-%d 00:00:00’)
AND upttime<DATE_FORMAT(current_date(),‘%Y-%m-%d 00:00:00’)
GROUP BY billid
- 3.表B的数据结构
若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出打印结果，请务必全选并复制粘贴上传。
