When use group by ,it gets error 42000

[dawsongzhao]

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 5

DATE

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)

[dawsongzhao]

after restart snappydata cluster ,it is ok,But i donot know why,and how to avoid it.

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;
DATE
--------------------------
2019-09-22 09:11:05.333
2019-09-25 10:27:40.587
2019-09-24 20:21:18.261
2019-09-23 15:48:18.03
2019-09-24 06:56:13.779