Testing create table patients(patient_id int, pname varchar(50), visit_id int, year int); create table visits(patient_id int, visit varchar(50), visit_id int, year int); create table treatments(patient_id int, treatment varchar(50), visit_id int, year int); insert into patients values(1,'Adam',10,2021); insert into visits…
This image is from production
I am using vkconfig to stream data from my kafka topics, if I manually copy my timestamps that I already have in my kafka streams they get added to vertica with the same value, but when I use vkconfig to do this all my timestamps change to UTC, how can I configure vkconfig to not do this or to take my time zone?
Hello! I am doing some tests on a datamart whose data is loaded through Pentaho. Loading is done through inserts with commit every 10.000 rows. Loading always crashes with this error: Caused by: java.sql.SQLTransientException: [Vertica]VJDBC ERROR: Too many ROS containers exist for the following projections: 2020/10/07…
Hi all, A basic question regarding variable interpolation in the vsql client - how can it be done within strings? For example: The intent for the second command is to interpolate schemaname into the string being passed in to analyze_statistics. I've tried various forms of syntax, but without success. Thanks.
Difference between questions and discussions? Worth it?
It looks like you're new here. Sign in or register to get started.