Support Questions
Find answers, ask questions, and share your expertise

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?