Search code examples
hiveloaddata

load data into table got following exception

when type "load data inpath '/group/public/aa.txt' into table managed_table;"

i got the following exception,why and how to resolve it?

FAILED: Hive Internal Error: java.lang.RuntimeException(java.io.FileNotFoundException: File 
does not exist: /tmp) java.lang.RuntimeException: java.io.FileNotFoundException: File does 
not exist: /tmp at org.apache.hadoop.hive.ql.Context.getScratchDir(Context.java:148)
Solution

  • hive uses a temporary directory defined in hive.exec.scratchdir in hive-site.xml by default its /tmp/hive-${user.name }. I guess for some reason you don't have /tmp or don't have permissions to it.
    Change the scratch dir or make it available to hive.