Home

KDB+ q tips and tricks that I have used

Tag: KDB+Q

  • KDB+ q process listening on port and dynamic port allocation

    In KDB+ q, the \p command is used to set the port on which the q process listens for incoming connections. Usage Example: To set the port to 1234, use the following command: To check the currently set port, simply enter: If the port has been set to 1234, the output will be: 1234i If…

  • How to kill long running query on a q process?

    sometime we may want to kill the long running query as it might be taking longer time or it may be wrong query. or pure select query without where clause which cause process to fetch all the records and it takes time, To kill long running or invalid query on KDB+Q process on Linux\Unix we…

  • Reading CSV File Data using KDB+ q

    Reading a CSV file in KDB+ q is straightforward. Here’s a sample syntax: data: (“SSSS”; enlist “,”) 0 `:sample.csv In this example: Trick: If all columns are of the same type, you can simplify the syntax. For instance, if you have more than 100 columns of type S, instead of specifying S repeatedly, you can…