incubator-hcatalog-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From atul aggarwal <>
Subject Accesing Views created in Hive using HCatLoader in Pig
Date Tue, 05 Mar 2013 00:36:40 GMT

I am fairly new to HCatlog, and hence I was just trying something in hive
and HcatLoader in Pig. What I did is, created a view in Hive and then tried
to load data by view I created into pig using HcatLoader. But it seems it
is not working. I just wanted to confirm that is there any way to do this?
I am getting following error when I tried to load view in pig using

events=Load 'ViewName' using org.apache.hcatalog.pig.HCatLoader(); dump

When I use any tableName instead of View from Hive, it seems to work.
Further it does not give metastore error. As it says successfully connected
to metastore at load statement when it comes to dump, it crashes with the
following error.

Any Pointers will be helpful.

Thanks, Atul

org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1066: Unable
to open iterator for alias events
at org.apache.pig.PigServer.openIterator(
at org.apache.pig.Main.main(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.apache.hadoop.util.RunJar.main(
Caused by: org.apache.pig.PigException: ERROR 1002: Unable to store alias events
at org.apache.pig.PigServer.storeEx(
at org.apache.pig.PigServer.openIterator(
... 12 more
Caused by: org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobCreationException:
ERROR 2017: Internal error creating job configuration.
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.getJob(
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.compile(
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher.launchPig(
at org.apache.pig.PigServer.launchPlan(
at org.apache.pig.PigServer.executeCompiledLogicalPlan(
at org.apache.pig.PigServer.storeEx(

View raw message