[ 
https://issues.apache.org/jira/browse/DRILL-6487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pritesh Maker reassigned DRILL-6487:
------------------------------------

    Assignee: Venkata Jyothsna Donapati

> Negative row count when selecting from a json file with an OFFSET clause
> ------------------------------------------------------------------------
>
>                 Key: DRILL-6487
>                 URL: https://issues.apache.org/jira/browse/DRILL-6487
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.13.0
>            Reporter: Boaz Ben-Zvi
>            Assignee: Venkata Jyothsna Donapati
>            Priority: Major
>             Fix For: 1.14.0
>
>
> This simple query fails: 
> {code}
> select * from dfs.`/data/foo.json` offset 1 row;
> {code}
> where foo.json is 
> {code}
> {"key": "aa", "sales": 11}
> {"key": "bb", "sales": 22}
> {code}
> The error returned is:
> {code}
> 0: jdbc:drill:zk=local> select * from dfs.`/data/foo.json` offset 1 row;
> Error: SYSTEM ERROR: AssertionError
> [Error Id: 960d66a9-b480-4a7e-9a25-beb4928e8139 on 10.254.130.25:31020]
>   (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception 
> during fragment initialization: null
>     org.apache.drill.exec.work.foreman.Foreman.run():282
>     java.util.concurrent.ThreadPoolExecutor.runWorker():1142
>     java.util.concurrent.ThreadPoolExecutor$Worker.run():617
>     java.lang.Thread.run():745
>   Caused By (java.lang.AssertionError) null
>     org.apache.calcite.rel.metadata.RelMetadataQuery.isNonNegative():900
>     org.apache.calcite.rel.metadata.RelMetadataQuery.validateResult():919
>     org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount():236
>     org.apache.calcite.rel.SingleRel.estimateRowCount():68
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier$MajorFragmentStat.add():103
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier.visitPrel():76
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier.visitPrel():32
>     
> org.apache.drill.exec.planner.physical.visitor.BasePrelVisitor.visitProject():50
>     org.apache.drill.exec.planner.physical.ProjectPrel.accept():98
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier.visitScreen():63
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier.visitScreen():32
>     org.apache.drill.exec.planner.physical.ScreenPrel.accept():65
>     
> org.apache.drill.exec.planner.physical.visitor.ExcessiveExchangeIdentifier.removeExcessiveEchanges():41
>     
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToPrel():557
>     org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():179
>     org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():145
>     org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():83
>     org.apache.drill.exec.work.foreman.Foreman.runSQL():567
>     org.apache.drill.exec.work.foreman.Foreman.run():264
>     java.util.concurrent.ThreadPoolExecutor.runWorker():1142
>     java.util.concurrent.ThreadPoolExecutor$Worker.run():617
>     java.lang.Thread.run():745 (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to