Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Not able to get data in Hive even though data is present in HDFS location.

Highlighted

Not able to get data in Hive even though data is present in HDFS location.

Hi,

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.

5 REPLIES 5
Highlighted

Re: Not able to get data in Hive even though data is present in HDFS location.

Mentor

@Nilesh Shrimant

Can you share your database and create external table create the snippet and consequent steps?

Highlighted

Re: Not able to get data in Hive even though data is present in HDFS location.

Wont be able to copy out of production.. But it gives error as "Could not decompress data. Input is invalid."

Highlighted

Re: Not able to get data in Hive even though data is present in HDFS location.

New Contributor

Have you had this Error("could not decompress data. input is invalid") since then? I'm run into the same error in scanning Hbase

Highlighted

Re: Not able to get data in Hive even though data is present in HDFS location.

Mentor

@nilesh_shrimant 

If you want to get help you should share more detail like datatype and  the create external table snippet.

 

But I think this  post should your answer

Re: Not able to get data in Hive even though data is present in HDFS location.

Contributor

@nilesh_shrimant 

 

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 

Don't have an account?
Coming from Hortonworks? Activate your account here