[
https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14280574#comment-14280574
]
Victoria Markman commented on DRILL-1973:
-----------------------------------------
Problem can be reproduced with the TPCH query below in 0.8.0
#Mon Jan 12 18:19:31 EST 2015
git.commit.id.abbrev=5b012bf
{code}
select * from (
select * from (
select sum(1)
from cp.`tpch/orders.parquet` o
inner join
cp.`tpch/lineitem.parquet` l
on ( o.o_orderkey = l.l_orderkey )
having (count(1) > 0 )
) t limit 0
) `TableauSQL`
WHERE (0 = 1);
{code}
NPE details:
{code}
2015-01-16 17:55:05,994 [2b46af86-7992-9044-98aa-36f0b47364d4:frag:0:0] ERROR
o.a.d.e.w.f.AbstractStatusReporter - Error
afcaacfd-d9e9-4d38-bf47-882e67e57f4b: Failure while running fragment.
java.lang.NullPointerException: null
at
org.apache.drill.exec.vector.BigIntVector.transferTo(BigIntVector.java:205)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.vector.BigIntVector$TransferImpl.transfer(BigIntVector.java:237)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.test.generated.FiltererGen1145.doTransfers(FilterTemplate2.java:58)
~[na:na]
at
org.apache.drill.exec.test.generated.FiltererGen1145.filterBatch(FilterTemplate2.java:76)
~[na:na]
at
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:93)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.innerNext(RemovingRecordBatch.java:96)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:97)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:114)
~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_71]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_71]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71]
2015-01-16 17:55:06,011 [2b46af86-7992-9044-98aa-36f0b47364d4:frag:0:0] ERROR
o.a.drill.exec.work.foreman.Foreman - Error
160f3627-3c59-48ac-a8b8-05f581874e00: Query failed: Failure while running
fragment.[ afcaacfd-d9e9-4d38-bf47-882e67e57f4b on atsqa4-133.qa.lab:31010 ]
[ afcaacfd-d9e9-4d38-bf47-882e67e57f4b on atsqa4-133.qa.lab:31010 ]
org.apache.drill.exec.rpc.RemoteRpcException: Failure while running fragment.[
afcaacfd-d9e9-4d38-bf47-882e67e57f4b on atsqa4-133.qa.lab:31010 ]
[ afcaacfd-d9e9-4d38-bf47-882e67e57f4b on atsqa4-133.qa.lab:31010 ]
at
org.apache.drill.exec.work.foreman.QueryManager.statusUpdate(QueryManager.java:93)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.foreman.QueryManager$RootStatusReporter.statusChange(QueryManager.java:151)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:113)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.AbstractStatusReporter.fail(AbstractStatusReporter.java:109)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.internalFail(FragmentExecutor.java:166)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:129)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_71]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_71]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71]
{code}
> Tableau query causes parsing error
> ----------------------------------
>
> Key: DRILL-1973
> URL: https://issues.apache.org/jira/browse/DRILL-1973
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.7.0
> Reporter: Chris Matta
> Assignee: Aman Sinha
> Attachments: information_schema.views.txt
>
>
> Query:
> {code:sql}
> SELECT * FROM (
> SELECT SUM(1) AS `sum_Number_of_Records_ok`
> FROM `mfs.views`.`nestedclickview` `nestedclickview`
> INNER JOIN `mfs.views`.`productview` `productview` ON
> (`nestedclickview`.`prod_id` = `productview`.`prod_id`)
> HAVING (COUNT(1) > 0)
> ) T LIMIT 0;
> {code}
> The views are from Andy P's Drill demo:
> https://github.com/andypern/drill-beta-demo.git
> productview is a view into a MapR-DB table, and nestedclickview is a view for
> nested JSON data.
> I get the following error on the foreman:
> {code}
> 2015-01-09 16:08:43,042 [2b5002f4-cb62-1832-6331-ef89dbe2314b:foreman] ERROR
> o.a.drill.exec.work.foreman.Foreman - Error e0
> 295344-2881-4a81-b739-0e20026b21b1: Query failed: Failure parsing SQL.
> Encountered ")" at line 1, column 24.
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
