The Following Statement Failed To Execute. What Can Be The Cause? Loa

1.	The Following Statement Failed To Execute. What Can Be The Cause? Load Data Local Inpath ‘${env:home}/country/state/’ Overwrite Into Table Address;
Answer» The LOCAL INPATH should CONTAIN a FILE and not a directory. The $ENV:HOME is a valid variable available in the hive environment. The local inpath should contain a file and not a directory. The $env:HOME is a valid variable available in the hive environment.

The Following Statement Failed To Execute. What Can Be The Cause? Load Data Local Inpath ‘${env:home}/country/state/’ Overwrite Into Table Address;

Answer»

The LOCAL INPATH should CONTAIN a FILE and not a directory. The $ENV:HOME is a valid variable available in the hive environment.

The local inpath should contain a file and not a directory. The $env:HOME is a valid variable available in the hive environment.