The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Aggregate function in vertica .

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

Comments

  • 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.
  • 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.
  • 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
  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.