Hi, I had been trying to import data from a sequence-file stored in HDFS, compressed with Snappy. (the original file is a massive-log file). I had created the tables in hive-metastore(MySQL) and installed Snappy and tried several approaches: 1. gave the direct path with "hdfs://" prefix 2. tried to download the file and import as a local file like LOAD DATA LOCAL INPATH 'FlumeData.1362965571811' OVERWRITE INTO TABLE recordsflume;
Can somebody shed some light on how to import data from a sequenceFile to Hive? Thanks in advance. regards Ramesh