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
Do you have kerberos installed/configured?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: