Skip to content
Advertisement

Can’t found the poroblem within this Hive Query [closed]

EDIT: Sorry, I’ve just realised I was naming equal both fee and foo columns. Now it’s corrected

I’m trying to do an inner join between 2 tables in Hive in GCP. The problem is that this join needs to be done with the mutual join of 2 variables. This is my query:

An examploea of each tables:

As you can seem both atr9 and atr10 are equals. I receive no error but an empty view. What is wrong with that query?

Advertisement

Answer

As you can seem both atr9 and atr10 are equals.

No, we can’t see this.

I receive no error but an empty view. Normal your query is correct

What is wrong with that query? Nothing

To uderstand, you have to change the query with LEFT OR RIGHT JOIN and see the result, you’ll see some null result facing not null result and you have to understand why there are some differnces.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement