[ https://issues.apache.org/jira/browse/HIVE-19847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16610488#comment-16610488 ]
Hive QA commented on HIVE-19847: -------------------------------- | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 9m 3s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 7s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 43s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 2s{color} | {color:blue} ql in master has 2312 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 57s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 25s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 8s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 8s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 43s{color} | {color:red} ql: The patch generated 5 new + 371 unchanged - 12 fixed = 376 total (was 383) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 4m 25s{color} | {color:red} ql generated 1 new + 2308 unchanged - 4 fixed = 2309 total (was 2312) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 59s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 25m 13s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Possible doublecheck on org.apache.hadoop.hive.ql.exec.FileSystemUtils.executorService in org.apache.hadoop.hive.ql.exec.FileSystemUtils.getExecutorService() At FileSystemUtils.java:org.apache.hadoop.hive.ql.exec.FileSystemUtils.getExecutorService() At FileSystemUtils.java:[lines 83-85] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-13714/dev-support/hive-personality.sh | | git revision | master / 93de950 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-13714/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-13714/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-13714/yetus.txt | | Powered by | Apache Yetus http://yetus.apache.org | This message was automatically generated. > Create Separate getInputSummary Service > --------------------------------------- > > Key: HIVE-19847 > URL: https://issues.apache.org/jira/browse/HIVE-19847 > Project: Hive > Issue Type: Improvement > Components: HiveServer2 > Affects Versions: 3.0.0, 4.0.0 > Reporter: BELUGA BEHR > Assignee: BELUGA BEHR > Priority: Major > Attachments: HIVE-19847.1.patch, HIVE-19847.2.patch, > HIVE-19847.3.patch > > > The Hive {{org.apache.hadoop.hive.ql.exec.Utilities.java}} file has taken on > a life of its own. We should consider separating out the various components > into their own classes. For this ticket, I propose separating out the > {{getInputSummary}} functionality into its own class. > There are several issues with the current implementation: > # It is > [synchronized|https://github.com/apache/hive/blob/f27c38ff55902827499192a4f8cf8ed37d6fd967/ql/src/java/org/apache/hadoop/hive/ql/exec/Utilities.java#L2383]. > Only one query can get file input summary at a time. For a query which > deals with a large data set with a large number of files, this can block > other queries for a long period of time. This is especially painful when > most queries use a small data set, but a large data set is submitted on > occasion. > # For each query, time is spend setting up and tearing down a ThreadPool > # It uses deprecated code > I propose breaking it out into its own class and creating a single thread > pool that all queries pull from. In this way, the bottle neck will be one > the number of available threads, not on a single query and if a big query is > running and a small query is also submitted, the smaller query will be able > to proceed. > In regards to setup/teardown... if a query uses 15 threads to perform this > summary action, then finishes, it will tear down the threads, the next query > may immediate create 15 new threads for processing. With a single pool, > those threads are never performing tear down and setup. -- This message was sent by Atlassian JIRA (v7.6.3#76005)