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-Cloudera/m-p/69339#M2736 Currently Hive does not support loop, so you might have to do it at application level. ... View more