ondrej-kvasnovsky

-- 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

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

#!/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