How to dump data from a table using jdbc locally.

Siddarth

Need to dump records from Vertica tables using jdbc connection on local machine from where we have setup a jdbc connection.

[Deleted User]

Hi Siddarth,

This is typically done in two parts.

First, it is very easy to retrieve a recordset from Vertica -- just run a SELECT statement.

Once you have the recordset, if you do a Web search for "jdbc to file", you will find many packages that will take that recordset and directly export it to a file in any of a variety of different formats.

There's an example on the CsvJdbc homepage:
http://csvjdbc.sourceforge.net/

Adam

Siddarth

Hi Adam,

My requirement is that I have a Vertica running on server-1 and jdbc job running on server-2.

Now I want to dump data from Vertica tables in Server-1 to Server-2 using my jdbc client application.

Thanks
Siddarth

[Deleted User]

Great!  The above example will work perfectly for that use case.

If you have a different use case, feel free to clarify and/or re-post.

Siddarth

Thanks a lot Adam!!

I will explore this further.