phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddhi Mehta <sm26...@gmail.com>
Subject URIException with PhoenixHBaseLoader
Date Mon, 27 Jun 2016 19:14:22 GMT
Hello All,

I am getting a URISyntaxException when I try to execute my pig script using
PHoenixHBaseLoader. Traced attached below.
Looking through the code Pig splits multiple paths provided to it based on
comma(',') and during the query parsing step
QueryParserUtils.setHdfsServers(absolutePath, pigContext) tried to split
paths based on comma(',') and create URI's/PATHS for the same.

Certain loaders like 'PhoenixHBaseLoader' donot pass hdfs locations and
instead work with passing PhoenixQueryStatement in the location.
e.g.
*A = load 'hbase://query/SELECT ID,NAME,DATE FROM HIRES WHERE DATE >
TO_DATE('1990-12-21 05:55:00.000')*

This locations needs not be parsed to get hdfsservers path from them.
Does it make sense to introduce a config/loader property to annotate if the
loader/store is dealing with hdfs locations and based on the property make
a function call to  QueryParserUtils.setHdfsServers(absolutePath,
pigContext).

*Thoughts?*

***** Stack trace *****

Caused by: Failed to parse: Pig script failed to parse:
<line 1, column 23> pig script failed to validate:
java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative
path in absolute URI: CREATED_DATE FROM HIRES WHERE
CREATED_DATE>=TO_DATE('1990-12-21
05:55:00.000')%20AND%20CREATED_DATE%3CTO_DATE('2016-03-08%2008:00:00.000')
    at
org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:199)
    at org.apache.pig.PigServer$Graph.parseQuery(PigServer.java:1712)
    ... 30 more
Caused by:
<line 1, column 23> pig script failed to validate:
java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative
path in absolute URI: CREATED_DATE FROM HIRES WHERE
CREATED_DATE>=TO_DATE('1990-12-21
05:55:00.000')%20AND%20CREATED_DATE%3CTO_DATE('2016-03-08%2008:00:00.000')
    at
org.apache.pig.parser.LogicalPlanBuilder.buildLoadOp(LogicalPlanBuilder.java:897)
    at
org.apache.pig.parser.LogicalPlanGenerator.load_clause(LogicalPlanGenerator.java:3568)
    at
org.apache.pig.parser.LogicalPlanGenerator.op_clause(LogicalPlanGenerator.java:1625)
    at
org.apache.pig.parser.LogicalPlanGenerator.general_statement(LogicalPlanGenerator.java:1102)
    at
org.apache.pig.parser.LogicalPlanGenerator.statement(LogicalPlanGenerator.java:560)
    at
org.apache.pig.parser.LogicalPlanGenerator.query(LogicalPlanGenerator.java:421)
    at
org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:191)
    ... 31 more
Caused by: java.lang.IllegalArgumentException: java.net.URISyntaxException:
Relative path in absolute URI: CREATED_DATE FROM HIRES WHERE
CREATED_DATE>=TO_DATE('1990-12-21
05:55:00.000')%20AND%20CREATED_DATE%3CTO_DATE('2016-03-08%2008:00:00.000')
    at org.apache.hadoop.fs.Path.initialize(Path.java:206)
    at org.apache.hadoop.fs.Path.<init>(Path.java:172)
    at
org.apache.pig.parser.QueryParserUtils.getRemoteHosts(QueryParserUtils.java:138)
    at
org.apache.pig.parser.QueryParserUtils.setHdfsServers(QueryParserUtils.java:104)
    at
org.apache.pig.parser.LogicalPlanBuilder.buildLoadOp(LogicalPlanBuilder.java:892)
    ... 37 more
Caused by: java.net.URISyntaxException: Relative path in absolute URI:
CREATED_DATE FROM HIRES WHERE CREATED_DATE>=TO_DATE('1990-12-21
05:55:00.000')%20AND%20CREATED_DATE%3CTO_DATE('2016-03-08%2008:00:00.000')
    at java.net.URI.checkPath(URI.java:1823)
    at java.net.URI.<init>(URI.java:745)
    at org.apache.hadoop.fs.Path.initialize(Path.java:203)
    ... 41 more

Thanks,
Siddhi

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message