[ https://issues.apache.org/jira/browse/DRILL-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mehant Baid resolved DRILL-3245. -------------------------------- Resolution: Fixed Fix Version/s: 1.1.0 Fixed in 287f52db0bd0125e0ad1b3408f22775224ee9494 > Error message needs to be fixed. > -------------------------------- > > Key: DRILL-3245 > URL: https://issues.apache.org/jira/browse/DRILL-3245 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Affects Versions: 1.0.0 > Reporter: Khurram Faraaz > Assignee: Mehant Baid > Fix For: 1.1.0 > > Attachments: DRILL-3245.patch > > > The error message need to be fixed. > {code} > 0: jdbc:drill:schema=dfs.tmp> SELECT SUM(columns[0]) FROM `first_25.csv`; > Error: SYSTEM ERROR: java.lang.RuntimeException: Only COUNT aggregate > function supported for Boolean type > Fragment 0:0 > [Error Id: ef5abe03-bbaf-4f20-bf86-4e307f86d944 on centos-02.qa.lab:31010] > (state=,code=0) > {code} > Stack trace from drillbit.log > {code} > [Error Id: eb09fc3d-3b10-4525-b7c4-9e6c66059c3f on centos-02.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > java.lang.RuntimeException: Only COUNT aggregate function supported for > Boolean type > Fragment 0:0 > [Error Id: eb09fc3d-3b10-4525-b7c4-9e6c66059c3f on centos-02.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:522) > ~[drill-common-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:324) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:180) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:293) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_45] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_45] > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] > Caused by: java.lang.RuntimeException: Only COUNT aggregate function > supported for Boolean type > at > org.apache.drill.exec.test.generated.StreamingAggregatorGen47.setupInterior(StreamingAggTemplate.java:60) > ~[na:na] > at > org.apache.drill.exec.test.generated.StreamingAggregatorGen47.setup(StreamingAggTemplate.java:53) > ~[na:na] > at > org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.createAggregatorInternal(StreamingAggBatch.java:308) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.createAggregator(StreamingAggBatch.java:246) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.buildSchema(StreamingAggBatch.java:113) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:127) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:83) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:80) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:73) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:259) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:253) > ~[drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at java.security.AccessController.doPrivileged(Native Method) > ~[na:1.7.0_45] > at javax.security.auth.Subject.doAs(Subject.java:415) ~[na:1.7.0_45] > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1566) > ~[hadoop-common-2.5.1-mapr-1503.jar:na] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:253) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > ... 4 common frames omitted > 2015-06-02 21:54:02,686 [BitServer-4] INFO > o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING --> > FAILED > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > java.lang.RuntimeException: Only COUNT aggregate function supported for > Boolean type > Fragment 0:0 > [Error Id: eb09fc3d-3b10-4525-b7c4-9e6c66059c3f on centos-02.qa.lab:31010] > at > org.apache.drill.exec.work.foreman.QueryManager$1.statusUpdate(QueryManager.java:458) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.control.WorkEventBus.statusUpdate(WorkEventBus.java:71) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.work.batch.ControlMessageHandler.handle(ControlMessageHandler.java:79) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:61) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:38) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.timeout.ReadTimeoutHandler.channelRead(ReadTimeoutHandler.java:150) > [netty-handler-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > ELECT SUM(columns[0]) FROM `first_25.csv`; > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > [netty-common-4.0.27.Final.jar:4.0.27.Final] > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] > {code} > {code} > [root@centos-01 ~]# cat first_25.csv > -337516559,39342852852629160,VT,AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB,2014-06-02 > 00:28:02.418,1952-08-14,false,729363085.95,8:16:8.58 > 406158122,81588677006971200,IN,AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB,2014-06-02 > 00:28:02.418,2001-03-08,false,1292460500.48,9:11:49.17 > 1221407024,30009558124347168,VT,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02 > 00:28:02.419,2000-10-18,true,395110006.277,18:44:25.43 > -1609141704,47841997008600128,ND,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02 > 00:28:02.420,1991-05-13,true,1293582041.37,20:52:8.56 > -1032159521,38891661529640288,SD,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.420,1965-02-21,false,983657842.924,19:46:10.42 > -414035709,37344878123283896,MN,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02 > 00:28:02.420,2003-09-03,false,466674349.327,15:21:34.39 > 1694834300,81923062562407680,MA,AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB,2014-06-02 > 00:28:02.421,1991-06-20,false,474713471.17,10:31:55.24 > -1874845950,4496901140547891,IN,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02 > 00:28:02.421,1958-10-17,false,889911941.945,1:37:47.31 > 877901888,31452794467889696,FL,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.421,1966-06-19,false,1189761583.32,1:50:5.11 > 847222588,66263082908851272,ND,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.421,1971-09-26,true,482511936.897,11:28:25.1 > -1889383968,65973293780212808,SD,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.421,1991-06-09,false,472880577.743,6:12:12.40 > -708074788,71705740868271344,CO,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.422,1975-10-20,false,1048713254.74,9:38:51.10 > -1457190846,53209680683077360,WI,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.422,1992-05-18,false,147932888.44,20:2:5.20 > 1086311701,78366091242119200,MD,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.422,1968-06-06,true,936437541.786,20:50:52.8 > 1907158860,13276876335203164,VT,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.422,1954-10-10,false,1091096591.83,20:26:42.34 > 114272140,10866869904043878,HI,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02 > 00:28:02.422,1960-05-12,false,371555243.082,2:2:58.3 > -830394984,67285760676197944,GA,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.422,2006-10-25,true,1426805339.42,18:31:10.32 > -1094584211,71184555316985264,MN,AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB,2014-06-02 > 00:28:02.423,1980-07-06,false,390513711.473,4:28:38.23 > -1954269479,23663159493540352,GA,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.423,1976-03-26,false,972747639.559,17:32:57.7 > 424095942,50279291136262144,WY,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02 > 00:28:02.423,1959-05-24,true,1134302618.55,2:33:58.28 > -350143576,53078979319492352,MI,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02 > 00:28:02.423,1972-10-24,false,47019775.7462,11:58:35.46 > -1162827816,26493206551509832,MA,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02 > 00:28:02.423,2012-04-23,true,268051680.205,2:22:46.39 > 360722582,24047259207853364,OR,AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB,2014-06-02 > 00:28:02.423,2013-04-09,false,384895861.757,19:22:43.32 > -1679149645,90604964771508720,MA,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02 > 00:28:02.424,1954-07-01,true,273055641.297,19:44:28.9 > -1212232159,50537587258210752,RI,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02 > 00:28:02.424,1975-06-21,true,401229124.414,1:34:9.49 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)