example/copy.rb in jvertica-0.1.10 vs example/copy.rb in jvertica-0.1.11
- old
+ new
@@ -14,11 +14,10 @@
password: ENV['PASSWORD'],
}
puts params
vertica = Jvertica.connect(params)
-vertica.query("DROP TABLE sandbox.jvertica_test") rescue nil
-vertica.query("CREATE TABLE sandbox.jvertica_test (id integer, str varchar(80))")
+vertica.query("CREATE TABLE IF NOT EXISTS sandbox.jvertica_test (id integer, str varchar(80))")
vertica.copy("COPY sandbox.jvertica_test FROM STDIN PARSER fjsonparser() NO COMMIT") do |io|
File.open(File.expand_path('../data.json', __FILE__), 'r') do |f|
begin
io << f.gets
end until f.eof?