Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HPLSQL error while working on Hive

Highlighted

HPLSQL error while working on Hive

Contributor
 
1 REPLY 1

Re: HPLSQL error while working on Hive

Contributor

Hi

I have installed hplsql and I have created a stored procedure which will drop the table which is in hive but I am getting an eroor when I pass the table name as an argument :-

CREATE OR REPLACE PROCEDURE xmCleanupMatcher(IN name STRING) AS

BEGIN

EXECUTE IMMEDIATE 'DROP TABLE ' || name ;

DBMS_OUTPUT.PUT_LINE('Welcome to stored procedure');

END;

/

EXEC xmCleanupMatcher('f_in21');

Here I am passing the table name f_in21 but I am getting an error:-

1:11 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in table name

This table is already present in hive. If I doesn't pass an argument and specify the table name in the starting then I am not getting an error.

Kindly help me out

Don't have an account?
Coming from Hortonworks? Activate your account here