Hive query returns zero result

[#1]

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!

[#2]

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

[#3]

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

[#4]

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.

[#5]

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

[#6]

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.