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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.