Unable to read large table from oracle database - is there a table size limit?
I was able to connect to oracle database and view list of tables in rapidminer studio. However when I am trying to view the content of one table which has around 5M rows (by double clicking on table name) nothing happens. I have also tried using Read Database operator and it takes ages, nothing happens. Even after two hours the Read Database operator is still running.
I also have small tables in oracle database which I was able to read and view one without any trouble.
I even have that same table with 5M rows in a csv format stored locally and rapidminer studio was able to read it successfully, although it took around 20 seconds to open.
For those who guessed it right - yes I have studio license.
Can someone please tell me is this a bug or is there any better way to read from oracle?