Can we partition a table in vertica? Ex: I need to partition employee table based on dept number. 1. i think, since vertica stores all the data of the table as columns under super projection and all the columns will be sorted. In this case do we need a partition? 2. Whenever a table is created and t...

I am getting the Duplicate Merge Key error but i checked my source and target table there are no duplicate records.

Thanks Jim...! that helped me to stop scratching my head..

Hi, So, If we need to do any complex operation we only have to go to C++ or Shell scripting? Say, i just want to get a Max(some_Column) based on a logic involving may table.. cant i write a SQL statement in the function and get the return value? or is there any work around for this? pls help... Than...

Hi, We have TRIGGERS in Oracle to handle the event based operations, Is there anything like that in Vertica? I read somewhere that Vertica doesnt have a Programming Language capablities like PL/SQL... in this case how can we achieve Trigger functionality here. Lets say i have a scenario that i am In...

Thanks Jim.

Hi,

I am looking for Hierarchical queries in Vertica that is equivalent to START With... and CONNECT By in ORACLE.

I referred in the SQL reference guide but couldn't get it, please share the knowledge.

Thanks,
Jagadeesh.