急，union all 使用出错？？？
SELECT min(fromm5time(starttime)),max(fromm5time(endtime)), inet_btoa(tunsrc),GTPTEID,
tunsrcport,tundstport,
sum(octets/1000000)as ULthroughput,
max(octets/((endtime-starttime)/1000000000)/1000000) as "max_rate(MByte/s)",
inet_btoa(src),inet_btoa(dst)
from(
select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job23
union all
select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job24
union all
select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job25
union all
select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job26
) as c
where
starttime > tom5time(‘2012-07-09 00:00:01’ )
and endtime < tom5time(‘2012-07-09 23:59:59’ )
and inet_btoa(dst) like ‘10.247%’
and ((endtime-starttime)/1000000>100)
and (packets>100)
group by GTPTEID,dst
在几个表中按时间取数据，但是运行时遇到了错误 SQL Error (126): Incorrect key file for table ‘/tmp/#sql_db6_0.MYI’; try to repair it */
能帮我解决么？？？？？，不用union all 却可以取数据
——解决方案——————–
还有多少磁盘空间？
——解决方案——————–
临时表存放空间不足
show variables like ‘%tmp%’;
看看此目录是否已经没有足够空间用于临时表的排序
——解决方案——————–
没有足够的表空间造成的，检查。
转载请注明原文链接：急union all 施用出错？
