I would like to use the Hive environment variables to use the viewing value in Hive and prioritize my queries on Hive. The way I saw this is in the form of a team set mapred.job.priority=VERY_LOW.
I connect to Hive and generate my runtime requests from R connecting through a packet RJDBC. When I use the dbSendUpdateabove command to send, the following error message appears:
execute JDBC update query failed in dbSendUpdate ([Simba][JDBC](11320) A RowCount was expected but not generated from query "set mapred.job.priority=VERY_LOW". Query not executed. )
Is there a way to send these commands to set environment variables in Hive via R?
Details and versions:
- I am using Amazon HIVE drivers to connect to an EMR Release 4.1 cluster on AWS
- Hive 1.0.0
- R Version 3.2.2
- RJDBC Version 0.2-5
- DBI Version 0.3.1