phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: URIException with PhoenixHBaseLoader
Date Thu, 30 Jun 2016 06:58:48 GMT
Do we need a PHOENIX JIRA for this, Siddhi?

On Wed, Jun 29, 2016 at 6:25 PM, Siddhi Mehta <sm26217@gmail.com> wrote:

> jira filed
> https://issues.apache.org/jira/browse/PIG-4939
>
> I will work on the patch today and have it out for review
>
> Thanks,
> Siddhi
>
> On Tue, Jun 28, 2016 at 3:40 PM, James Taylor <jamestaylor@apache.org>
> wrote:
>
> > Have you filed a JIRA yet and do you have a patch available?
> > Thanks,
> > James
> >
> > On Monday, June 27, 2016, Prashant Kommireddi <prash1784@gmail.com>
> wrote:
> >
> > > Agreed. This method call isn't needed for phoenix loader (or any such
> > > non-direct-fs loaders). You should allow a config to handle it.
> > >
> > > On Mon, Jun 27, 2016 at 12:14 PM, Siddhi Mehta <sm26217@gmail.com
> > > <javascript:;>> wrote:
> > >
> > > > 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