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

Reply
Occasional Contributor
Posts: 11

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

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

Contributor
Posts: 41

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

Posted in reply to Sangramjit

Do you have kerberos installed/configured?

Ask a Question
Discussion stats
  • 1 reply
  • 685 views
  • 0 likes
  • 2 in conversation