Birzos
New Contributor
since ‎2017.07.03
‎2021.06.14

User Statistics

  • 22 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

The following query takes <1millisecond to run returning 61 records.select sym,bar,timestamp:floor((`long$("p"$bar))-`long$1970.01.01D00:00)%1e6,open,high,low,close,volume, dx:0 from `forex_bar where bar within (2017.08.18T10:00;2017.08.18T11:00),sym...
Is there a specific reason why the following works with a single itemselect [-1] sym,bar,open,high,low,close,volume, dx:`forex_bar[enlist (bar-00:05:00),sym]`close from `forex_bar where sym=`GBPUSDBut with a multi item lookup it failsselect [-10] sym...
Have a separate process which subscribes to the tickerplant, sends in the quotes which it keeps a temporary copy of them. There is an aggregation table with inserts from the quote to a local process table via a +1 xbar ... upsert, the problem is that...
Installed the tickerplant demo from https://github.com/KxSystems/cookbook/tree/master/start/tick and tick from https://github.com/KxSystems/kdb-tick/tree/master/tick. Running on CentOS so updated the run.sh from gnome to nohup, however the tick.q is ...
How would you upsert from a query where the query is the same output as the target table, have been through all the documentation and could not find one example.