Aggregate function in vertica .

dharmasis_panda

Can any one use the aggregate function in vertica query if not , how should we handle the aggregate function in vertica query . Please answer . Regards, Dharmasis

Daniel_Leybovic

Hi! >> Can any one use the aggregate function in vertica query if not No, Vertica doesn't have aggregate function >> how should we handle the aggregate function in vertica query I can only say what we do to solve it. We pray and dance around a fire. After it I load data to other database (like MySQL, PostgreSQL, Oracle,...) and do aggregation. One more time - prays and dance. And finally result of query I load back to Vertica. PS If you need some help with prays and dance - feel free to ask.

[Deleted User]

Ooh, dancing around fires! Praying over complex inter-database processes has never worked well for me, though; something always goes wrong anyway... Could you give an example of a query that works in MySQL (and not in Vertica), and what you're expecting the query to do? Vertica certainly supports aggregation in general; recent versions of Vertica also have an SDK API for defining new aggregation operators.

dharmasis_panda

Hi Adam, Great. Can you please post the new aggregation operators which have defined in SDK API in vertical. It will helpful for us . Regards, Dharmasis

[Deleted User]

Hi Dharmassis, The Vertica SDK documentation is here: https://my.vertica.com/docs/6.1.x/SDK/html/index.htm Look for the "AggregateFunction" and "AggregateFunctionFactory" classes. Note that this is our C++ SDK. It's NOT a SQL interface; it's a way for software developers to develop extensions to Vertica SQL. Vertica does have a lot of aggregation functionality already; it's very rare that people need to use this API. If you could give me more detail about what you're trying to do (an example query, a link to the documentation for one of the other databases that you listed, etc), I might be able to tell you how to do the same thing in Vertica without writing a new aggregate function. (If you are a developer and not just a SQL user, incidentally, I'd encourage you to periodically take a look at the SDK documentation to look for changes, particularly new additions. The Vertica 6.1 SDK is vastly more comprehensive than it was in, say, Vertica 5.1 a year or two ago.) Adam