Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive query returns zero result

avatar
New Contributor

I'm getting zero result from my hive query in Hue without any error message. I'm sure the table that I'm using in the database are not empty.

Does anyone know what the issue could be?

Thank you!

5 REPLIES 5

avatar
Contributor

please add also Hue label...because there might be some Hue experts who might be able to help.

avatar
Expert Contributor

Was this recently import it? added a file to it?

If so, you might need to run ANALYZE TABLE

ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS

avatar
New Contributor

I'm creating a table using hive. I'm inner joining the tables in our data warehouse to get the result. I'm not trying to import anything.

avatar
Contributor

Did you already try to use hive directly instead of hue? Are you using ranger? If yes, have you check the policies?

avatar
Explorer

The issue might be with your INNER JOINs. Try and temporarily replace them with (LEFT) OUTER JOINs and see if any data get returned.

,

The problem might lie with your INNER JOINs. Temporarily replace them with (LEFT) OUTER JOINs and see if any data get returned.