I’m using the trial version of kdb+ in order to run a query against a record set that is around 120 GB. From the cookbook I’ve found these two articles:
http://code.kx.com/wiki/Cookbook/LoadingFromLargeFiles
http://code.kx.com/wiki/Cookbook/SplayedTables
I want to load data from a large .csv file containing the 120 GB of records and then query it. Because I can’t hold it in-memory, I think I need to save the data into a table on-disk using one of the above methods. Where I’m confused though, is how I would query the on-disk table without having to hold the entire 120 GB in memory. Is this possible or am I forced to query in-memory only using the trial version?