I have codes as below. Why the last line would fail? How to make it work? Thanks! t:([] c1:`a`b`a`c`b`c; c2:1 1 1 2 2 2; c3:10 20 30 40 50 60);select from t where c1 in enlist `a; // worksselect from t where c1 in `a`b; // works?[t;enlist (in;`c1;enl...
I think the the answer is strings are not interned, only symbols are. But just double checking.
In below code, a1 doesn't work. Any ideas why? myObj: (5 7; (`a; `b ; (4 5)));a3:.[myObj; 1 2 1; {count x}]; // i.e. ((5 7);(`a;`b;4 1))a2:.[myObj; 1 2; {count x}]; // i.e. ((5 7);(`a;`b;2))a1:.[myObj; 1; {count x}]; // i.e. it doesn't worka0:.[myObj...
Currently if I want to import a q-script, e.g. sp.q, from the internet, I need to save it to disk and then load it. system "wget https://raw.githubusercontent.com/KxSystems/kdb/master/sp.q";\l sp.q But if I want to do the \l to the url directly witho...
Just got started with qsql. how to I compare 2 columns of type string. childID and parentID are of type string select from data where childID like parentID
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.