Dremio UI issue

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