Why is exec in KX Developer not yet supported. doing capstone exercises. Capstone level 2 q

Academy Support
1

Hi,

why is exec in KX Developer not yet supported. doing capstone exercises. Capstone level 2 q

example

exec distinct option_id from trade

nyi. Not yet implemented.

2

You cannot exec directly on a partitioned table.

q)`:HDB/2020.01.01/tab/ set ([] a:1 2 3;b:5 6 7)
q)`:HDB/2020.01.01/tab/
q)\l HDB
tab
date       a b
--------------
2020.01.01 1 5
2020.01.01 2 6
2020.01.01 3 7
q)exec a from tab
'nyi
  [0]  exec a from tab
       ^

You need to select and then you can access a column vector directly:

q)(select a from tab)`a
1 2 3

q)exec a from select a from tab
1 2 3

From exec keyword | Reference:

The table expression texp may be a table in memory, or on disk, where it may be splayed but not partitioned.