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