We have database created and data is present in HDFS location as well, but while running any query (count) hive is showing 0.
Data is Text file format and snappy compressed.
Wont be able to copy out of production.. But it gives error as "Could not decompress data. Input is invalid."
Have you had this Error("could not decompress data. input is invalid") since then? I'm run into the same error in scanning Hbase
it seems you have some corrupt data. Could you please run the below
hdfs dfs -text <path> | tail 10 (this will help us to review whether you can read the data or not )
hdfs fsck <path of the file> -files -blocks -locations