How to porting Oracle stored procedures to Impala

For example, the original SP include several IN parameters and SQLs. Now, I used java application which implemented each SQLs and used Oozie to simulate the whole process/workflow in Oracle SP, not sure if it is the right way. Could you please provide some advices?

Thanks in advance!

Solution

You can use CTE (Common Table Expressions) to model your queries. Stored procedures as database objects are not supported in Hive/Impala yet. You may want to have a look here

Update multiple columns based on values of another table in stored procedure
Is it possible to determine what caused a duplicate key values
sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'
Passing a table name as a variable to Snowflake stored procedure
Can't drag stored procedure onto dbml designer
Return Stored Proc Results in CTE
Only members of the sysadmin fixed server role can perform this operation. Azure SQL Server Database vs SQL Server Database
What does the new stored procedure default content mean?
Pass table columns as arguments into Teradata SQL stored procedure
Why is DELETE FROM vehicle_data WHERE NOW() > expires_at; failing in my stored function?
How to handle the exception in Snowflake SQL scripting stored procedure with return type as TABLE
How to debug a SP response in Quarkus using EntityManager
Does the prepared SQL statements in a stored procedure make the performance better?
Return multiple ref cursors in single OUT parameter of stored procedure
Stored Procedure for Deleting in Chunks - LOOP not executing
SQL Stored Procedures not finishing when called from Python
How to compare values which may both be null in T-SQL
Data not getting updated via stored procedure in Oracle
How do I resolve SnowparkSQLException: ... User is empty in function for Snowpark python SPROC invocation?
Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
How to pass NULL Value to Stored Procedure Through C#
How to get values from another stored procedure and insert it into the temporary table in one stored procedure in MySQL?
How to renumber the field value in SQL using SQL script
EF6 Stored Procedure does not accept parameters
SQL condition based on variable value
T-SQL stored procedure - error inserting the last variable
Azure Data Factory - Null parameter in stored procedure activity
Azure Data Factory - wait until stored procedure is executed before continuing the next activities
How to find circular dependent table in sql server