When you use Azure PowerShell to run HiveQL statements against HDInsight or HDInsight emulator, you might get the following error:
Failed with exception Unable to rename: wasb://firstname.lastname@example.org/hive/scratch/hive_2014-02-12_14-58-27_594_640725686036024640-1/-ext-10001 to: wasb://email@example.com/apps/hive/warehouse/delays
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Creating a /apps/hive/warehouse folder on HDInsight can bypass this error message, but could run into another problem. You might notice a newly created Hive table doesn't contain any records. In the error log, you could find the data file was moved to the
/apps/hive/warehouse folder instead of the /hive/warehouse folder.
To fix the problem on HDInsight cluster version 3.0:
<description>Properties to set when running hive.
To fix the problem on HDInsight cluster version 2.1:
To fix the problem on HDInsight emulator:
<description>location of default database for the warehouse
Why the Templeton service appears disabled? Cannot restart it to make it take the new configuration :(