drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ruffacto (Jira)" <j...@apache.org>
Subject [jira] [Created] (DRILL-7769) Query successful in 1.17.0 fails in 1.18.SNAPSHOT
Date Thu, 23 Jul 2020 17:20:00 GMT
ruffacto created DRILL-7769:
-------------------------------

             Summary: Query successful in 1.17.0 fails in 1.18.SNAPSHOT
                 Key: DRILL-7769
                 URL: https://issues.apache.org/jira/browse/DRILL-7769
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning &amp; Optimization
    Affects Versions: 1.18.0
            Reporter: ruffacto


Simple queries like :
{code:java}
SELECT * FROM dfs.`/tmp/good.parquet`;

SELECT dd.`meta`.providerDealerId as dealer FROM dfs.`/tmp/good.parquet` as dd;
{code}
run successfully in 1.17.0, but fail in 1.18.SNAPSHOT.

 

Data is deeply nested but just selecting a single column still fails.

 

Detailed Error:
{code:java}
[Error Id: 87ee6fe3-9455-48c4-bf4c-1b007fc140b6 on 192.168.86.135:31010]        at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:125)        at
org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422)        at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96)        at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:273)        at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:243)        at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)        at
io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)        at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)        at
io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312)        at
io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)        at
io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)        at
io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)        at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)        at
io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911)        at
io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)        at
io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645)        at
io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580)        at
io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497)        at
io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459)        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131)        at
java.base/java.lang.Thread.run(Thread.java:835)Caused by: org.apache.drill.exec.work.foreman.ForemanException:
Unexpected exception during fragment initialization: Error while applying rule DrillScanRule,
args [rel#29:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[dfs, /Users/hernanru/Downloads/good.parquet])]        at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:301)        at .......(:0)Caused
by: java.lang.RuntimeException: Error while applying rule DrillScanRule, args [rel#29:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[dfs,
/Users/hernanru/Downloads/good.parquet])]        at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:235)        at
org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:633)        at
org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:327)        at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:405)        at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform(DefaultSqlHandler.java:351)        at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel(DefaultSqlHandler.java:245)        at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:308)        at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:173)        at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)        at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)        at
org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:140)        at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)        at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593)        at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274)        ...
1 common frames omittedCaused by: java.lang.NullPointerException:        at org.apache.drill.exec.store.parquet.BaseParquetMetadataProvider.lambda$getPartitionsMetadata$7(BaseParquetMetadataProvider.java:354)        at
.......(:0)        at org.apache.drill.exec.store.parquet.BaseParquetMetadataProvider.getPartitionsMetadata(BaseParquetMetadataProvider.java:342)        at
org.apache.drill.exec.store.parquet.BaseParquetMetadataProvider.initializeMetadata(BaseParquetMetadataProvider.java:206)        at
org.apache.drill.exec.store.parquet.BaseParquetMetadataProvider.init(BaseParquetMetadataProvider.java:170)        at
org.apache.drill.exec.metastore.store.parquet.ParquetTableMetadataProviderImpl.<init>(ParquetTableMetadataProviderImpl.java:95)        at
org.apache.drill.exec.metastore.store.parquet.ParquetTableMetadataProviderImpl.<init>(ParquetTableMetadataProviderImpl.java:48)        at
org.apache.drill.exec.metastore.store.parquet.ParquetTableMetadataProviderImpl$Builder.build(ParquetTableMetadataProviderImpl.java:415)        at
org.apache.drill.exec.store.parquet.ParquetGroupScan.<init>(ParquetGroupScan.java:150)        at
org.apache.drill.exec.store.parquet.ParquetGroupScan.<init>(ParquetGroupScan.java:120)        at
org.apache.drill.exec.store.parquet.ParquetFormatPlugin.getGroupScan(ParquetFormatPlugin.java:202)        at
org.apache.drill.exec.store.parquet.ParquetFormatPlugin.getGroupScan(ParquetFormatPlugin.java:79)        at
org.apache.drill.exec.store.dfs.FileSystemPlugin.getPhysicalScan(FileSystemPlugin.java:226)        at
org.apache.drill.exec.store.dfs.FileSystemPlugin.getPhysicalScan(FileSystemPlugin.java:209)        at
org.apache.drill.exec.planner.logical.DrillTable.getGroupScan(DrillTable.java:119)        at
org.apache.drill.exec.planner.common.DrillScanRelBase.<init>(DrillScanRelBase.java:51)        at
org.apache.drill.exec.planner.logical.DrillScanRel.<init>(DrillScanRel.java:76)        at
org.apache.drill.exec.planner.logical.DrillScanRel.<init>(DrillScanRel.java:65)        at
org.apache.drill.exec.planner.logical.DrillScanRel.<init>(DrillScanRel.java:58)        at
org.apache.drill.exec.planner.logical.DrillScanRule.onMatch(DrillScanRule.java:38)        at
org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:208)        ...
14 common frames omitted
{code}
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message