We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Modular quering — Vertica Forum

Modular quering

Hi everybody,

I want to make my queries more modular. I have a query with parameters that I want to use in other queries. Moreover I want to let people work on the first query (change the calculations inside and keep the "interface") while I'm working on the derived ones.

So I need something like view with parameters. In sql server it could be implemented as table-valued function or stored procedure.

Is there any way to do it in Vertica?

Comments

  • This is a bit hacky, but you could create a java transform UDF with defined inputs. That java UDF builds a SQL string based on the inputs, connects back to Vertica over JDBC (inside the UDF), and return results as a table from the UDF.

Leave a Comment

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