How to loop trough data in Hive?

[#1]

Hi,

I would like to loop through data inside my Hive tables, ¿which is the best tool in order to do that?

I have been searching and I do not find the answer.

Thanks!

[#2]

Have you explored Hive JDBC driver ,which you can connect from Java code, query Hive tables and loop through data.

Official site:
https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-1.html

Doc:
http://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apa...

Hope helps.

[#3]

I think I understand you better from your another post:

http://community.cloudera.com/t5/Batch-SQL-Apache-Hive/Something-similar-to-PL-HQL-available-on-Clou...

Currently Hive does not support loop, so you might have to do it at application level.