renbright

KDB WORM (Write once and read many) function

by renbright
on ‎2022.09.29 01:52 PM

I’m wondering if KDB has WORM (Write once and read many) function. We are trying to see if KDB can be used for some reporting purposes.  We would like to have some table read/write and some table read only after write. Is that possible?

0
1
17,219
Ali99947

How do I get the .s.e sql interface on the command line?

by Ali99947
on ‎2022.09.11 02:00 PM

I have downloaded the on-demand 64bit version of kdb. I launch the kdb+ as follows: C:\q\w64\q.exe Then I create a simple table as follows: t:([]k: 1 2 1; v:`A`B`C) Then when I try to query it using the SQL interface as follows, I get the error: .s.e"SELECT * FROM t" '.s.e [3] .s.e"SELECT * FROM t" The command is not recognized. How do I make it work?

0
1
20,250
mumfordg

server options

by mumfordg
on ‎2022.07.27 08:55 AM

We currently run straight kdb 4.0 and want to test how our system  will run on kx insights. We desire to test on an "on prem" server - if we just test kdb 4.1 on an on prem server will the behavior be identical to a standard kx insights installed system?

0
1
26,992
cyhuang

Could not load list columns from S3

by cyhuang
on ‎2022.07.05 11:37 AM

We are storing data in S3 bucket. While we are able to load most of the tables, whenever there is a column of the type list or string, the table couldn't load properly. When the column is a string say OrderID, it will have two files ID and ID#. when loading data locally it works ok, but it will complain about ID## when loading from s3. Does anyone know how to resolve this? 

0
1
30,144
cyhuang

How to install kxreaper?

by cyhuang
on ‎2022.07.04 10:35 AM

We've using the KX insight on AWS cloud. When we are trying to set up the caching for HDB, it couldnt find kxreaper. Wondering what would be the right way to set it up?  

0
3
30,138