Skip to content

Instantly share code, notes, and snippets.

@ondrej-kvasnovsky
ondrej-kvasnovsky / vertica-commands
Last active July 31, 2018 10:30
Vertica commands
-- login to vsql
vsql -Ulogin -wpassword
-- number of running processes
ps -ef | grep -i vertica-udx-R | wc -l
-- list all nodes thet are UP
admintools -t list_allnodes | grep UP
-- restart a node
@ankit-rakha
ankit-rakha / vertica_copy_command
Last active August 29, 2015 14:06
Vertica COPY command to load data
A Vertica COPY command to load data into the public.dummyTable table from data file dummyTable.psv, which is delimited with a "|" and all exceptions and rejected records are written into the specified log - dummyTable.exceptions & dummyTable.rejections respectively, and the DIRECT option loads data directly into the ROS.
COPY public.dummyTable FROM '/home/dummyTable/dummyTable.psv' DELIMITER '|' EXCEPTIONS '/home/dummyTable/dummyTable.exceptions' REJECTED DATA '/home/dummyTable/dummyTable.rejections' DIRECT NULL '';
@earino
earino / vertica.sh
Last active August 29, 2023 01:55
vertica on digitalocean
#!/bin/bash
echo deadline > /sys/block/vda/queue/scheduler
echo deadline > /sys/block/vda/queue/scheduler
echo 'echo deadline > /sys/block/vda/queue/scheduler' >> /etc/rc.local
/sbin/blockdev --setra 2048 /dev/vda
echo '/sbin/blockdev --setra 2048 /dev/vda' >> /etc/rc.local
sudo dd if=/dev/zero of=/swapfile bs=1k count=2048k