Jvertica
jvertica presents wrapper methods of jdbc-vertica java native methods.
Installation
Add this line to your application's Gemfile:
gem 'jvertica'And then execute:
$ bundle
Or install it yourself as:
$ gem install jvertica
Usage
require 'jvertica'
params = {
host: 'vertica.com',
port: 5433,
user: 'xxxxxx',
password: 'xxxxxx',
}
sql = 'select * from sandbox.jdbc_tests;'
c = Jvertica.connect(params)
c.query(sql) do |row|
p row
endConnection Options
see the url
Loading data into Vertica using COPY
connection.copy("COPY table FROM STDIN ...") do |stdin|
File.open('data.tsv', 'r') do |f|
begin
stdin << f.gets
end until f.eof?
end
endContributing
- Fork it ( https://github.com/[my-github-username]/jvertica/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create a new Pull Request