Use LOAD '$HIVEDB.$TABLENAME' USING org.apache.hcatalog.pig.HCatLoader();
On 3/3/14 3:00 PM, "Noam Lavie" <noam.la...@pontis.com> wrote: >Hi. > >I'm trying to load a hive table from pig: > >REGISTER /opt/mapr/pig/pig-0.11/contrib/piggybank/java/piggybank.jar >REGISTER /opt/mapr/hive/hive-0.12/lib/hive-common-0.12-mapr-1311.jar >REGISTER /opt/mapr/hive/hive-0.12/lib/hive-exec-0.12-mapr-1311.jar > >a = LOAD 'maprfs:/hive/DWH/dudy_analytics.db/subscriber_profile_panel_ge' >USING org.apache.pig.piggybank.storage.HiveColumnarLoader(); > >and I'm getting the following error massage: >pig script failed to validate: java.lang.RuntimeException: could not >instantiate 'org.apache.pig.piggybank.storage.HiveColumnarLoader' with >arguments 'null' > >and the log file: > >ERROR 1200: <line 5, column 133> mismatched input 'a' expecting >RIGHT_PAREN > >Failed to parse: <line 5, column 133> mismatched input 'a' expecting >RIGHT_PAREN > at >org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:235) > at >org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:177) > at >org.apache.pig.PigServer$Graph.validateQuery(PigServer.java:1571) > at >org.apache.pig.PigServer$Graph.registerQuery(PigServer.java:1544) > at >org.apache.pig.PigServer.registerQuery(PigServer.java:516) > at >org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:991) > at >org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParse >r.java:412) > at >org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:1 >94) > at >org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:1 >70) > at org.apache.pig.tools.grunt.Grunt.run(Grunt.java:69) > at org.apache.pig.Main.run(Main.java:538) > at org.apache.pig.Main.main(Main.java:157) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >Method) > at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: >57) > at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm >pl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.apache.hadoop.util.RunJar.main(RunJar.java:197) > >someone knows what is the problem?