What is the best way to migrate Oracle OCI code to Vertica?

Thanks, Skwa! I will try to contact a HP sales person.

Are there any benchmarks for how much disk space is required in Vertica for say 10TB data?

Can queries like these be performed in UDFs to make the execution faster? vsql -d VMart_Schema -w ${DB_PASSWD} -c "INSERT INTO GL.CURRENCYTABLE (CURRENCY_CODE, PERIOD_YEAR, BEGIN_BALANCE_DR,INDIAN_CURRENCY) SELECT CURRENCY_CODE, PERIOD_YEAR, BEGIN_BALANCE_DR, (CASE WHEN CURRENCY_CODE = 'GBP' THEN BE...

From the error log, it seems like it has newline character as part of the value for the last column and that is why it can't convert the string to numeric value and returns error.

My delimiter is comma and trying to loan a csv file.

Need help with CSVParser - If I change the format of the date to 10/1/2013, it works fine for small loads, but for bigger loads, it fails at last column. This is the error it logs in error.log. COPY: Input record 1 has been rejected (Invalid column: name=PROJECT_TO_DATE_CR_BEQ, index=37, length=1,ty...