Dears, I have 10 millions records in ES. When I select * from table Limit 10000000, the dremio just shows 1 million records, but my expect is 10 millions, is anyone can tell the reason? Many thanks.
For UI run queries we limit the result to 1 million rows as we store the results to disk so you can scroll through them. If you use jdbc/odbc that limitation doesn’t exist.
1 Like
Thanks for your help .@doron
Hi @doron , is there a way to remove the limit ?
@madantv Currently no, if you do not want records to stop after a million use ODBC/JDBC