ankit-rakha

check the SSH configuration file (in most cases /etc/ssh/sshd_config) and make sure the following line is present and not commented out:

Subsystem sftp /usr/lib/openssh/sftp-server

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

ankit-rakha

cd /tmp/
curl -O https://bootstrap.pypa.io/get-pip.py
python get-pip.py
pip install awscli
pip install --upgrade awscli