How to do multiple output of Hive with Python?

[Rex X]

Given a query

select category, value from someHiveTable;

I expect to output the result above of each category into one separate file
named by the corresponding category.

Any tips how to make it?