I was able to get the odbc connection working using a connection string and tested simple queries using the Cloudera Apache Hive driver. I am having an issue when using a more complicated query that takes longer than 30 seconds - I receive this error message from bold reports designer:
hyt00 72 cloudera query execution timeout expired
I have already tried adding two timeout options to the odbc string and they seem to make no difference:
SocketTimeout=3600
timeout=3600
Is there a timeout I can pass in c# or somewhere else?