You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Minghui Liu (Jira)" <ji...@apache.org> on 2022/06/28 02:48:00 UTC
[jira] [Created] (IOTDB-3674) NPE when executing UDF with align by device query

|  ![](cid:jira-generated-image-avatar-f50c6fae-02d8-4b2a-964a-d83df29f5a1c) |
[Minghui
Liu](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=liuminghui)
**created** an issue  
---|---  
|  
---  
|  [Apache IoTDB](https://issues.apache.org/jira/browse/IOTDB) /
[![Bug](cid:jira-generated-image-
avatar-8f70b94c-e60f-4a0e-8d12-a5e0d98c2c40)](https://issues.apache.org/jira/browse/IOTDB-3674)
[IOTDB-3674](https://issues.apache.org/jira/browse/IOTDB-3674)  
---  
[NPE when executing UDF with align by device
query](https://issues.apache.org/jira/browse/IOTDB-3674)  
| Issue Type: |  ![Bug](cid:jira-generated-image-
avatar-8f70b94c-e60f-4a0e-8d12-a5e0d98c2c40) Bug  
---|---  
Affects Versions: |  0.14.0-SNAPSHOT  
Assignee: |  [Jinrui
Zhang](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=xingtanzjr)  
Attachments: |  image-2022-06-28-10-46-16-995.png  
Created: |  28/Jun/22 02:47  
Fix Versions: |  0.14.0-SNAPSHOT  
Priority: |  ![Major](cid:jira-generated-image-static-major-
cf86b92a-cd4e-452d-bbb3-c57a130fcd07) Major  
Reporter: |  [Minghui
Liu](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=liuminghui)  
|

SQL:

insert into root.sg.d1(time,s1,s2) values (1,1,1), (2,2,2);

insert into root.sg.d2(time,s1,s2) values (1,1,1), (2,2,2);

select s1 + 1, sin(s2) from root.sg.* align by device;



![13045765_image-2022-06-28-10-46-16-995.png](https://issues.apache.org/jira/secure/attachment/13045765/13045765_image-2022-06-28-10-46-16-995.png)



1C1D:

25409 [pool-23-IoTDB-RPC-Client-1] ERROR o.a.i.db.utils.ErrorHandlingUtils -
Status code: INTERNAL_SERVER_ERROR(500), operation: "select s1 + 1, sin(s2)
from root.sg.* align by device". executeStatement failed  
java.lang.NullPointerException: null  
    at org.apache.iotdb.db.mpp.plan.planner.plan.FragmentInstance.setDataRegionAndHost(FragmentInstance.java:81)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.produceFragmentInstance(SimpleFragmentParallelPlanner.java:102)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.prepare(SimpleFragmentParallelPlanner.java:78)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.parallelPlan(SimpleFragmentParallelPlanner.java:69)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragmentInstances(DistributionPlanner.java:92)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragments(DistributionPlanner.java:76)  
    at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.doDistributedPlan(QueryExecution.java:231)  
    at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.start(QueryExecution.java:165)  
    at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:131)  
    at org.apache.iotdb.db.service.thrift.impl.DataNodeTSIServiceImpl.executeStatement(DataNodeTSIServiceImpl.java:557)  
    at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeStatement.getResult(TSIService.java:2853)  
    at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeStatement.getResult(TSIService.java:2833)



Standalone:

68675 [pool-19-IoTDB-RPC-Client-1] ERROR o.a.i.db.utils.ErrorHandlingUtils -
Status code: INTERNAL_SERVER_ERROR(500), operation: "select s1 + 1, sin(s2)
from root.sg.* align by device". executeStatement failed  
java.lang.NullPointerException: null  
    at org.apache.iotdb.db.mpp.plan.planner.plan.FragmentInstance.setDataRegionAndHost(FragmentInstance.java:86)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.produceFragmentInstance(SimpleFragmentParallelPlanner.java:102)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.prepare(SimpleFragmentParallelPlanner.java:78)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.parallelPlan(SimpleFragmentParallelPlanner.java:69)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragmentInstances(DistributionPlanner.java:92)  
    at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragments(DistributionPlanner.java:76)  
    at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.doDistributedPlan(QueryExecution.java:231)  
    at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.start(QueryExecution.java:165)  
    at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:131)  
    at org.apache.iotdb.db.service.thrift.impl.DataNodeTSIServiceImpl.executeStatement(DataNodeTSIServiceImpl.java:557)  
    at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeStatement.getResult(TSIService.java:2853)  
    at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeStatement.getResult(TSIService.java:2833)  
  
---  
|  |  [ ![Add Comment](cid:jira-generated-image-static-comment-
icon-97e000d6-8e71-49e7-b2a2-bbb32c849158)
](https://issues.apache.org/jira/browse/IOTDB-3674#add-comment "Add Comment")
|  [Add Comment](https://issues.apache.org/jira/browse/IOTDB-3674#add-comment
"Add Comment")  
---|---  
  
|  This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)

If image attachments aren't displayed, see [this
article](https://confluence.atlassian.com/display/JIRAKB/Image+attachments+are+not+displayed+in+emails).

|  |  ![Atlassian logo](https://issues.apache.org/jira/images/mail/atlassian-
email-logo.png)  
---