search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

PhoenixHBaseStorage having 'Relative path in absolute URI:' error. #726

Open sterrell opened 10 years ago

sterrell commented 10 years ago

I've been trying to get around this error for hours. Am I doing something wrong, or is this a bug? Phoenix is working fine with our Hbase until I try to use the Pig store func.

As I understand it, the hbase:// prefix is required. However, Pig (or Hadoop?) apparently wants to append "_logs" to the end of the table name and create a directory with the new name, which it can't do because of the colon (:) character.

Thanks!

Versions: Phoenix: 3.0.0-incubating Hadoop: 2.2.0 HBase: 0.94.7 Pig: 0.11.1.1

My Pig script:

A = load 'input' using PigStorage(',') as (data:chararray);
STORE A into 'hbase://STERRELL_TEST' using org.apache.phoenix.pig.PhoenixHBaseStorage('localhost','-batchSize 1000');

Tail end of output:

2014-04-11 22:16:54,738 [main] INFO  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - jar file Job3553321915310880408.jar created
2014-04-11 22:16:54,738 [main] INFO  org.apache.hadoop.conf.Configuration.deprecation - mapred.jar is deprecated. Instead, use mapreduce.job.jar
2014-04-11 22:16:54,779 [main] INFO  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - Setting up single store job
2014-04-11 22:16:54,783 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2017: Internal error creating job configuration.
Details at logfile: /mnt/var/log/apps/pig.log

Tail end of pig.log:

Caused by: java.net.URISyntaxException: Relative path in absolute URI: hbase://STERRELL_TEST_logs
        at java.net.URI.checkPath(URI.java:1804)
        at java.net.URI.<init>(URI.java:752)
        at org.apache.hadoop.fs.Path.initialize(Path.java:203)
        ... 20 more
jtaylor-sfdc commented 10 years ago

Hi, Phoenix moved from GitHub to Apache about 4mo back. If you subscribe to the new mailing list: user-subscribe@phoenix.incubator.apache.org and repost your question, I'm sure you'll get an answer. Please make sure to include the version of Phoenix and HBase you're using. Thanks, James

On Fri, Apr 11, 2014 at 3:36 PM, sterrell notifications@github.com wrote:

I've been trying to get around this error for hours. Am I doing something wrong, or is this a bug? Phoenix is working fine with our Hbase until I try to use the Pig store func.

As I understand it, the hbase:// prefix is required. However, Pig (or Hadoop?) apparently wants to append "_logs" to the end of the table name and create a directory with the new name, which it can't do because of the colon (:) character.

Thanks!

Versions: Phoenix: 3.0.0-incubating Hadoop: 2.2.0 HBase: 0.94.7 Pig: 0.11.1.1

My Pig script:

A = load 'input' using PigStorage(',') as (data:chararray); STORE A into 'hbase://STERRELL_TEST' using org.apache.phoenix.pig.PhoenixHBaseStorage('localhost','-batchSize 1000');

Tail end of output:

2014-04-11 22:16:54,738 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - jar file Job3553321915310880408.jar created 2014-04-11 22:16:54,738 [main] INFO org.apache.hadoop.conf.Configuration.deprecation - mapred.jar is deprecated. Instead, use mapreduce.job.jar 2014-04-11 22:16:54,779 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - Setting up single store job 2014-04-11 22:16:54,783 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2017: Internal error creating job configuration. Details at logfile: /mnt/var/log/apps/pig.log

Tail end of pig.log:

Caused by: java.net.URISyntaxException: Relative path in absolute URI: hbase://STERRELL_TEST_logs at java.net.URI.checkPath(URI.java:1804) at java.net.URI.(URI.java:752) at org.apache.hadoop.fs.Path.initialize(Path.java:203) ... 20 more

Reply to this email directly or view it on GitHubhttps://github.com/forcedotcom/phoenix/issues/726 .