hi, i have a text file on HDFS(generated by sqoop job) which i am compressing using basic GzipCodec(streaming), i created a external hive table pointing to the compressed file, when i am do a select query on the hive table i am getting NULL's in the first column. - tried compressing the file in the sqoop job using --compress option it works fine -tried copying the file to local , zipped it and copy back to HDFS it also works fine -since the first column is an INT, tried changed it to STRING then some junk characters appear in the first column Below is the command m using for compression: hadoop jar /usr/local/hadoop/share/hadoop/tools/lib/hadoop-streaming-2.4.0.jar -Dmapred.output.compress=true -Dmapred.compress.map.output=true -Dmapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec -Dmapred.reduce.task=0 -input <input file> -output <output file folder> Not sure if i am missing something here .Any help on this will be appreciated. Thanks. ... View more