Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> sqoop, hive and lzo and cdh3u3 - not creating in index automatically


Copy link to this message
-
Re: sqoop, hive and lzo and cdh3u3 - not creating in index automatically
Hi Chalcy

Did you notice any warnings related to lzo codec on your mapreduce task logs or on sqoop logs?

It could be because LZO libs are not available on the TaskTracker nodes. These are native libs and are tied to OS, so if you have done an OS upgrade then you need to rebuild and deploy these native libs as well (a simple copy of native libs based older OS may not work as desired).

Like Edward suggested, snappy + sequence is a great combination.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: Edward Capriolo <[EMAIL PROTECTED]>
Date: Mon, 18 Jun 2012 09:32:01
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Re: sqoop, hive and lzo and cdh3u3 - not creating in index automatically

Have you considered switching to sequence files using snappy
compression (or lzo). IIRC the process of generating LZO files and
then generating an index on top of these is cumbersome. When sequence
files are directly splittable.

On Mon, Jun 18, 2012 at 9:16 AM, Chalcy Raja
<[EMAIL PROTECTED]> wrote:
> I am posting it here first and then may be on sqoop user group as well.
>
>
>
> I am trying to use lzo compression.
>
>
>
> Tested on a standalone by installing cdh3u3 and did sqoop to hive import
> with lzo compression and everything works great. The data is sqooped into
> hdfs and lzo index file got created and data is in hive table.
>
>
>
> Did all the lzo necessary steps on the main cluster where the server already
> has cdh3u3 upgraded previously from cdh3u0 to cdh3u1 to cdh3u2 to cdh3u3.
> Did the same sqoop to hive with lzo compression.  Sqoop to hive works but
> lzo index is not getting created.
>
>
>
> Need expert opinion. What could be the reason for this behavior.  Compared
> all the versions of hive, sqoop etc., and checked all the configuration.
> Looks like we are missing something.
>
>
>
> Thanks,
>
> Chalcy
>
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB