cancel
Showing results for 
Search instead for 
Did you mean: 

date

finmayer
New Contributor
I have tried the example from http://code.kx.com/wiki/JB:KdbplusForMortals/segments#1.4.3_Multiple_Segmented_Tables
But I don't understand what is the date variable when a segmented table loaded? It seems the date variable contains dates from all segments but in ascending order. Why dates are reapeted not unique? Even if I delete this variable from the context, tables contains valid date columns, but select command if the date variable is used doesn't work any more.
1 REPLY 1

charlie
New Contributor II
New Contributor II
date's length and values reflect those of the underlying partitions.
Do not delete or modify the date variable. If you want the unique values, you could use "distinct date".
Note that multiple segmented tables is made somewhat redundant with kdb+v3.0 (64bit) as the 2 billion element in a vector limit has been removed.

thanks