kdb+ and q

kdb+ and q

Q+A on all things kdb+ database and the q language

Forum Posts

Sorted by:

Start a conversation

Problem in datetime parsing while loading data into table from csv

Hi,I am trying to load the data from csv file to a table. One of the column in the file is having datetime column with below sample values. number duration u_resolved u_resolved_by counts dummy2 dummy3 C0010837 86400 11/29/2012 9:14 abc 249494 0.001 ...

slow performance of win32 version of KDB

Hi, I like to test some simple thing on windows version of 32bit KDB, I inputted a table with 99722 row, with date, sym and other 15 columns of numeric data. However, if I just take a simple average of that 15 column, it take more than 3 minutes to r...

Sparse Arrays

Can anyone point to discussion or work on sparse arrays in k/q? This must have come up somewhere, but I don't see anything in the open resources.Cheers

[TorQ] .gw.syncexec[] select servers by procname or attribute

How can I make .gw.syncexec[] work like .servers.getservers[]? I have separate hdbs for each stock market. How can I query for prc_stocks but not hk_stocks? .servers.getservers[] supports selecting servers by procname or attributes. thxproctype,procn...

functional select update

I have a table tab, and I have a list of columns allCols I want to calculate their correlation against anther column rr. Below doesn't seem to work: ?[tab; enlist 1b; 0b;allCols!{ x, cor, y }'[4#`rr; allCols] ];but if I just do a simple average, ?[ta...

Top Kudoed Authors

User

Count

5

4

2

2

Main Office Contacts

Useful Information

Resources

Popular Links

Follow Us

youtube

instagram

KX. All Rights Reserved.

KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.

Export Statement

Processing Notice