KX Community

sieber

Hi,can somebody tell me when exactly a 'conn error is thrown. I got some of theses error in my log file and don't know why this happens.according to http://code.kx.com/wiki/Errors the error means "too many connections (1022 max)".But I can not reprod...

sieber

Hi i want to join two tables on the their time column but i dont want to "left join" them as aj is doing but instead I want an outer join.currently i am using a temporary table with the date values of both tables and doing 2 aj:a:([]date:2014.01.01 2...

sieber

Hi,i am using .j.k to decode JSON data. Unfortunately some stringscontain unicode escaped data:{"a":"B\u00f6rse"}decoding this with kdb produces an error: q).j.k "{\"a\":\"B\\u00f6rse\"}" k){$["{"=*x;(`$c'n#'x)!c'(1+n:x?'":")_'x:d x;"["=*x;.Q.fc[c']d...

sieber

Hi,ich have a big table with many columns that are updated quite often. q)table:([id:1 2 3] quote:4 5 6; field1: 1 2 3);many upserts per second update the quote field.tableview is a table alias that extends the table by some columns that are feeded b...

sieber

Hi,i have a table with column names that contain function parameters (so the names contain special characters : and .)q)table:flip(`a,`$"b:1.4")!(1 2 3;4 5 6)how can I now select these columns?of course "select b:1.4 from table" does not work as inte...

sieber

yes, you should use \t to set up timers.you can use my timer implementation if you want:(libaray/ k code)k)T:([]t:`s#0#.z.Z;f:())k)tn:.z.ts:{e:T i:t?&/t:T`t;$[0>r:.z.Z-0Wz^e`t;."\\t ",$0|-_r*86400000;[T::(i#T),(i+1)_T;@[e`f;::];tn[]]]}k)t:{$[7h=t:abs...

sieber

On Friday, June 9, 2017 at 11:56:04 AM UTC+2, Neetha wrote:Hi Nick,trying to get data from website to q ,but not successful.for example, using below :("DFFFFJ";1#",") 0:3_.Q.hg `$":http://www.google.com/finance/historical?q=LON%3AFDP&output=csv"gives...

sieber

one more solution:t:flip`id`acn`px!(1 2 3 4 3 5 4 6;1 1 1 1 0 1 0 1; 15 20 10 11 10 13 11 17)k)update rmin:(min '+ {@[(#t)#0N;x[0]+!x 1;:;x 2]}'+. exec i,it:(-i-#i )^it-i,px from .q.lj[t]select it:*i by id from t where acn=0) from t

sieber

Hi,you want to remove the last 2 entries of each list?use the function _, for example: -2_1 2 3 4 returns 1 2...-> http://code.kx.com/wiki/Reference/UnderscoreMarkus

sieber

q/k handles many things quite different then the usual programming languages.You really have to accept this and learn the language (-> http://code.kx.com/wiki/JB:QforMortals )but I promise: it's worth! Once you grabbed the concepts of k/q you will lo...

KX Community

User Statistics

User Activity

'conn error

aj outer join

json decode error for strings with utf chars (.j.k)

calculation of table view/alias

select from custom names columns

Re: Non-blocking delayed execution

Re: Http Source

Re: A very tricky question for Gurus

Re: How to cut the biggest n item?

Re: mdev function