I am aware of this resource. But it does not spell out what parameters .u.upd takes and how to check if it worked. This statement executes without error, although it does not seem to do anything: ...

I'm trying to setup qStudio in windows. While adding a new server, an error message pops up, saying: Connection does not work.java.io.IOException: java.sql.SQLException: Connection refused: connec...

Is it possible to set column attributes for a partitioned table? q)h "update `g#ticker from `pmd" 'par q)h "update `s#ts from `pmd" 'par q) Should I set the attributes on the memory table, befor...

I want to ensure all values in column x are no smaller than 0.5, so I do: update x:max (x 0.5) from myTable But this gives an error (in Studio For KDB+): An error occurred during execution of t...

Now that the 32-bit version of kdb+ has been made free for commercial use by kx, what benefits are there still to buying a licence, other than: 64-bit version will allow you to address more than ...

Kx announced their free kdb+ (32bit) time series database. What performance in terms of reads/writes per second can we typically expect from this database? I do understand this is a complex quest...

I'd like to calculate a new column which is a function of several columns using select. My actual application will involve a grouping in the select so the columns entries which I will pass to the ...

I've heard quite a couple times people talking about KDB deal with millions of rows in nearly no time. why is it that fast? is that solely because the data is all organized in memory? another thin...

How would I go about getting a list of available functions and their parameters in a given namespace?

I have a C application that streams data to a kdb memory table all day, eventually outgrowing the size of my server RAM. The goal ultimately is to store data on disk, so I decided to run a timer pa...

I have two directories that each contain a date-partitioned splayed table. Each directory has its own sym file as expected. The tables are exactly the same. I want to consolidate this into one dir...

I am defining a function that contains another function inside: find_badTicks:{ [tab;sec] // dummy function, for debug.. Ndays: 10i ; dates: select distinct date from tab where sym = sec ; clos...

How can I delete the first 10 rows from a kdb table? I want to delete specifically the first 10 rows returned from: select [10] from mytable I tried to use delete with the i index but the count ...

I have about 500 sensors which emit a value about once a minute each. It can be assumed that the value for a sensor remains constant until the next value is emitted, thus creating a time series. Th...

This code produces a sequence of dates: firstdate: 2008.06.01 lastdate: 2008.08.31 daterange: firstdate + til (lastdate - firstdate) + 1 Is it possible to generate the same range excluding weeke...

I need to query a database which contains names of companies. I have list of around 50 names, for which i have to get the data. But I am unable to write a query using in command as there spaces in ...

What are available tools/libraries to integrate Python with kdb?

I'm writing a q script that loads a db in a particular path and does some processing on it. The location of the db is currently hardcoded in the script, but I want to pass the db path as an argumen...