Volodymyr Vysotskyi created DRILL-7241: ------------------------------------------
Summary: Hash aggregate does not work with interval types Key: DRILL-7241 URL: https://issues.apache.org/jira/browse/DRILL-7241 Project: Apache Drill Issue Type: Bug Affects Versions: 1.16.0 Reporter: Volodymyr Vysotskyi Queries with hash aggregation for interval data types fail with Code generation error. *Steps to reproduce:* disable stream aggregate to force hash aggregate: {code:sql} set `planner.enable_streamagg`=false; {code} Submit query with aggregation for interval type: {code:sql} select max(age) as max_age from (select AGE('1957-06-13') as age) group by age; {code} It fails with the error: {noformat} Error: UNSUPPORTED_OPERATION ERROR: Code generation error - likely an error in the code. Fragment 0:0 [Error Id: fdd9ee7d-9991-42e2-ad2b-eb36503051f8 on user515050-pc:31019] (state=,code=0) {noformat} Stack trace from logs: {noformat} 2019-05-06 16:42:06,643 [Client-1] INFO o.a.d.j.i.DrillCursor$ResultsListener - [#10] Query failed: org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION ERROR: Code generation error - likely an error in the code. Fragment 0:0 [Error Id: 65d849df-408c-4851-88be-b13d99c7b6e6 on user515050-pc:31019] at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) [drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422) [drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96) [drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:273) [drill-rpc-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:243) [drill-rpc-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88) [netty-codec-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287) [netty-handler-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) [netty-codec-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312) [netty-codec-4.0.48.Final.jar:4.0.48.Final] at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286) [netty-codec-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) [netty-transport-4.0.48.Final.jar:4.0.48.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) [netty-common-4.0.48.Final.jar:4.0.48.Final] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_191] org.apache.drill.exec.exception.ClassTransformationException: java.util.concurrent.ExecutionException: org.apache.drill.exec.exception.ClassTransformationException: org.codehaus.commons.compiler.CompileException: Line 40, Column 48: A method named "getContext" is not declared in any enclosing class nor any supertype, nor through a static import at org.apache.drill.exec.compile.CodeCompiler.createInstances(CodeCompiler.java:197) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler.createInstance(CodeCompiler.java:163) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.ops.BaseFragmentContext.getImplementationClass(BaseFragmentContext.java:56) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.common.ChainedHashTable.createAndSetupHashTable(ChainedHashTable.java:244) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.test.generated.HashAggregatorGen6.delayedSetup(HashAggTemplate.java:466) ~[na:na] at org.apache.drill.exec.test.generated.HashAggregatorGen6.doWork(HashAggTemplate.java:588) ~[na:na] at org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.innerNext(HashAggBatch.java:296) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:296) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:283) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at .......(:0) ~[na:na] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746) ~[hadoop-common-2.7.4.jar:na] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:283) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) ~[drill-common-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at .......(:0) ~[na:na] Caused by: java.util.concurrent.ExecutionException: org.apache.drill.exec.exception.ClassTransformationException: org.codehaus.commons.compiler.CompileException: Line 40, Column 48: A method named "getContext" is not declared in any enclosing class nor any supertype, nor through a static import at org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:502) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:461) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.util.concurrent.AbstractFuture$TrustedFuture.get(AbstractFuture.java:83) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:142) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2453) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2417) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2299) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2212) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.get(LocalCache.java:4147) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4151) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5140) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.exec.compile.CodeCompiler.createInstances(CodeCompiler.java:186) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] ... 27 common frames omitted Caused by: org.apache.drill.exec.exception.ClassTransformationException: org.codehaus.commons.compiler.CompileException: Line 40, Column 48: A method named "getContext" is not declared in any enclosing class nor any supertype, nor through a static import at org.apache.drill.exec.compile.ClassBuilder.getImplementationClass(ClassBuilder.java:117) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler$CodeGenCompiler.compile(CodeCompiler.java:73) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler.makeClass(CodeCompiler.java:229) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler.access$300(CodeCompiler.java:41) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler$Loader.load(CodeCompiler.java:212) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.CodeCompiler$Loader.load(CodeCompiler.java:209) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3708) ~[drill-shaded-guava-23.0.jar:23.0] at org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2416) ~[drill-shaded-guava-23.0.jar:23.0] ... 33 common frames omitted Caused by: java.lang.Exception: Line 40, Column 48: A method named "getContext" is not declared in any enclosing class nor any supertype, nor through a static import at org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:12211) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9084) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.getType2(UnitCompiler.java:7106) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$15800(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$22$2.visitMethodInvocation(UnitCompiler.java:6517) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$22$2.visitMethodInvocation(UnitCompiler.java:6490) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:5073) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$22.visitRvalue(UnitCompiler.java:6490) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$22.visitRvalue(UnitCompiler.java:6469) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$Rvalue.accept(Java.java:4116) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.getType(UnitCompiler.java:6469) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9026) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:5062) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$9100(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$16.visitMethodInvocation(UnitCompiler.java:4423) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$16.visitMethodInvocation(UnitCompiler.java:4396) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:5073) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4396) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:5662) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:3792) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$6100(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$13.visitAssignment(UnitCompiler.java:3754) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$13.visitAssignment(UnitCompiler.java:3734) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$Assignment.accept(Java.java:4477) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:3734) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2360) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$1800(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1494) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1487) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$ExpressionStatement.accept(Java.java:2874) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1553) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1493) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1487) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$Block.accept(Java.java:2779) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1487) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1567) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:3388) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1357) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1330) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:822) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:432) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:215) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:411) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:406) ~[janino-3.0.11.jar:na] at org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1414) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:406) ~[janino-3.0.11.jar:na] at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:378) ~[janino-3.0.11.jar:na] at org.apache.drill.exec.compile.JaninoClassCompiler.doCompile(JaninoClassCompiler.java:77) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.JaninoClassCompiler.compile(JaninoClassCompiler.java:62) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.ClassCompilerSelector.compile(ClassCompilerSelector.java:151) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.ClassBuilder.compileClass(ClassBuilder.java:155) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] at org.apache.drill.exec.compile.ClassBuilder.getImplementationClass(ClassBuilder.java:115) ~[drill-java-exec-1.17.0-SNAPSHOT.jar:1.17.0-SNAPSHOT] ... 40 common frames omitted {noformat} It fails because internally, cast from interval to varchar was added because there is no implementation for {{Hash32FunctionsWithSeed}} udf which accepts interval data types. But the code for hash aggregate does not provide {{Context}} for obtaining buffer to produce the cast, so it fails. -- This message was sent by Atlassian JIRA (v7.6.3#76005)