I had tried to switch off auto map join property and trying to provide MAPJOIN via hints in Hive. All the properties has been set correctly, but it doesn’t seem to find hints properly. Ideally, after checking MAPJOIN hint provided in query, job should not run any reducer task. But here, reducer has been run in both cases. Please find attached snapshot for reference and better understanding on properties and queries ran on Hive.
Sorry for the delay in the response.
These are not lab related issues. Please check with your instructor to understand why it is not working as expected.
Hint means, it might take or it might not take based on the job you are running.