When making a particular select in a table with about 2.7 billion records the Hive returns error. But including a LIMIT 2147483647 , the select not the error.
The problem is that I need to sweep the entire table and not just 2,147,483,647 records. Is there a way to solve this problem?