Description
The kdb+ time-series database is at the forefront of high-performance streaming, real-time and historical analytics. Its unified, elegant q language includes first-class tables, functions and time-series features. Its tiny footprint efficiently scales vertically and horizontally. High precision nanosecond timestamps, time ordered querying, coupled with time-based table joins of unparalleled speed, allows kdb+ to stand alone in time-series analytics.
To find out more about kdb+ and how to get support, visit https://code.kx.com/q/
By using this product you agree to the Red Hat subscription agreement and you have confirmed your acceptance of the terms and conditions of the following software license(s): https://ondemand.kx.com/
Once you have registered for your Kx license, populate your name as KX_LIC_USER and email address as KX_LIC_EMAIL in the pod spec as follows
Example POD Spec
apiVersion: v1
kind: Pod
metadata:
name: kdb-openshift
spec:
containers:
- name: kdb
image: registry.connect.redhat.com/kx/kdb
env:
- name: KX_LIC_USER
value: "JohnSmith"
- name: KX_LIC_EMAIL
value: "john.smith@kx.com"
Connecting to the Kdb+ Container
To login with a q prompt
$ oc exec -it kdb q
To login with a bash prompt
$ oc exec -it kdb /bin/bash
[kx@kdb ~]$
Then run q
[kx@kdb ~]$ q
KDB+ 4.0 2020.11.27 Copyright (C) 1993-2020 Kx Systems
l64/ 4()core 8978MB kx kdb 10.116.0.112 EXPIRE 2021.11.30
q)
Docker
docker run -it -e KX_LIC_USER='JohnSmith' -e KX_LIC_EMAIL='john.smith@kx.com' registry.connect.redhat.com/kx/kdb
Encryption
To create an encryption key, run the following
$ openssl rand 32 | openssl aes-256-cbc -md SHA256 -salt -pbkdf2 -iter 50000 -out testkey.key
When prompted, enter the encryption password.
Next, open q prompt and set encryption key and password
q) -36!(`:testkey.key;"pw1234")
Encrypt a file called etest
q) (`:etest;17;16;6) set asc 10000?`3
Compression
Compress a file called ctest
q) (`:ctest;17;2;6) set asc 10000?`3
Compression and Encryption
Compress and encrypt a file called cetest
q) (`:cetest;17;2+16;6) set asc 10000?`3
Or use .z.zd for process-wide default setting for all qualifying files.
q) .z.zd:(17;2+16;6) / zlib compression, with aes256cbc encryption.
