Search found 7 matches

by abeeshdreams
Wed May 29, 2013 7:08 am
Forum: Vertica Tips, Lessons and Examples
Topic: No Super projection found !!!
Replies: 1
Views: 15607

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...
by abeeshdreams
Thu Nov 22, 2012 7:44 am
Forum: Vertica Analytics
Topic: Any default function for finding hierarchies ?
Replies: 2
Views: 21417

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|...
by abeeshdreams
Fri Nov 16, 2012 11:19 am
Forum: Vertica SQL
Topic: De-Duplication in Vertica
Replies: 16
Views: 35122

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...
by abeeshdreams
Mon Oct 29, 2012 10:25 am
Forum: ODBC
Topic: ODBC connection overhead
Replies: 3
Views: 18725

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 --------------------------------------------------------------------------------------------------------...
by abeeshdreams
Thu Oct 25, 2012 5:52 am
Forum: ODBC
Topic: ODBC connection overhead
Replies: 3
Views: 18725

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...
by abeeshdreams
Wed Jul 25, 2012 9:39 am
Forum: New to Vertica Database Development
Topic: Db links in Vertica?
Replies: 9
Views: 47630

Re: Db links in Vertica?

Thanks a lot knicely87. That helped :)
by abeeshdreams
Wed Jul 18, 2012 11:06 am
Forum: New to Vertica Database Development
Topic: Db links in Vertica?
Replies: 9
Views: 47630

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? :)

Go to advanced search