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?