title: Convert Oracle stored procedure to Hive or Spark
body: <p>I have written stored procedures in Oracle. Is there any way I can implement the same functionalities of that stored procedure in Hive or Spark. </p>
  
  <p>As in Oracle stored procedures, we have cursors and we can call one procedure inside the other procedure with plenty of other operations too.</p>
  
  <p>Please suggest if that’s possible in Hive or if there is some other way around. I searched online and it seems Hive version 2 provides an option to work with stored procedures. </p>
  
  <p>But what could be the solution for the older versions?</p>
  
  <p>I'm new to Hive and Spark so any guidance or suggestions are welcomed.</p>
  
  <p>Thanks in advance.</p>