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