Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I ran into a unique situation today. Looks like a bug to me.
I have a huge qvd ( almost a billion rows) containing 4 years of data. I tried to loop through the qvd to segment it into multiple qvds by year, it is generating empty qvds. Th code works when I tried to do a limited load of upto 1 million rows, fails for larger datasets
pasting the psedu code:
//extracting the distinct years
It works for smaller dataset, but fails for larger dataset by generating empty qvds
Take a look at the execution script log. What does the generated Where statement look like. Are there any record counts?
-Rob
Hi Rob,
I checked the execution log. It shows 0 rows when I try to do a full reload. But the same script works when I try to limit the row count to 1 million by using :
First 1000000
Load *
from Myqvd;
The full reload should generate around 160 million rows, it seems to fail for big data sets.