Skip to Content
0
Former Member
Nov 09, 2015 at 11:09 AM

Problem integrating SAP HANA with Hadoop in SPS09

31 Views

Hi Experts,

I am facing issue while integrating SAP HANA with Hadoop system.

I am creating the Remote Source using the below code...

CREATE REMOTE SOURCE HADOOP_SOURCE

ADAPTER "hadoop"

CONFIGURATION 'webhdfs_url=http://host:9101;webhcat_url=http://host:50111'

WITH CREDENTIAL TYPE 'PASSWORD'

USING 'user=hduser;password=hdPass'

When we try to open the remote source we get this error.

Is there any thing wrong I am doing while creating remote source.

Created the User defined function "HADOOP_UDF" as shown below.

CREATE VIRTUAL FUNCTION HADOOP_UDF()
RETURNS TABLE
("code" VARCHAR(255), "description" VARCHAR(255), "total_emp" INTEGER, "salary" INTEGER )
CONFIGURATION
'datetime_format=yyyy-MM-dd HH:mm:ss;date_format=yyyy-mm-dd HH:mm:ss;time_format=HH:mm:ss;'
'enable_remote_caching=true;cache_validity=3600;hdfs_location=/user/hduser/samplefile'
AT HADOOP_SOURCE;

and tried to run the UDF in SQL, I get below error.

It says "message": "Permission Denied": user=hduser, access=WRITE

Do we need to have the same user in Hadoop system. Are there any permissions that I need to give to this user in Hadoop system.

Please help me what is that I did wrong in this process.

Thank you.

Best regards,

Ram

Attachments

udf.png (21.3 kB)