When use group by ,it gets error 42000 #1457
Description
snappy>
with e as (
select b.handle_time as date, c.pig_type
from ihp_farm_harmless a
left join ihp_harmless b
on a.id = b.origin_id
left join ihp_harmless_detail c
on b.id = c.harmless_id
where farm_id in (123456789, 1)
union all
select b.handle_time as date, c.pig_type
from ihp_slaughter_harmless a
left join ihp_harmless b
on a.id = b.origin_id
left join ihp_harmless_detail c
on b.id = c.harmless_id
where b.handle_place_id in (0, 1)
)
select e.date from e limit 5DATE
2019-09-22 09:11:05.333
2019-09-22 09:11:05.333
2019-09-22 09:11:05.333
2019-09-22 09:11:05.333
2019-09-22 09:11:05.333
5 rows selected
snappy>
with e as (
select b.handle_time as date, c.pig_type
from ihp_farm_harmless a
left join ihp_harmless b
on a.id = b.origin_id
left join ihp_harmless_detail c
on b.id = c.harmless_id
where farm_id in (123456789, 1)
union all
select b.handle_time as date, c.pig_type
from ihp_slaughter_harmless a
left join ihp_harmless b
on a.id = b.origin_id
left join ihp_harmless_detail c
on b.id = c.harmless_id
where b.handle_place_id in (0, 1)
)
select e.date from e group by e.date limit 5;ERROR 42000: (SQLState=42000 Severity=20000) (Server=hdfs06-dev.yingzi.com/172.19.101.81[1527] Thread=ThriftProcessor-62) Syntax error or analysis exception: /tmp/blockmgr-cb722f64-ff3c-47d5-b387-09fc273863ab/0e/temp_shuffle_7758c4b0-3ab8-4417-87b9-4713195efdc7 (No such file or directory)