Big Data, Max Compute, Apache, Apache Hive, Alibabacloud.
First, the employees over 30 years old are filtered out from the employee table “emp”, the departments created after 2018 are filtered out from the department table “dept”, and then the join operation is performed. Considering that the data volume may be large, Merge Join is selected for the