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.

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

New Contributor

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.

2 REPLIES 2

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?

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

New Contributor

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

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