Also, during the profiling and using Htop tool, I see that there is a main thread and many other child threads. It is only one child thread that is using close to 80% CPU time. While the main thread combining all threads uses around 104% of the CPU time. (multiple cores).
I wonder if there is a way to share the load on multiple threads for one single "select * from table" query. Thanks, Alex On Thu, Aug 6, 2015 at 1:56 PM, Alexander Zarei <alexanderz.si...@gmail.com> wrote: > Hi, > > I am doing performance testing on Hive ODBC driver and so far I have > concluded that HiveServer2 is the bottleneck in my data pipe. > > I wonder if you could direct me to links and tips on how to optimize > HiverServer2 so it transfers a large amount of data faster. > > I went ahead and profiled HiveServer2 but noticed there is no single > method using up the CPU. All methods are consuming less than 1% which to me > seems like HiveServer2 is doing its job as it is supposed to. > > Any thoughts, links or suggestions? > > Thanks, > Alex > >
