This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, this is an easy one I think, but I can't seem to find the answer after searching for a bit.
I have a hadoop table with hundreds of millions of records per day and I simply want to get 1 record back. In the connect-in-db node I tried using 'limit 1' to pull just the first record (after restricting the date to yesterday's date), but it runs forever! I'm guessing maybe 'limit 1' simply returns 1 record AFTER pulling all the records first?
What is the best/fastest way in-database to pull just a small subset of records from a table?