Is there sleep function in Hive?

Question

In Mysql, we can use DO sleep(5) ; to make a pause. But it did not work in Hive.

Is there any sleep function in Hive?

Answer 1

You can call Thread via reflection to make hive wait for some extra time after processing each row, for instance the following query will make hive to wait for 10 seconds

select reflect("java.lang.Thread", "sleep", bigint(10000));

Not the best way but it might work.