Bulk delete activity

2014-09-08 Thread Randy Martin
I have a task that needs to delete over a million rows using a key. At first blush, I do not see any bulk or batch delete capabilities. For instance, there are SQL dialects that support syntax like this: DELETE x FROM schema.table x INNER JOIN filter.table f ON f.key = x.key; Has anyone had a

RE: Use of column list for Pig Store command

2014-08-26 Thread Randy Martin
On Mon, Aug 25, 2014 at 10:52 PM, James Taylor mailto:jamestay...@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 mailto:randy.mar...@ds-iq.com>> wrote: > It looks like JIRA issue

RE: Use of column list for Pig Store command

2014-08-25 Thread Randy Martin
://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 mailto:randy.mar...@ds-iq.com>> wrote: What is the syntax for providing a column list for a Pig STORE command? This

Use of column list for Pig Store command

2014-08-21 Thread Randy Martin
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

Location protocol error in Pig using Phoenix 3.0

2014-07-25 Thread Randy Martin
I am getting the following error when issuing a Store command in Pig: Caused by: java.io.IOException: Location must use the hbase protocol, hbase://tableName[/columnList]. Supplied location=file:/tmp/temp-172455017/tmp1219147161 The code is very simple, loading from a file and storing to a Phoe