hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adriaan Tijsseling <>
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`. 


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 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.

View raw message