Type 20 in Kdb

Community Support
1

Hi Q Gods,

I am encountering a problem with Kdb where I am getting type = 20 when selecting from a symbol type column of a partitioned table, instead of the usual type = 11.

Does anyone knows what type it is?

So given table: select s from t where date = 2015.07.10 , meta of the table shows it is still symbol column (i.e. below returns true)

(meta select s from table) ~ meta select `$ string s from table

when this returns false:

(select s from table) ~ select `$ string s from table

Type returned is 20 for the following:

exec s from table

Have tried looking in http://code.kx.com/wiki/JB:QforMortals2/atoms#Overview but seems type only goes up to 19 for normal atoms.

So appreciate if anyone knows what that is.

If it’s helpful, I am on Kdb v2.8.

Thanks a lot for your help in advance :)

Charles

2

Those are enumerated symbols:

http://code.kx.com/wiki/Reference/Datatype

3

Gotcha, that page is helpful. Thanks WooiKent !

4

You can also read about enumerations here :  http://code.kx.com/wiki/JB:QforMortals/casting\_and\_enumerations#Enumerations

KDB uses enumeration  for partitioned database and creates a sym file. When it loads partition db, it also loads sym file into sym variable which contains list of symbols.
You can also use following query  to fetch symbols in correct type:
sym[exec s from table]

5

Thanks Rahul, can’t believe I have missed that one in Q for Mortals :(
Anyway, thanks !