You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Randy Martin <Ra...@ds-iq.com> on 2014/08/21 18:32:41 UTC
Use of column list for Pig Store command
What is the syntax for providing a column list for a Pig STORE command? This is a feature that our company initiated so that a partial list of columns could be used when doing a STORE. We are on 4.0.0 incubating and thought the feature was to be implemented, but are getting the error 'At least one column must be provided for upserts' whenever we provide any column list.
Syntax like this was expected: STORE relation INTO 'hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2' using org.apache.phoenix.pig.PhoenixHBaseStorage('$zk','-batchSize 5000')
Thanks for your help,
Randy
RE: Use of column list for Pig Store command
Posted by Randy Martin <Ra...@ds-iq.com>.
Ravi/James, thanks for the clarification.
From: Ravi Kiran [mailto:maghamravikiran@gmail.com]
Sent: Monday, August 25, 2014 11:24 PM
To: user@phoenix.apache.org
Subject: Re: Use of column list for Pig Store command
Hi Randy,
Due to code overlapping with Pig Loader functionality, the fix for PHOENIX-898 was checked in as part of JIRA https://issues.apache.org/jira/browse/PHOENIX-11 .
The planned release of Phoenix 4.1.0 RC will be having it. https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.1.0-rc1/src/
Please let us know if you need any further information.
Regards
Ravi
On Mon, Aug 25, 2014 at 10:52 PM, James Taylor <ja...@apache.org>> wrote:
I think Ravi committed this as part of a different JIRA. Ravi?
Thanks,
James
On Mon, Aug 25, 2014 at 9:03 PM, Randy Martin <Ra...@ds-iq.com>> wrote:
> It looks like JIRA issue PHOENIX-898 was originally tracking this, but it
> looks like this issue has been reverted in 4.1.0 RC 0 and 1. Can anyone
> from the Phoenix group confirm this?
>
>
>
> From: Ravi Kiran [mailto:maghamravikiran@gmail.com<ma...@gmail.com>]
> Sent: Thursday, August 21, 2014 5:34 PM
> To: user@phoenix.apache.org<ma...@phoenix.apache.org>
> Subject: Re: Use of column list for Pig Store command
>
>
>
> Hi Randy,
>
> This feature is being delivered as part of 4.1.0RC. Right now we are
> going through a voting phase for its release. If you wish to try this
> feature before the official release, please follow the instructions at
> http://phoenix.apache.org/building.html to build the necessary artifacts.
>
> Please let us know if you face any hurdles. HTH.
>
> Regards
>
> Ravi
>
>
>
> On Thu, Aug 21, 2014 at 9:32 AM, Randy Martin <Ra...@ds-iq.com>>
> wrote:
>
> What is the syntax for providing a column list for a Pig STORE command?
> This is a feature that our company initiated so that a partial list of
> columns could be used when doing a STORE. We are on 4.0.0 incubating and
> thought the feature was to be implemented, but are getting the error ‘At
> least one column must be provided for upserts’ whenever we provide any
> column list.
>
>
>
> Syntax like this was expected: STORE relation INTO
> ‘hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2’ using
> org.apache.phoenix.pig.PhoenixHBaseStorage(‘$zk’,’-batchSize 5000’)
>
>
>
> Thanks for your help,
>
> Randy
>
>
Re: Use of column list for Pig Store command
Posted by Ravi Kiran <ma...@gmail.com>.
Hi Randy,
Due to code overlapping with Pig Loader functionality, the fix for
PHOENIX-898 was checked in as part of JIRA
https://issues.apache.org/jira/browse/PHOENIX-11 .
The planned release of Phoenix 4.1.0 RC will be having it.
https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.1.0-rc1/src/
Please let us know if you need any further information.
Regards
Ravi
On Mon, Aug 25, 2014 at 10:52 PM, James Taylor <ja...@apache.org>
wrote:
> I think Ravi committed this as part of a different JIRA. Ravi?
>
> Thanks,
> James
>
> On Mon, Aug 25, 2014 at 9:03 PM, Randy Martin <Ra...@ds-iq.com>
> wrote:
> > It looks like JIRA issue PHOENIX-898 was originally tracking this, but it
> > looks like this issue has been reverted in 4.1.0 RC 0 and 1. Can anyone
> > from the Phoenix group confirm this?
> >
> >
> >
> > From: Ravi Kiran [mailto:maghamravikiran@gmail.com]
> > Sent: Thursday, August 21, 2014 5:34 PM
> > To: user@phoenix.apache.org
> > Subject: Re: Use of column list for Pig Store command
> >
> >
> >
> > Hi Randy,
> >
> > This feature is being delivered as part of 4.1.0RC. Right now we are
> > going through a voting phase for its release. If you wish to try this
> > feature before the official release, please follow the instructions at
> > http://phoenix.apache.org/building.html to build the necessary
> artifacts.
> >
> > Please let us know if you face any hurdles. HTH.
> >
> > Regards
> >
> > Ravi
> >
> >
> >
> > On Thu, Aug 21, 2014 at 9:32 AM, Randy Martin <Ra...@ds-iq.com>
> > wrote:
> >
> > What is the syntax for providing a column list for a Pig STORE command?
> > This is a feature that our company initiated so that a partial list of
> > columns could be used when doing a STORE. We are on 4.0.0 incubating and
> > thought the feature was to be implemented, but are getting the error ‘At
> > least one column must be provided for upserts’ whenever we provide any
> > column list.
> >
> >
> >
> > Syntax like this was expected: STORE relation INTO
> > ‘hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2’ using
> > org.apache.phoenix.pig.PhoenixHBaseStorage(‘$zk’,’-batchSize 5000’)
> >
> >
> >
> > Thanks for your help,
> >
> > Randy
> >
> >
>
Re: Use of column list for Pig Store command
Posted by James Taylor <ja...@apache.org>.
I think Ravi committed this as part of a different JIRA. Ravi?
Thanks,
James
On Mon, Aug 25, 2014 at 9:03 PM, Randy Martin <Ra...@ds-iq.com> wrote:
> It looks like JIRA issue PHOENIX-898 was originally tracking this, but it
> looks like this issue has been reverted in 4.1.0 RC 0 and 1. Can anyone
> from the Phoenix group confirm this?
>
>
>
> From: Ravi Kiran [mailto:maghamravikiran@gmail.com]
> Sent: Thursday, August 21, 2014 5:34 PM
> To: user@phoenix.apache.org
> Subject: Re: Use of column list for Pig Store command
>
>
>
> Hi Randy,
>
> This feature is being delivered as part of 4.1.0RC. Right now we are
> going through a voting phase for its release. If you wish to try this
> feature before the official release, please follow the instructions at
> http://phoenix.apache.org/building.html to build the necessary artifacts.
>
> Please let us know if you face any hurdles. HTH.
>
> Regards
>
> Ravi
>
>
>
> On Thu, Aug 21, 2014 at 9:32 AM, Randy Martin <Ra...@ds-iq.com>
> wrote:
>
> What is the syntax for providing a column list for a Pig STORE command?
> This is a feature that our company initiated so that a partial list of
> columns could be used when doing a STORE. We are on 4.0.0 incubating and
> thought the feature was to be implemented, but are getting the error ‘At
> least one column must be provided for upserts’ whenever we provide any
> column list.
>
>
>
> Syntax like this was expected: STORE relation INTO
> ‘hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2’ using
> org.apache.phoenix.pig.PhoenixHBaseStorage(‘$zk’,’-batchSize 5000’)
>
>
>
> Thanks for your help,
>
> Randy
>
>
RE: Use of column list for Pig Store command
Posted by Randy Martin <Ra...@ds-iq.com>.
It looks like JIRA issue PHOENIX-898 was originally tracking this, but it looks like this issue has been reverted in 4.1.0 RC 0 and 1. Can anyone from the Phoenix group confirm this?
From: Ravi Kiran [mailto:maghamravikiran@gmail.com]
Sent: Thursday, August 21, 2014 5:34 PM
To: user@phoenix.apache.org
Subject: Re: Use of column list for Pig Store command
Hi Randy,
This feature is being delivered as part of 4.1.0RC. Right now we are going through a voting phase for its release. If you wish to try this feature before the official release, please follow the instructions at http://phoenix.apache.org/building.html to build the necessary artifacts.
Please let us know if you face any hurdles. HTH.
Regards
Ravi
On Thu, Aug 21, 2014 at 9:32 AM, Randy Martin <Ra...@ds-iq.com>> wrote:
What is the syntax for providing a column list for a Pig STORE command? This is a feature that our company initiated so that a partial list of columns could be used when doing a STORE. We are on 4.0.0 incubating and thought the feature was to be implemented, but are getting the error ‘At least one column must be provided for upserts’ whenever we provide any column list.
Syntax like this was expected: STORE relation INTO ‘hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2’ using org.apache.phoenix.pig.PhoenixHBaseStorage(‘$zk’,’-batchSize 5000’)
Thanks for your help,
Randy
Re: Use of column list for Pig Store command
Posted by Ravi Kiran <ma...@gmail.com>.
Hi Randy,
This feature is being delivered as part of 4.1.0RC. Right now we are
going through a voting phase for its release. If you wish to try this
feature before the official release, please follow the instructions at
http://phoenix.apache.org/building.html to build the necessary artifacts.
Please let us know if you face any hurdles. HTH.
Regards
Ravi
On Thu, Aug 21, 2014 at 9:32 AM, Randy Martin <Ra...@ds-iq.com>
wrote:
> What is the syntax for providing a column list for a Pig STORE command?
> This is a feature that our company initiated so that a partial list of
> columns could be used when doing a STORE. We are on 4.0.0 incubating and
> thought the feature was to be implemented, but are getting the error ‘At
> least one column must be provided for upserts’ whenever we provide any
> column list.
>
>
>
> Syntax like this was expected: STORE relation INTO
> ‘hbase://SCHEMA.TABLE/primary_key, cf.column1,cf.column2’ using
> org.apache.phoenix.pig.PhoenixHBaseStorage(‘$zk’,’-batchSize 5000’)
>
>
>
> Thanks for your help,
>
> Randy
>