Conversion of one file format to another

2015-03-02 Thread Varsha Raveendran
Hello All, I have a couple of Sequence files on HDFS. I now need to load these files into an ORC table. One option is to create an external table of SequenceFile format and then load it into the ORC table by using the INSERT OVERWRITE command. I am looking for an alternative without using an int

Fwd: Custom Input Format for Sequence Files

2015-02-13 Thread Varsha Raveendran
Hello! I have csv files which are small in size which are moved to the HDFS using the SequenceFile Format. The key is the file name and contents of the file becomes the value. Now I want to create an external table on these csv files using HIVE. But when I do I get only the first row of each csv

HIVE Custom InputFormat for Sequence Files

2015-02-13 Thread Varsha Raveendran
Hello! I have csv files which are small in size which are moved to the HDFS using the SequenceFile Format. The key is the file name and contents of the file becomes the value. Now I want to create an external table on these csv files using HIVE. But when I do I get only the first row of each csv