What is the method for setting priority in hive configuration?

The method for configuring priority in Hive is determined by three levels.

1. Global Level: Configuration at the global level is set through properties in the hive-site.xml file. These settings will apply to all Hive sessions and jobs.
2. Conversation level: Configuration at the conversation level can be set using the SET command in Hive CLI or Hive scripts. These configurations will only apply to the current session.
3. Assignment level: Configuration for the assignment level can be set using the SET command in Hive scripts. These configurations will only apply to the current assignment.

The priority order is: job level > session level > global level. This means that if a configuration is set at the job level, it will override the same configuration at the session and global levels. Similarly, if a configuration is set at the session level, it will override the same configuration at the global level.

To view the configuration of the current session, you can use the SET command. To view the global configuration, you can check the hive-site.xml file.