Cannot load data from Impala table with 1 billion rows: Qlik Sense Deskop
1. What is the maximum number of rows Qlik Sense Desktop can handle (with 8GB of RAM)?
I am able to select my table but I can not load it. When I load the data, it seems my network connection is at 50% for multiple minutes before I can start, also I don't want to wait for it to finish, more than a minute is unacceptable to get started.
My table has 1 billion rows.
2. If this number of rows is too much, is it possible to work with 'samples' when design the app and then click a 'generate' button or something to compute all the views on all the data?
Re: Cannot load data from Impala table with 1 billion rows: Qlik Sense Deskop
If I'd move my data to Hadoop and connect through Impala, would I be able to leave the data in place and work with let's say the first 10000 rows e.g. in Qlik desktop and when I'm ready trigger to execute a computation on all the views. But in such a way that the (SQL) operations are being pushed down to the cluster rather than the data being copied to my desktop machine? Or is this maybe an advanced feature only possible with the server edition of Qlik Sense?