Recursive query in Hive

Question

Support for insertion with a sentence, but the bush does not support recursive queries.
In relational databases, there is some recursive function, a stored procedure for a recursive query, but the hive does not support stored procedures and a recursive function. how can we achieve a recursive query in the hive?

Answer 1

You can set two properties as true to have recursive queries in a bush session

hive> set mapred.input.dir.recursive = true;

hive> set hive.mapred.supports.subdirectories = true;

These two values ​​work together.