'Is there a way to set Hive configurations using Hive magic in Jupyter notebook?

I am using Jupyter Notebook to crunch data in Hive and I want to set Hive configurations using Hive magic. Is there a way to do it?

Sample code below does not work (Please treat them as one Jupyter Notebook cell each block). I can do this via HUE but I find it better to do in Jupyter Notebook because I can add some notes via Markdown.

%%hive
set hive.cbo.enable=false
%%hive

select *
from some_table


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source