Search found 2 matches

by psunkara
Thu Apr 04, 2013 6:57 pm
Forum: Python
Topic: date expression in python to load into vertica
Replies: 0
Views: 1380

date expression in python to load into vertica

Hi, Iam trying to update a vertica database table using python script. One of the input date column is in datatype int and need to converted to datatype date. I tried some convertion functions like datetime.strtp, time.strtp but nothing worked. Iam using python 2.4 version and it doesnt have strtp i...
by psunkara
Wed Apr 03, 2013 8:05 pm
Forum: Vertica Data Load
Topic: Loading data into Vertica database from a file
Replies: 17
Views: 9574

Loading data into Vertica database from a file

Hi, I'am new to Vertica , trying to load data into vertica database from a | delimited file but it throws me the error below. I have defined the datatype for trans_gen_key as Bigint(19) but not sure some records are getting loaded fine but some are getting rejected. Can anyone please advise. Thanks ...

Go to advanced search