Currently there is no way to specify the yarn queue that should be used to run Hive queries. So all queries from Spotfire are run in the default queue. Hortonworks ODBC driver enables this in HTTP Options by specifying it in Custom HTTP Headers...Please add this in Hortonworks connector so queries could be directed to a queue where they will be processed faster by having dedicated resources...
Great feedback! Spotfire 7.9 added support for Apache KNOX and it is in our direction to continue to enhance Spotfire's Hive integration capabilities and performance.