ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed).

Sangramjit — Wed, 08 Jul 2015 15:19:59 GMT

Hi Team,

I am getting below error message when trying to Load SAS Datasets on Hadoop using HiveServer2 Protocol.

Apart Failing from Loading SAS Datasets on Hadoop, I am able to Connect and Import Hadoop Data to SAS successfully.

libname hdplib hadoop server='ma-bidd-lap12' user='******' password='*****' CONFIG='~/Hadoop/xml_12JUN2015/xml_02JUL2015/core-site.xml' subprotocol=hive2 schema=sas_dev;

proc sql;

create table hdplib.class_sas_data as select * from sashelp.class;

quit;

Error Message:

ERROR: org.apache.hadoop.ipc.RemoteException: Authorization (hadoop.security.authorization) is enabled but authentication

(hadoop.security.authentication) is configured as simple. Please configure another method like kerberos or digest.

NOTE: Validate the contents of the Hadoop configuration file and ensure user permissions are correct.

ERROR: Unable to create stream service from /tmp/sasdata-2015-07-08-15-15-26-183-e-00001.dlv. Use the debug option for more

information.

ERROR: Unable to create stream service from /tmp/sasdata-2015-07-08-15-15-26-183-e-00001.dlv. Use the debug option for more

information.

HADOOP_9: Executed: on connection 2

LOAD DATA INPATH '/tmp/sasdata-2015-07-08-15-15-26-183-e-00001.dlv' OVERWRITE INTO TABLE `CLASS_SAS_DATA`

ERROR: java.sql.SQLException: Error while processing statement: FAILED: SemanticException Line 1:17 Invalid path

''/tmp/sasdata-2015-07-08-15-15-26-183-e-00001.dlv'': No files matching path

hdfs://ma-bidd-lnn01:8020/tmp/sasdata-2015-07-08-15-15-26-183-e-00001.dlv

ERROR: Unable to execute Hadoop query.

ERROR: Execute error.

ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed).

Can Anyone Please help me identifying the issue.

Thanks,

Sangramjit

Re: ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed).

fatcat — Tue, 25 Aug 2015 16:14:07 GMT

Do you have kerberos installed/configured?

topic Re: ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed). in SAS Programming

ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed).

Re: ERROR: Error moving data from Hadoop to Hive (LOAD DATA failed).