Search found 7 matches
- Wed May 29, 2013 7:08 am
- Forum: Vertica Tips, Lessons and Examples
- Topic: No Super projection found !!!
- Replies: 1
- Views: 15761
No Super projection found !!!
Hi Guys, I'm getting a error stating "No super projection found" when i try to load data using ETL tool (datastage) into a newly created table in vertica. It's weird as vertica is expected to create a super projection when we create a table, (or to be more precise) when we insert the first record in...
- Thu Nov 22, 2012 7:44 am
- Forum: Vertica Analytics
- Topic: Any default function for finding hierarchies ?
- Replies: 2
- Views: 21614
Any default function for finding hierarchies ?
Hi Guys, Is there any default recursive function in vertica like sys_connect_by_path in Oracle for finding the hierarchy? Is there any way to get the hierarchy in the same table other than using UDF? My requirement is like this. I have a table as below. Table X A | B|C 1 | 5|aa 3 | 4|gh 5 | 7 |rg 4|...
- Fri Nov 16, 2012 11:19 am
- Forum: Vertica SQL
- Topic: De-Duplication in Vertica
- Replies: 16
- Views: 35266
Re: De-Duplication in Vertica
@scutter That was a good one! But the epoch is set for every commit performed. So if you are loading a table using a ETL tool with commit interval as 10k, all the duplicates in that 10k will have the same epoch time. So epoch wont be of much help in such a scenario. Now consider a scenario of 10k re...
- Mon Oct 29, 2012 10:25 am
- Forum: ODBC
- Topic: ODBC connection overhead
- Replies: 3
- Views: 18905
Re: ODBC connection overhead
Have checked for the resource pool setting. Its the same as that of "dbadmin" except for 'is super user' user_name | is_super_user| resource_pool| memory_cap_kb | temp_space_cap_kb| run_time_cap --------------------------------------------------------------------------------------------------------...
- Thu Oct 25, 2012 5:52 am
- Forum: ODBC
- Topic: ODBC connection overhead
- Replies: 3
- Views: 18905
ODBC connection overhead
We are using datastage 8.7 and Vertica 6.0 and ODBC 3.5 driver to connect to Vertica. We had excellent query performance when we were initially using dbadmin as user. But when we switched to another user with all the required privileges it takes a ton of time to connect and generate Insert/Update st...
- Wed Jul 25, 2012 9:39 am
- Forum: New to Vertica Database Development
- Topic: Db links in Vertica?
- Replies: 9
- Views: 47956
Re: Db links in Vertica?
Thanks a lot knicely87. That helped
- Wed Jul 18, 2012 11:06 am
- Forum: New to Vertica Database Development
- Topic: Db links in Vertica?
- Replies: 9
- Views: 47956
Db links in Vertica?
I'm a newbie. I would like to know if there is any concept like "db link" available in Vertica ? If not can anyone please teach me how to inter connect two db's in Vertica?