Use this tag for questions concerning "HPL SQL" (HPL/SQL), a hive service to run stored procedure/function/script. Use the tag [hive-hplsql] for questions about HPL SQL.
Questions tagged [hive-hplsql]
9 questions
1
vote
1 answer
PRAGMA AUTONOMOUS_TRANSACTION
I have procedure A with PRAGMA AUTONOMOUS_TRANSACTION to log the activity of a main program.
Now I am calling this program A in a procedure B to log the activity process in program B. If any error occurs in program A it fails the program B also. How…
Vikas
- 107
- 7
1
vote
0 answers
Crystal Reports integration with Hadoop/Hive/HPLSQL
We are migrating data from Oracle to Hadoop and there is a requirement
to continue use the existing reporting tool(Crystal Report) to generate reports from Hadoop (instead of Oracle)
In the current scenario we are using an Oracle Stored PROC to…
Nina A
- 53
- 6
0
votes
0 answers
Hplsql error NoClassDefFoundError: org/apache/commons/cli/ParseException
I'm getting this error when I try to install hplsql on hive. Any ideas on what's causing this? It basically says: Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/cli/ParseException
caused by:…
0
votes
1 answer
Migrate stored procedure on SQL Server to HPL/SQL (Hadoop ecosystem)
I have a project which required migrating all the stored procedure from SQL Server to Hadoop ecosystem.
So the main point makes me concerned that if HPL/SQL is terminated or not up-to-date as in http://www.hplsql.org/new. It shows latest updated…
Chi_Cong
- 1
0
votes
0 answers
How to Use mapped object to import ORACLE table to HIVE HPL/SQL
I am using hplsql-0.3.31 to import a table data from ORACLE database using MAP OBJECT feature.
I can successfully import the object and print it's values. But if I use this object with any hive table/cursor, the code gives me errors.
Here is a…
Raje
- 15
- 1
- 6
0
votes
0 answers
Is it possible to run plsql package under hplsql command using hplsql -f package.sql
I am trying to run a PL/SQL package which contains a procedure with cursor (with parameter) and also procedure with 3 parameters will it work fine in hplsql.
Something like:
create package name as
procedure proc( with 3 input parameters )
end…
sunny
- 1
- 1
0
votes
1 answer
Hive hplsql stored procedure cannot insert timestamp values
I try to use Hive HPL/SQL stored procedure's insert data into hive table. But it is unable to insert timestamp value. My table defined as following:
col_name | data_type | comment |
+----------------+---------------+----------+
| id …
David Wang
- 41
- 7
0
votes
2 answers
not able to run HPL/SQL query from HIVE cli
I tried to run "dbms_output.put_line('This is HPL/Sql');" from Hive cli it has given below exception.
NoViableAltException(26@[])
at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1140)
at…
Deepak Kumar
- 433
- 4
- 12
0
votes
1 answer
Apache HPLSQL - Permission Denied while running HPLSQL Query
I'm trying to run a query using the hplsql command and getting this error. It seems to be a permission issue. My current logged in user is not being considered
Caused by:…
Abbas Gadhia
- 14,532
- 10
- 61
- 73