ODPS-0130071: Semantic Analysis Exception - Expect Equality Expression in Join Condition

This error message indicates that you're using operators in your join condition that are not allowed without the 'mapjoin' hint. You can only use the equals sign ('=') and the 'AND' operator in your join conditions. Here's how to fix it:

1. Check your join condition: Verify that you're not using operators like '>', '<', '!=', etc., in your join conditions.
2. Modify your join condition: Use only the equals sign ('=') and the 'AND' operator in your join conditions.
3. Use the 'mapjoin' hint: If you need to use other operators, consider using the 'mapjoin' hint to convert the join into a 'map join'. Keep in mind that 'map join' performance might be less optimal compared to a regular join.
4. Rewrite your query: If the above solutions don't work, consider rewriting your query entirely to achieve the desired outcome using different approaches.