KX Community

darrenwsun

The .Q.qp doc says 0b for splayed table, but on KDB 4.0 it's actually 0. Is it a bug, or there is a new way to check if a table is splayed? q)`:./t/ set ([] v1:10 20 30; v2:1.1 2.2 3.3) `:./t/ q)\l ./t `t q)0b~.Q.qp t 0b q)0~.Q.qp t 1b

darrenwsun

The doc on asc says > table, returns it sorted by the first non-key column and with the partitioned attribute set on it But when there is only one non-keyed column, it's actually the sorted attribute that is set. q)meta asc ([c1:`a`b] c2:2 1) c | t f...

darrenwsun

Hi Community, I have some files that are updated by a script, but the changes are not reflected in Kx Developer. I don't wish to use Upload Local Files or Upload From Server every time such changes happen (they seem to support only files not folders ...

darrenwsun

Hi Community, I want to play around with 64bit on-demand KDB on my corporate PC, but connection couldn't be established due to firewall and I saw the below error. To address it I need to get the URL for the license server. Does anyone know what it is...

darrenwsun

Thanks @sujoy13. What confused me is "directory of a splayed table", which I interpreted as directory t as in your example. A follow-up question: what is the real runtime difference between \l . and \l t for this particular example? The latter form a...

darrenwsun

A generalized solution that doesn't use hardcoded column names (provided as input) or assume the the cells in the nested column having the same length (padded with null for those with shorter length). unpack:{[t;c] maxLen:max count each t[c]; newCols...

darrenwsun

Both works, as (()) is interpreted the same as (). For this reason the first form is preferred. Note that the data type of price is determined by the data type of cell in the first row. q)t:([] time:`time$(); price:()) q)meta t c | t f a -----| -----...

darrenwsun

> when you are debugging and want to see all references to a function, how are you achieving this? Almost all q IDEs will be of no help There are actually plenty of IDEs that supports looking up variable/function references, for example Intellij IDEA...

darrenwsun

Thanks David, kindly let me know once you hear back. I like many of the features from Kx Developer (notably qcumber and qdoc), but it being a web IDE isn't on the list...

KX Community

User Statistics

User Activity

.Q.qp for splayed table

Behavior of asc table

How to make externally-changed files tracked by Kx Developer

64-bit on-demand KDB License server URL

Re: .Q.qp for splayed table

Re: Unpack nested column in table

Re: KDB table with an array as element

Re: What is a script? What is a library? How should I structure my project?

Re: How to make externally-changed files tracked by Kx Developer