Posts

Showing posts from 2017

Convert ORC file into Txt using PIG

Script to convert ORC file into Text. REGISTER '/usr/hdp/current/hive-client/lib/hive-exec-1.2.1000.2.4.2.0-258.jar'; target = Load '/user/hdfspath/000000_0' using OrcStorage('-c SNAPPY'); store target into '/user/hdfspath/myfile' using PigStorage('|'); Register statement is to register snappy jar. '-c SNAPPY'  to include snappy param if orc is created using snappy compression. if not you can just remove quoted part;