Hue supports exporting hive query result data. It supports the Chinese encoding GBK.

Since it is the query result of hive, We must modify the handler in hueapps to add the code: EXPORT_CHART_SETgb2312 on defdownload (handle, format, db): In defdownload (db) CSVformatter and CSVformatte

Since it is the query result of hive, We must modify beeswax/src/beeswax vim data_export.py in hue apps to add code on def download (handle, format, db: EXPORT_CHART_SET = 'gb2312' and then modify the CSVformatter and CSVformatte in def download (handle, format, db ).

Since it is the query result of hive, We must modify beeswax/src/beeswax in hue apps.

 vim data_export.py 

Add the code on def download (handle, format, db:

EXPORT_CHART_SET='gb2312'

Then modify the CSVformatter and CSVformatter in def download (handle, format, db) to add the variables defined above as parameters.

if format == 'csv':    formatter = CSVformatter(EXPORT_CHART_SET) #yangqijun.com    mimetype = 'application/csv'  elif format == 'xls':    formatter = CSVformatter(EXPORT_CHART_SET) #yangqijun.com    mimetype = 'application/xls'

Restart the instance.

Original article address: hue supports exporting hive query result data and supports the Chinese encoding GBK. Thank you for sharing it with the original author.