I use mt_dop=n parameter extensively and want to pass it from connection string.
While using Cloudera Impala driver, the below query string works:
However when we use Hive JDBC driver, the below query string doesnt work:
I have tried lots of alternatives for Hive connection string like
but none of them work.
Can anyone give me a way out to pass this query option using Hive JDBC driver ?
Cloudera doesn't support using the Hive JDBC driver so it may not work in all cases - I think it is something that's provided by the Apache Hive project.
In Impala 2.0 and later, you have the choice between the Cloudera JDBC Connector and the Hive 0.13 JDBC driver. Cloudera recommends using the Cloudera JDBC Connector where practical.
I take this to mean that Impala should support both drivers.