[ https://issues.apache.org/jira/browse/DRILL-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15949833#comment-15949833 ]
Rahul Challapalli commented on DRILL-5404: ------------------------------------------ Data set used : {code} { "rownum": 1, "bigintegercol": { "int_1": 1, "int_2": 2, "int_3": 3 }, "varcharcol": { "varchar_1": "abc", "varchar_2": "def", "varchar_3": "xyz" }, "boolcol": { "boolean_1": true, "boolean_2": false, "boolean_3": true }, "float8col": { "f8_1": 1.1, "f8_2": 2.2 }, "complex": [ { "col1": 3 }, { "col2": 2, "col3": 1 }, { "col1": 7 } ] } { "rownum": 2, "bigintegercol": { "int_1": 1, "int_2": 2 }, "varcharcol": { "varchar_1": "abcd" }, "boolcol": { "boolean_1": true }, "float8col": { "f8_1": 1.1, "f8_2": 2.2, "f8_3": 3.3 }, "complex": [ { "col2": 2, "col3": 1 }, { "col1": 7 } ] } { "rownum": 3, "bigintegercol": { "int_1": 1, "int_3": 3 }, "varcharcol": { "varchar_1": "abcde", "varchar_2": null, "varchar_3": "xyz", "varchar_4": "xyz2" }, "boolcol": { "boolean_1": true, "boolean_2": false }, "float8col": { "f8_1": 1.1, "f8_3": 6.6 }, "complex": [ { "col1": 2, "col3": 1 } ] } { "rownum": 4, "bigintegercol": { "int_2": 2, "int_3": 3 }, "varcharcol": { "varchar_1": "abc", "varchar_2": "def" }, "boolcol": { "boolean_1": true, "boolean_2": false, "boolean_3": null }, "float8col": { "f8_1": 1.1, "f8_2": 2.2 }, "complex": [ { "col1": 3, "col2": 2 }, { "col3": 1, "col1": 7 } ] } {code} > kvgen function only supports Simple maps as input > ------------------------------------------------- > > Key: DRILL-5404 > URL: https://issues.apache.org/jira/browse/DRILL-5404 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 1.10.0 > Reporter: Rahul Challapalli > > git.commit.id.abbrev=38ef562 > The below query did not fail when I ran it in isolation. However when I ran > the test suite at [1], which also contains the below query, by using 50 > threads submitting queries concurrently, I hit the below error. > {code} > select boolcol, bigintegercol, varcharcol, kvgen(bigintegercol), > kvgen(boolcol), kvgen(varcharcol) from `json_kvgenflatten/kvgen1.json` > Failed with exception > java.sql.SQLException: SYSTEM ERROR: DrillRuntimeException: kvgen function > only supports Simple maps as input > Fragment 0:0 > [Error Id: 953541c2-cf67-4d29-8d1c-ac3ff3c18f1f on qa-node182.qa.lab:31010] > (org.apache.drill.common.exceptions.DrillRuntimeException) kvgen function > only supports Simple maps as input > org.apache.drill.exec.expr.fn.impl.MappifyUtility.mappify():46 > org.apache.drill.exec.test.generated.ProjectorGen10361.doEval():45 > org.apache.drill.exec.test.generated.ProjectorGen10361.projectRecords():67 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():199 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():93 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():109 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.physical.impl.BaseRootExec.next():104 > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 > org.apache.drill.exec.physical.impl.BaseRootExec.next():94 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 > java.security.AccessController.doPrivileged():-2 > javax.security.auth.Subject.doAs():422 > org.apache.hadoop.security.UserGroupInformation.doAs():1595 > org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 > org.apache.drill.common.SelfCleaningRunnable.run():38 > java.util.concurrent.ThreadPoolExecutor.runWorker():1142 > java.util.concurrent.ThreadPoolExecutor$Worker.run():617 > java.lang.Thread.run():745 > at > org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489) > at > org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561) > at > org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895) > at > org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61) > at > oadd.org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473) > at > org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100) > at > oadd.org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477) > at > org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180) > at > oadd.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109) > at > oadd.org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130) > at > org.apache.drill.jdbc.impl.DrillStatementImpl.executeQuery(DrillStatementImpl.java:112) > at > org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:177) > at > org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:101) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: oadd.org.apache.drill.common.exceptions.UserRemoteException: > SYSTEM ERROR: DrillRuntimeException: kvgen function only supports Simple maps > as input > Fragment 0:0 > [Error Id: 953541c2-cf67-4d29-8d1c-ac3ff3c18f1f on qa-node182.qa.lab:31010] > (org.apache.drill.common.exceptions.DrillRuntimeException) kvgen function > only supports Simple maps as input > org.apache.drill.exec.expr.fn.impl.MappifyUtility.mappify():46 > org.apache.drill.exec.test.generated.ProjectorGen10361.doEval():45 > org.apache.drill.exec.test.generated.ProjectorGen10361.projectRecords():67 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():199 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():93 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():109 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.physical.impl.BaseRootExec.next():104 > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 > org.apache.drill.exec.physical.impl.BaseRootExec.next():94 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 > java.security.AccessController.doPrivileged():-2 > javax.security.auth.Subject.doAs():422 > org.apache.hadoop.security.UserGroupInformation.doAs():1595 > org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 > org.apache.drill.common.SelfCleaningRunnable.run():38 > java.util.concurrent.ThreadPoolExecutor.runWorker():1142 > java.util.concurrent.ThreadPoolExecutor$Worker.run():617 > java.lang.Thread.run():745 > at > oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) > at > oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343) > at > oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88) > at > oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) > at > oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244) > at > oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > at > oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) > at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) > at > oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > ... 1 more > {code} > [1] > https://github.com/mapr/drill-test-framework/tree/master/framework/resources/Functional/json/json_kvgenflatten -- This message was sent by Atlassian JIRA (v6.3.15#6346)