I'm on CDH 4.4, so it is HBase 0.94.6.
On Mon, Jan 20, 2014 at 9:31 AM, Fernando Iwamoto - Plannej < [email protected]> wrote: > What kind of HBase and Pig version are you using? I'm having the same > problem as you. > > > 2014/1/20 Russell Jurney <[email protected]> > > > 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 [email protected] > > 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 [email protected] > > datasyndrome.com > > > -- Russell Jurney twitter.com/rjurney [email protected] datasyndrome.com
