[renbright]

anyone has any suggestions for pushing data to tickerplant and then to rdb? I have the following error.

 

 

[renbright]

Thanks for your reply. I am good now.  currently my .u.upd does not take table as input.  it works after I converted table into list:  flip = kx.q(‘flip’); ticker(‘.u.upd’,’ustrisk’, flip (df.values.tolist()))

is there any good way to upsert list/dataframe to HDB table?

 

 

 

[renbright]

For python interface, which one should I pick and install?

 

 

 

[renbright]

we are using pykx to load data from kdb database and want to send data back to kdb after doing some operation:

1. in qConnection, sendSync can read/write data from/to kdb

2. what about pykx?

[renbright]

thanks for your reply:

1. they are internal hosts and do not have firewall/networking issue. my local PC can ping the IP

2.  cannot open 10.106.4.131:6144  in the browser

3.  From an existing qconnection to hopen this one, I have error like ‘hop. OS reports: No route to host’

4. if using kx.c kdbclient3 = new kx.c(“nyblrhirsd01”, 6154, Environment.UserName + “:mypassword”),

System.Net.Sockets.SocketException: ‘A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.106.4.131:6154’

 

Any suggest?

[renbright]

I copied 10.106.4.131:6154  in a brower,  but it shows me cannot reach the page

[renbright]

thanks for reply.

1. from server side, I can see 6154 is running, which is open

2. my #c code and the other good KDB server cannot make connection to the new server. my local PC can ping the new server

 

 

 

 

[renbright]

thanks a lot. that works

[renbright]

Yes, I added new columns yesterday and can see it RDB. Today, I can see new data in yesterday HDB. But can not get HDB back fill using Q chk.

 

any suggest?

[renbright]

Thanks for your reply:

1. I did have new table added at the same time. it seems the new table can be back-filled;

2. addcol works for that, but each time only add one column. do you know how to add multiple columns one time?

[renbright]

Thanks for reply.  We did follow that doc to set up this, but failed to setup client mode:

– connection is good between two TLS-enabled KDB servers;

-but from a client server like an algo/pricing server, we cannot make connection to the TLS-enabled server using the following.  Can anybody suggest a correct way for that?

new kx.c("tcps://hostserver, port, Environment.UserName + ":mypassword");

q)h:hopen`:tcps://hostname:port[:username:password]