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