hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adriaan Tijsseling <adri...@tijsseling.com>
Subject Re: Skip first line of CSV loading
Date Tue, 27 Sep 2011 07:18:40 GMT
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 <teamphy6@gmail.com> 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, or
>> b) a sequence number column for skipping?
>> 
>> 
>> Seems like this should be a pretty common need.


Mime
View raw message