[SPARK-3534] Add hive-thriftserver to SQL tests

Addresses the problem pointed out in [this comment](https://github.com/apache/spark/pull/2441#issuecomment-55990116).