The script looks like this
tempReps = Load '/discovery/hbid_crd.csv' USING PigStorage(',');
STORE tempReps INTO '{hbid(HBID varchar, CRD_ID varchar, PROSPECT_IND varchar, STATUS_CODE varchar)}' USING com.vertica.pig.VerticaStorer('ipaddress', 'database','5433','user','password');