Not getting result when querying tdv view over hive table through jdbc randomly

[Manoj Chaurasia]

We are connecting to hive(cdh v. 6.*) Through tibco data virtualization v.8.4 and published views as virtual database(jdbc). Most of the times we get the results, but randomly sometimes it returns error saying not able to query the datasource.(no further details).

We were able to reproduce the issue by launching multiple simultaneous queries. In fact even though tdv had returned error, on cluster hive query was submitted and succeeded. Could you please let know what can cause the issue

Also, what is the ideal driver for creating hive datasource in tdv studio for cloudera distribution 6.3