Search found 2 matches
- Thu Apr 04, 2013 6:57 pm
- Forum: Python
- Topic: date expression in python to load into vertica
- Replies: 0
- Views: 12847
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...
- Wed Apr 03, 2013 8:05 pm
- Forum: Vertica Data Load
- Topic: Loading data into Vertica database from a file
- Replies: 17
- Views: 35216
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 ...