Error when executing statement:

Solution:

set hive.vectorized.execution.enabled=false;
set hive.vectorized.execution.reduce.enabled=false;

Turn off vector query

Each time a vectorized query processes data, 1024 rows of data will be processed into a batch instead of one row at a time, which can significantly improve the execution speed.

Then it runs successfully