KX Community

darrenwsun

Hi community, There used to be this link that provides the instructions for the setup, but it's no longer valid and I cannot find out the updated link anywhere. Note that it's for the reverse direction of querying KDB+ via ODBC where the setup is eas...

darrenwsun

Hi, I start to try Kx Developer and have been seeing "Failed to connect to remote: authentication failed" when I tried to clone from my GitHub using either https or ssh. Running `git clone` command in a terminal works fine, so it seems the Git setup ...

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

The reloading HDB part is as if "\l ." is run by HDB. This step for a partitioned database, among other things, loads serialized objects of the current directory (e.g. sym file) and caches things like splayed tables in the latest partition. It is nec...

darrenwsun

Short answer, to my understanding, is that feed handler isn't quite a good use case for KDB. A feed handler needs to deal with data sources of various forms, and more generic languages like Java and C++ usually have richer support for those. Another ...

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 -----| -----...

KX Community

User Statistics

User Activity

ODBC setup for KDB+ to query other databases

"authentication failed" when making Kx Developer connect to GitHub

.Q.qp for splayed table

Behavior of asc table

How to make externally-changed files tracked by Kx Developer

Re: What does it actually mean to reload a HDB? why is this needed?

Re: Why are feedhandlers not usually kdb?

Re: .Q.qp for splayed table

Re: Unpack nested column in table

Re: KDB table with an array as element