0

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 features HPL/SQL 0.3.31-September 2011,2017

Has anyone been using this open source tool and this kind of migration is feasible basing on your experience? Very highly appreciated your sharing.

Dale K
  • 25,246
  • 15
  • 42
  • 71
Chi_Cong
  • 1

1 Answers1

0

I am facing the same issue of migrating a huge amount of stored procedures from traditional RDBMS to Hadoop.

Firstly, this project is still active. It is included in Apache Hive since version 2.0 and that's why it stopped releasing individually since September 2017. You could download the latest version of HPL/SQL from the hive repo.

You may have a look at the git history for new features and bug fixes.

Wang Zhong
  • 125
  • 2
  • 9
  • Well thank you, this was good input for my project. However we stop implementing this way due to wasting too much human resources than rebuilding them on Hive. – Chi_Cong Jul 16 '21 at 08:43