Re: Trouble with transform and dynamic partitions into table with custom field delimiters.

2014-03-18 Thread Stephen Sprague
but why go through all this and make it so long-winded, verbose and non-standard? That's a pain to maintain! just use tabs as your transform in/out separator and go easy on the next guy who has to maintain your code. :) On Tue, Mar 18, 2014 at 4:59 PM, Nurdin Premji < nurdin.pre...@casalemedia.

Re: Trouble with transform and dynamic partitions into table with custom field delimiters.

2014-03-18 Thread Nurdin Premji
I figured out my problem, I wasn't using the outRowFormat section when calling the transform. I had tried with a row format, but I guess I put it in the inRowFormat section which had changed the way the data was passed to my transform function and thought that there was only one place to speci

Trouble with transform and dynamic partitions into table with custom field delimiters.

2014-03-18 Thread Nurdin Premji
Hello, I'm having trouble with loading data into a table with a dynamic partition with custom field delimiters. When I use tabs, it works, when I have fields delimited by '001' it does not. I'm using hive 0.10 on top of hadoop 2.0.0-cdh4.6.0 Here is some example code I was trying: create ex