Skip to Content

Hadoop/Hive UNX performance issues

Hoping someone can help me out or point me in the right direction with some issues were having with performance related to a UNX universe on top of Hive...there doesn't seem to really be too much information out there.

Environment : BO 4.2 SP3 Patch 4
Hive version 1.2.1
Connector : Simba Hive ODBC using 'Generic ODBC' for the connection

From a connectivity and compatibility standpoint, everything seems to be OK. However, WebI queries executed take ~ 5 times longer than they would if I just ran the query out of SQL Workbench or even if I used the same ODBC connection and entered the same query into a Command.

Edited to add further testing shows that in regards to the Crystal Report that runs quickly local, once I publish to the server and schedule it to run, it takes just as long as the WebI report w/ the same query.

Any idea as to what could be causing this?

Thanks for any help!

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Mar 09, 2017 at 08:57 PM

    you can trace the workflows using KBA 1861180 and see where time is being spent.

    Add comment
    10|10000 characters needed characters exceeded