Cockroach database

Start single instance

cockroach start --insecure --host=localhost --http-port=8181 --cache=.25 --max-sql-memory=.25

or

sudo cockroach start --insecure --host=0.0.0.0 --max-sql-memory=25% --cache=50%

Create database

cockroach sql --insecure --database=nifi -e 'CREATE database nifi'

Create table

cockroach sql --insecure --database=nifi -e 'CREATE TABLE Kafka
(
JSONAttributes TEXT,
filename TEXT,
hoedanigheden TEXT,
kafkaOffset INT,
kafkaPartition INT,
kafkaTopic TEXT,
path TEXT,
registratieIdentificatie TEXT,
size INT,
uuid TEXT,
voorvalIdentificatie TEXT
)'

 

Start SQL client

cockroach sql --insecure --port=26257