Re: Skip first line of CSV loading

2011-09-27 Thread Adriaan Tijsseling
You could try to remove the first line of a file before passing it on to hive. Something like `sed -i '1d' filename`. Adriaan On 2011/09/27, at 01:58, Bradford Stephens wrote: > Any thoughts on this? > > On Wed, Apr 13, 2011 at 1:55 PM, Daniel Jue wrote: >> Is there a way to have hive skip t

Re: Skip first line of CSV loading

2011-09-26 Thread Bradford Stephens
Any thoughts on this? On Wed, Apr 13, 2011 at 1:55 PM, Daniel Jue wrote: > Is there a way to have hive skip the first line of CSV loading (say, > to skip column headers)? > > Or will this require a second stage with a transform, and > a) a hard coded knowledge of what a header row might contain,

Skip first line of CSV loading

2011-04-13 Thread Daniel Jue
Is there a way to have hive skip the first line of CSV loading (say, to skip column headers)? Or will this require a second stage with a transform, and a) a hard coded knowledge of what a header row might contain, or b) a sequence number column for skipping? Seems like this should be a pretty co