Hi,
I am trying to store the Pig output data to Oracle.
Script :
REGISTER /TestDivya/Pig/piggybank-0.15.0.jar ;
A = LOAD '/tmp/TestDivya/Pig/PigTest.txt' using PigStorage(',') as (name:
chararray, age: int);
STORE A INTO 'dummy' using
org.apache.pig.piggybank.storage.DBStorage('oracle.jdbc.driver.OracleDriver',
'jdbc:oracle://xx.xxx.xxx.xxx:1521', 'database_name', 'database_password',
'INSERT INTO Test)');
Already created a Test Table in Oracle.
Error :
2016-01-20 03:59:57,971 [main] ERROR
org.apache.pig.piggybank.storage.DBStorage - can't load DB
driver:oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at org.apache.pig.piggybank.storage.DBStorage.<init>(DBStorage.java:79)
at org.apache.pig.piggybank.storage.DBStorage.<init>(DBStorage.java:71)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at
org.apache.pig.impl.PigContext.instantiateFuncFromSpec(PigContext.java:740)
at
org.apache.pig.parser.LogicalPlanBuilder.buildStoreOp(LogicalPlanBuilder.java:988)
at
org.apache.pig.parser.LogicalPlanGenerator.store_clause(LogicalPlanGenerator.java:7806)
at
org.apache.pig.parser.LogicalPlanGenerator.op_clause(LogicalPlanGenerator.java:1669)
at
org.apache.pig.parser.LogicalPlanGenerator.general_statement(LogicalPlanGenerator.java:1102)
at
org.apache.pig.parser.LogicalPlanGenerator.statement(LogicalPlanGenerator.java:560)
at
org.apache.pig.parser.LogicalPlanGenerator.query(LogicalPlanGenerator.java:421)
at
org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:191)
at org.apache.pig.PigServer$Graph.parseQuery(PigServer.java:1776)
at org.apache.pig.PigServer$Graph.access$000(PigServer.java:1484)
at org.apache.pig.PigServer.parseAndBuild(PigServer.java:428)
at org.apache.pig.PigServer.executeBatch(PigServer.java:453)
at org.apache.pig.PigServer.executeBatch(PigServer.java:439)
at
org.apache.pig.tools.grunt.GruntParser.executeBatch(GruntParser.java:171)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:234)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:205)
at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:81)
at org.apache.pig.Main.run(Main.java:502)
at org.apache.pig.Main.main(Main.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
2016-01-20 03:59:57,975 [main] ERROR org.apache.pig.PigServer -
exception during parsing: Error during parsing. Pig script failed to
parse:
<file script.pig, line 3, column 0> pig script failed to validate:
java.lang.RuntimeException: could not instantiate
'org.apache.pig.piggybank.storage.DBStorage' with arguments
'[oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@54.254.166.90:1521:ORCL, riskinsightengine, rie,
insert into TEST]'
Failed to parse: Pig script failed to parse:
<file script.pig, line 3, column 0> pig script failed to validate:
java.lang.RuntimeException: could not instantiate
'org.apache.pig.piggybank.storage.DBStorage' with arguments
'[oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@54.254.166.90:1521:ORCL, riskinsightengine, rie,
insert into TEST]'
at
org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:199)
at org.apache.pig.PigServer$Graph.parseQuery(PigServer.java:1776)
at org.apache.pig.PigServer$Graph.access$000(PigServer.java:1484)
at org.apache.pig.PigServer.parseAndBuild(PigServer.java:428)
at org.apache.pig.PigServer.executeBatch(PigServer.java:453)
at org.apache.pig.PigServer.executeBatch(PigServer.java:439)
at
org.apache.pig.tools.grunt.GruntParser.executeBatch(GruntParser.java:171)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:234)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:205)
at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:81)
at org.apache.pig.Main.run(Main.java:502)
at org.apache.pig.Main.main(Main.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by:
<file script.pig, line 3, column 0> pig script failed to validate:
java.lang.RuntimeException: could not instantiate
'org.apache.pig.piggybank.storage.DBStorage' with arguments
'[oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@54.254.166.90:1521:ORCL, riskinsightengine, rie,
insert into TEST]'
at
org.apache.pig.parser.LogicalPlanBuilder.buildStoreOp(LogicalPlanBuilder.java:1009)
at
org.apache.pig.parser.LogicalPlanGenerator.store_clause(LogicalPlanGenerator.java:7806)
at
org.apache.pig.parser.LogicalPlanGenerator.op_clause(LogicalPlanGenerator.java:1669)
at
org.apache.pig.parser.LogicalPlanGenerator.general_statement(LogicalPlanGenerator.java:1102)
at
org.apache.pig.parser.LogicalPlanGenerator.statement(LogicalPlanGenerator.java:560)
at
org.apache.pig.parser.LogicalPlanGenerator.query(LogicalPlanGenerator.java:421)
at
org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:191)
... 17 more
Caused by: java.lang.RuntimeException: could not instantiate
'org.apache.pig.piggybank.storage.DBStorage' with arguments
'[oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@54.254.166.90:1521:ORCL, riskinsightengine, rie,
insert into TEST]'
at
org.apache.pig.impl.PigContext.instantiateFuncFromSpec(PigContext.java:772)
at
org.apache.pig.parser.LogicalPlanBuilder.buildStoreOp(LogicalPlanBuilder.java:988)
... 23 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at
org.apache.pig.impl.PigContext.instantiateFuncFromSpec(PigContext.java:740)
... 24 more
Caused by: java.lang.RuntimeException: Can't load DB Driver
at org.apache.pig.piggybank.storage.DBStorage.<init>(DBStorage.java:82)
at org.apache.pig.piggybank.storage.DBStorage.<init>(DBStorage.java:71)
... 29 more
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at org.apache.pig.piggybank.storage.DBStorage.<init>(DBStorage.java:79)
