Hive error (1) movetask

An error was reported when I executed hive SQL on CDH today.

The error message is:

Failed: execution error, return code 1 from org.apache.hadoop.hive.ql.exe C. movetask
Error statement:

Insert overwrite directory '{$ dir}' select * From tmp_analyse_ OS where logdata = '{$ begin }';

 

Error cause:

Hive source code checks whether the exported path exists. If not, this error is reported. This error is reported only for hive on CDH. Apache has fixed this bug. In fact, CDH does not fix this bug, but adds a configuration file, however, the default configuration file is false ).

Solution:

Add a configuration on hive.

<Property> <Name> hive. Insert. Into. Multilevel. dirs </Name> <value> true </value> </property>

This article from the "programmer's counterattack" blog, please be sure to keep this source http://cdelliqi.blog.51cto.com/9028667/1541625