[ https://issues.apache.org/jira/browse/HIVE-19225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16465995#comment-16465995 ]
Hive QA commented on HIVE-19225: -------------------------------- | (/) *{color:green}+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} 7m 49s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 17s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 40s{color} | {color:blue} serde in master has 190 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 13s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 47s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 14s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 11m 39s{color} | {color:black} {color} | \\ \\ || 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-10746/dev-support/hive-personality.sh | | git revision | master / 88d224f | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: serde U: serde | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-10746/yetus.txt | | Powered by | Apache Yetus http://yetus.apache.org | This message was automatically generated. > Class cast exception while running certain queries with UDAF like rank on > internal struct columns > ------------------------------------------------------------------------------------------------- > > Key: HIVE-19225 > URL: https://issues.apache.org/jira/browse/HIVE-19225 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 2.3.2 > Reporter: Amruth S > Assignee: Amruth S > Priority: Major > Attachments: HIVE-19225.patch > > > > *To reproduce : [tag - 2.3.2]* > Launch hive in debug mode > {code:java} > hive --hiveconf hive.root.logger=DEBUG,console;{code} > Run the sample sql below > {code:java} > SET mapreduce.framework.name=local; > CREATE TABLE `test_class_cast` as select > named_struct('a','a','b','b','c','c','d','d','e',true,'f','f','g',timestamp(1),'h','h'), > 'i'; > select `_c0`.c, `_c0`.g, `_c0`.a, rank() over (partition by `_c0`.c order by > `_c0`.g desc) as rown,`_c0`.f,`_c0`.e from default.test_class_cast where > `_c0`.f like '%f%' or `_c0`.f like '%f%' {code} > Should fail with the exception > {code:java} > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime > Error while processing row (tag=0) > {"key":{"reducesinkkey0":"c","reducesinkkey1":"1970-01-01 > 05:30:00.001"},"value":{"_col0":{"a":"a","b":"b","c":"c","d":"d","e":true,"f":"f","g":"1970-01-01 > 05:30:00.001","h":"h"}}} > at > org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:245) > ~[hive-exec-2.3.2.fk.7.jar:2.3.2.fk.7] > at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444) > ~[hadoop-mapreduce-client-core-2.6.0.2.2.0.0-2041.jar:?] > at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392) > ~[hadoop-mapreduce-client-core-2.6.0.2.2.0.0-2041.jar:?] > at > org.apache.hadoop.mapred.LocalJobRunner$Job$ReduceTaskRunnable.run(LocalJobRunner.java:319) > ~[hadoop-mapreduce-client-common-2.6.0.2.2.0.0-2041.jar:?] > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[?:1.8.0_92] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_92] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[?:1.8.0_92] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > ~[?:1.8.0_92] > at java.lang.Thread.run(Thread.java:745) ~[?:1.8.0_92] > Caused by: java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct cannot be cast to > org.apache.hadoop.hive.serde2.io.TimestampWritable > at > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableTimestampObjectInspector.getPrimitiveJavaObject(WritableTimestampObjectInspector.java:39) > ~[hive-exec-2.3.2.fk.7.jar:2.3.2.fk.7] > at > org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableTimestampObjectInspector.getPrimitiveJavaObject(WritableTimestampObjectInspector.java:25) > ~[hive-exec-2.3.2.fk.7.jar:2.3.2.fk.7] > at > org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:412) > ~[hive-exec-2.3.2.fk.7.jar:2.3.2.fk.7] > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank.copyToStandardObject(GenericUDAFRank.java:219) > ~[hive-exec-2.3.2.fk.7.jar:2.3.2.fk.7]{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)