MaxCompute - Supports Using Parentheses to Specify the Priority of JOIN and SETOP Operations
Oct 28 2019MaxCompute
Target customers: Alibaba Cloud MaxCompute users. Features released: You can now use parentheses () to specify the priority of JOIN operations. The JOIN operation enclosed in parentheses () has a higher priority. For example, in the SELECT * FROM src JOIN (src2 JOIN src3 on xxx) ON yyy; statement, the src2 JOIN src3 operation is performed first and the src JOIN operation is then performed on the obtained results.