Search found 10 matches
- Sun Dec 15, 2013 6:21 am
- Forum: Vertica Migration
- Topic: Conversion of OCI code to Vertica
- Replies: 0
- Views: 12622
Conversion of OCI code to Vertica
What is the best way to migrate Oracle OCI code to Vertica?
- Wed Sep 25, 2013 12:01 am
- Forum: Vertica Data Load
- Topic: Disk space requirements
- Replies: 6
- Views: 10440
Re: Disk space requirements
Thanks, Skwa! I will try to contact a HP sales person.
- Mon Sep 23, 2013 7:13 pm
- Forum: Vertica Data Load
- Topic: Disk space requirements
- Replies: 6
- Views: 10440
Disk space requirements
Are there any benchmarks for how much disk space is required in Vertica for say 10TB data?
- Fri Aug 23, 2013 6:53 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: Performing SQL Queries in UDFs
- Replies: 1
- Views: 14017
Performing SQL Queries in UDFs
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...
- Tue Aug 06, 2013 7:29 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: UDF CsvParser can't load Date
- Replies: 8
- Views: 32746
Re: UDF CsvParser can't load Date
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.
- Tue Aug 06, 2013 7:27 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: UDF CsvParser can't load Date
- Replies: 8
- Views: 32746
Re: UDF CsvParser can't load Date
My delimiter is comma and trying to loan a csv file.
- Tue Aug 06, 2013 5:36 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: UDF CsvParser can't load Date
- Replies: 8
- Views: 32746
Re: UDF CsvParser can't load Date
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...