The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
HTTP Export
Best Answer
-
Bryan_H Vertica Employee Administrator
There is not a built-in way to do this, but I can think of a few ways to implement:
Within Vertica, develop a UDTF that will send rows via HTTP POST. KafkaExport is itself a C++ UDTF. See documentation at https://docs.vertica.com/12.0.x/en/extending/developing-udxs/transform-functions-udtfs/
Outside Vertica, use command-line tools to run SQL and pipe to HTTP POST, e.g. vsql -c | curl -H "Content-Type: text/csv" -X POST --data-binary @- http://api
There may be third-party ETL or batch tools that can also push SQL results over HTTP POST.
You can also submit a feature request via support or your account team.0