Help
kdb+ and q
Q+A on all things kdb+ database and the q language
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation

How to avoid error in "select xxx, yyy from tb where i in

Hi,I am writing something where I need to extract particular rows in a table, using a pre-computed row id, like this."select xxx, yyy from tb where i in (something)"However, I found that when something is empty, the above select statement will produc...

reactgary by • New Contributor
  • 1217 Views
  • 3 replies
  • 0 kudos

Using "Q server for R" in conjunction with mserve

Hey guys, Has anyone ever used Q server for R to connect to a kdb load balancer from an R process? It seems to me like two things are missing from this interface: a command to send async and a command to receive data on the handle (both required for ...

TerryLynch by • New Contributor II
  • 1880 Views
  • 6 replies
  • 0 kudos

Question about adding minutes row in hourly summary table

Hi allI have a table which is aggregated by hour, like this timesymxy10:00a2411:00a2312:00a1313:00a1314:00a1315:00a1210:00b2411:00b2312:00b1313:00b1314:00b1315:00b12I need to join this with other table with 5 min timebin, which maybe start at 10:05 /...

carfield1 by • New Contributor
  • 839 Views
  • 3 replies
  • 0 kudos

Updating by row position in a grouped table

Hello, I have a table grouped by instrument:instrument TR -----------------AU200_AUD 66.1 AU200_AUD 114.1 AU200_AUD 72.9 AU200_AUD 121.3 AU200_AUD 83.15 AUD_CAD 0.00975 AUD_CAD 0.01005 AUD_CAD 0.00435 AUD_CAD 0.00755 AUD_CAD 0.00748 AUD_CHF 0.026975A...

Francisco by • New Contributor
  • 844 Views
  • 3 replies
  • 0 kudos

Access and Mserve

Hello,I have an access point and a load balancer with mserve.q loaded. I have clients connecting to the access point and calling functions that send deferred sync messages to the load balancer which in turn finds least busy slave and returns the data...

Main Office Contacts

EMEA
Tel: +44 (0)28 3025 2242

AMERICAS
Tel: +1 (212) 447 6700

APAC
Tel: +61 (0)2 9236 5700

Useful Information
Resources
Popular Links
Follow Us

KX. All Rights Reserved.

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

Privacy Policy

Export Statement

Terms of Use

Processing Notice