I believe this is not a Tableau related item to set it up at Tableau desktop or Drivers level. You need to work with your Hadoop Admin to set it up the desired configuration change.
Sorry, couldn't help much. Please post the resolution if there is something we need to do at Tableau level.
Our Hadoop Admin said there must be a way for Tableau to set RESOURCE POOLs
Hey guys, I'm on the Tableau connectivity team. I am trying to understand from the question above, do we think that Tableau is failing to issue the initial SQL command? If so, then we should file a bug and we'll take that fix as it absolutely should. If the issue is that you see the initial SQL command hit Impala in the logs, but it's not doing the right thing, that's not something I would be able to help troubleshoot.
Jason, Connectivity Product Mananger
My team and I are encountering a problem with the "initial SQL" section and setting the request pool:
We are able to set the request pool when the workbook or dashboard is initially accessed. However, after 5-10 minutes, the request pool "initial SQL" seems to be ignored and the query still executes but at a default request pool that the user does not have access to.
Is there a way to make sure that the "initial SQL" is re-run every time the data connection is accessed?
My team and I set the resource pool for Impala in the Initial SQL with the command - set request_pool = 'xxx';
Where xxx is your resource pool's name.
We set it for Hive using the command - set mapreduce.job.queuename = 'xxx';