Skip to Content
0

Hadoop/Hive UNX performance issues

Mar 09, 2017 at 03:18 PM

31

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Denis Konovalov
Mar 09, 2017 at 08:57 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded