New Contributor
since ‎2017.07.03

User Statistics

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

User Activity

The following query takes <1millisecond to run returning 61 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 and tick from Running on CentOS so updated the 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.