How to perform a select with 2.7 billion records in every table?

Asked

Viewed 32 times

1

By making a certain select in a table with about 2.7 billion records the Hive returns error. But including a LIMIT 2147483647, the select not of error.

The problem is I need to sweep all table and not just 2,147,483,647 records. There would be a way to solve this problem?

  • Is it really necessary to scan the entire table? If you need to do this, try to define offsets and travel them with a delay.

  • Yes. Offsets are not recognized in the software version I work with. Any more suggestions?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.