running hpl/sql using java

[#1]

i am trying to execute stored procedure in hive using java for that i found i can use hpl/sql, but i want to know how can i execute this using java. I am not finding anything.

[#2 · Accepted solution]

HPL SQL is not currently supported in CDH. This is a new feature added in Apache Hive 2.0, CDH is currently on Hive 1.1 (plus patches). We plan to rebase to the latest upstream version as part of our future major release, but HPL-SQL is not currently in scope for support for the current CDH releases.

Hope this helps. Thanks

[#3]

then how can i run my stored procedure in CDH ? is there any other way ?