You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@pig.apache.org by Noam Lavie <No...@pontis.com> on 2014/03/04 00:00:42 UTC
load a hive table from pig
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(PigScriptParser.java:412)
at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:194)
at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:170)
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(DelegatingMethodAccessorImpl.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?
Re: load a hive table from pig
Posted by Ankit Bhatnagar <an...@yahoo-inc.com>.
Use
LOAD '$HIVEDB.$TABLENAME' USING org.apache.hcatalog.pig.HCatLoader();
On 3/3/14 3:00 PM, "Noam Lavie" <No...@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?