Our cluster is set to produce .deflate files, i have a pig script that produces a data set to an HDFS folder that i have an external table located on. Can the hive table read .deflate files? The .deflate file is in the directory, but when i query the table i get no results.
can you please share the minimal reproducible steps so that i can reproduce this locally? Also kindly mentioned the HDP version.