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!
How to write into Vertica from pig with pig-connector ?
Hello, I'm trying to write into Vertica from a pig script using pig-connector with following pig's latin:
STORE A INTO '{SCHEMA.TABLE}' USING com.vertica.pig.VerticaStorer('SRV1', 'DBNAME', '5433', 'USER', 'PASSWD');SCHEMA.TABLE do already exists, but I get an error:
ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2999: Unexpected internal error. java.lang.RuntimeException: Table SCHEMA.TABLE does not exist and no table definition providedIf I add table's definition, here's the error I got:
ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2999: Unexpected internal error. java.sql.SQLException: [Vertica][VJDBC](4213) ROLLBACK: Object "TABLE" already existsSo, who is right ? and who's wrong ? Could TABLE both exists and not exists ? Is Vertica "quantum computing" ready ?

0
Comments