[ https://issues.apache.org/jira/browse/HIVE-22093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16903785#comment-16903785 ]
Hive QA commented on HIVE-22093: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12977118/HIVE-22093.1.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/18294/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/18294/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-18294/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Tests exited with: NonZeroExitCodeException Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ date '+%Y-%m-%d %T.%3N' 2019-08-09 10:10:41.236 + [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]] + export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + export 'MAVEN_OPTS=-Xmx1g ' + MAVEN_OPTS='-Xmx1g ' + cd /data/hiveptest/working/ + tee /data/hiveptest/logs/PreCommit-HIVE-Build-18294/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z master ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-08-09 10:10:41.240 + cd apache-github-source-source + git fetch origin >From https://github.com/apache/hive 311049d..1729d77 master -> origin/master + git reset --hard HEAD HEAD is now at 311049d HIVE-21241: Migrate TimeStamp Parser From Joda Time (Beluga Behr, reviewed by Naveen Gangam) + git clean -f -d Removing standalone-metastore/metastore-server/src/gen/ + git checkout master Already on 'master' Your branch is behind 'origin/master' by 1 commit, and can be fast-forwarded. (use "git pull" to update your local branch) + git reset --hard origin/master HEAD is now at 1729d77 HIVE-21579: Introduce more complex SQL:2016 datetime formats (Karen Coppage via Marta Kuczora) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-08-09 10:10:43.082 + rm -rf ../yetus_PreCommit-HIVE-Build-18294 + mkdir ../yetus_PreCommit-HIVE-Build-18294 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-18294 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-18294/yetus + patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hiveptest/working/scratch/build.patch + [[ -f /data/hiveptest/working/scratch/build.patch ]] + chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh + /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch fatal: corrupt patch at line 13 fatal: corrupt patch at line 13 fatal: corrupt patch at line 13 The patch does not appear to apply with p0, p1, or p2 + result=1 + '[' 1 -ne 0 ']' + rm -rf yetus_PreCommit-HIVE-Build-18294 + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12977118 - PreCommit-HIVE-Build > JdbcStorageHandler query mysql with wrong offset > ------------------------------------------------ > > Key: HIVE-22093 > URL: https://issues.apache.org/jira/browse/HIVE-22093 > Project: Hive > Issue Type: Bug > Affects Versions: 2.3.5 > Reporter: wang dawei > Assignee: wang dawei > Priority: Major > Attachments: HIVE-22093.1.patch > > > CREATE EXTERNAL TABLE student_jdbc > ( > name string, > age int, > gpa double > ) > STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' > TBLPROPERTIES ( > "hive.sql.database.type" = "MYSQL", > "hive.sql.jdbc.driver" = "com.mysql.jdbc.Driver", > "hive.sql.jdbc.url" = "jdbc:mysql://localhost:3306/test", > "hive.sql.dbcp.username" = "xxx", > "hive.sql.dbcp.password" = "xxxxx", > "hive.sql.table" = "student_1", > "hive.sql.partitionColumn" = "id", > "hive.sql.numPartitions" = "5", > "hive.sql.lowerBound" = "1", > "hive.sql.upperBound" = "36", > "hive.sql.dbcp.maxActive" = "5", > "hive.sql.query" = "SELECT name, age, gpa FROM student_1" > ); > set mapred.map.tasks=5; > select count\(*) from student_jdbc; > 82 > mysql: > select count\(*) from student; > 36 -- This message was sent by Atlassian JIRA (v7.6.14#76016)