I'm having trouble connecting to HBase from Pig's
HBaseStorage<http://pig.apache.org/docs/r0.12.0/api/org/apache/pig/backend/hadoop/hbase/HBaseStorage.html>
command.
Any help would be appreciated.
I'm running this command:
time_series = LOAD '/tmp/time_series.txt' AS (date_time:chararray,
time_series:chararray);
STORE time_series INTO 'hbase://bluecoat' USING
org.apache.pig.backend.hadoop.hbase.HBaseStorage('bytes_per_hour_time_series:series');
The output is thus:
2014-01-20 08:49:51,896 [main] INFO org.apache.zookeeper.ZooKeeper -
Client
environment:java.library.path=/Users/rjurney/Software/hadoop-1.0.3/libexec/../lib/native/Mac_OS_X-x86_64-64
2014-01-20 08:49:51,896 [main] INFO org.apache.zookeeper.ZooKeeper -
Client
environment:java.io.tmpdir=/var/folders/0b/74l_65015_5fcbmbdz1w2xl40000gn/T/
2014-01-20 08:49:51,896 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:java.compiler=<NA>
2014-01-20 08:49:51,896 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:os.name=Mac OS X
2014-01-20 08:49:51,897 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:os.arch=x86_64
2014-01-20 08:49:51,897 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:os.version=10.9
2014-01-20 08:49:51,897 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:user.name=rjurney
2014-01-20 08:49:51,897 [main] INFO org.apache.zookeeper.ZooKeeper -
Client environment:user.home=/Users/rjurney
2014-01-20 08:49:51,897 [main] INFO org.apache.zookeeper.ZooKeeper -
Client
environment:user.dir=/Users/rjurney/Software/steel-thread/pig/bluecoat
2014-01-20 08:49:51,899 [main] INFO org.apache.zookeeper.ZooKeeper -
Initiating client connection,
connectString=hiveapp2:2181,hiveapp1:2181,hiveapp3:2181
sessionTimeout=60000 watcher=hconnection
2014-01-20 08:49:51,926 [main] INFO
org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper - The identifier of
this process is 43006@Russells-MacBook-Pro.local
2014-01-20 08:49:52,993 [main-SendThread(hiveapp1:2181)] INFO
org.apache.zookeeper.ClientCnxn - Opening socket connection to server
hiveapp1/10.10.30.200:2181. Will not attempt to authenticate using SASL
(unknown error)
2014-01-20 08:49:53,000 [main-SendThread(hiveapp1:2181)] INFO
org.apache.zookeeper.ClientCnxn - Socket connection established to
hiveapp1/10.10.30.200:2181, initiating session
2014-01-20 08:49:53,030 [main-SendThread(hiveapp1:2181)] INFO
org.apache.zookeeper.ClientCnxn - Session establishment complete on server
hiveapp1/10.10.30.200:2181, sessionid = 0x34397f09f6c25aa, negotiated
timeout = 60000
2014-01-20 09:00:44,711 [main] ERROR
org.apache.hadoop.hbase.mapreduce.TableOutputFormat -
org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find
region for bluecoat,,99999999999999 after 10 tries.
2014-01-20 09:00:44,714 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 2999: Unexpected internal error.
org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find
region for bluecoat,,99999999999999 after 10 tries.
2014-01-20 09:00:44,714 [main] ERROR org.apache.pig.tools.grunt.Grunt -
java.lang.RuntimeException:
org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find
region for bluecoat,,99999999999999 after 10 tries.
at
org.apache.hadoop.hbase.mapreduce.TableOutputFormat.setConf(TableOutputFormat.java:206)
at
org.apache.pig.backend.hadoop.hbase.HBaseStorage.getOutputFormat(HBaseStorage.java:826)
at
org.apache.pig.newplan.logical.rules.InputOutputFileValidator$InputOutputFileVisitor.visit(InputOutputFileValidator.java:80)
at org.apache.pig.newplan.logical.relational.LOStore.accept(LOStore.java:66)
at
org.apache.pig.newplan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:64)
at
org.apache.pig.newplan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:66)
at
org.apache.pig.newplan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:66)
at org.apache.pig.newplan.DepthFirstWalker.walk(DepthFirstWalker.java:53)
at org.apache.pig.newplan.PlanVisitor.visit(PlanVisitor.java:52)
at
org.apache.pig.newplan.logical.rules.InputOutputFileValidator.validate(InputOutputFileValidator.java:45)
at
org.apache.pig.backend.hadoop.executionengine.HExecutionEngine.compile(HExecutionEngine.java:303)
at org.apache.pig.PigServer.compilePp(PigServer.java:1382)
at org.apache.pig.PigServer.executeCompiledLogicalPlan(PigServer.java:1307)
at org.apache.pig.PigServer.execute(PigServer.java:1299)
at org.apache.pig.PigServer.executeBatch(PigServer.java:377)
at org.apache.pig.PigServer.executeBatch(PigServer.java:355)
at org.apache.pig.tools.grunt.GruntParser.executeBatch(GruntParser.java:140)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:202)
at
org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:173)
at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:84)
at org.apache.pig.Main.run(Main.java:607)
at org.apache.pig.Main.main(Main.java:156)
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.main(RunJar.java:156)
Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException:
Unable to find region for bluecoat,,99999999999999 after 10 tries.
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:980)
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:885)
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:987)
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:889)
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:846)
at org.apache.hadoop.hbase.client.HTable.finishSetup(HTable.java:271)
at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:211)
at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:170)
at
org.apache.hadoop.hbase.mapreduce.TableOutputFormat.setConf(TableOutputFormat.java:201)
... 26 more
--
Russell Jurney twitter.com/rjurney russell.jur...@gmail.com datasyndrome.com
