Re: unable to partition the table

2013-07-01 Thread Stephen Sprague
sorry for the spam. but one correction. json_pp appears to be part of the perl core so if you have a modern perl you may already have it installed. On Mon, Jul 1, 2013 at 1:31 PM, Stephen Sprague wrote: > ok. so i just learned of a perl script called "json_pp" (for json > pretty_prrint) that

Re: unable to partition the table

2013-07-01 Thread Stephen Sprague
ok. so i just learned of a perl script called "json_pp" (for json pretty_prrint) that is a binary included in the distro for the perl JSON module. You gotta figure there are analogous tools in other languages as well but given this is a binary it doesn't matter much what language its written in -

Re: unable to partition the table

2013-06-26 Thread Sunita Arvind
Ok. Thanks Stephen. I will try that out. Will update the group if I am able to get this to work. For now, I will continue with non-partitioned table. regards Sunita On Wed, Jun 26, 2013 at 7:11 PM, Stephen Sprague wrote: > it would appear to be that you may partition only by non-nested columns

Re: unable to partition the table

2013-06-26 Thread Stephen Sprague
it would appear to be that you may partition only by non-nested columns. I would recommend transforming your original dataset into one where the first column is MM and the rest is your json object. During this transformation you may also wish to make further optimizations as well since you'll

unable to partition the table

2013-06-26 Thread Sunita Arvind
Hi, I am unable to create a partitioned table. The error I get is: FAILED: ParseException line 37:16 mismatched input '"jobs.values.postingDate.year"' expecting Identifier near '(' in column specification I tried referring to the columns in various ways, S.jobs.values.postingDate.year, with quote