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

JiaXin Zhang reassigned IOTDB-2602:
-----------------------------------

    Assignee: JiaXin Zhang  (was: Minghui Liu)

> Null Value Filter: support filtering based on partial columns
> -------------------------------------------------------------
>
>                 Key: IOTDB-2602
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2602
>             Project: Apache IoTDB
>          Issue Type: New Feature
>          Components: Core/Query
>            Reporter: Minghui Liu
>            Assignee: JiaXin Zhang
>            Priority: Major
>             Fix For: master branch
>
>   Original Estimate: 32h
>  Remaining Estimate: 32h
>
> E.g.
> {code:java}
> IoTDB> select * from root.sg1.d1
> +----+--------------+--------------+--------------+
> |Time|root.sg1.d1.s1|root.sg1.d1.s2|root.sg1.d1.s3|
> +----+--------------+--------------+--------------+
> |   0|         1|          2|         3|
> |   1|       null|          2|         3|
> |   2|         1|        null|         3|
> |   3|         1|          2|       null|
> +----+--------------+--------------+--------------+
> Total line number = 4
> It costs 0.006s {code}
>  
> {code:java}
> IoTDB> select * from root.sg1.d1 without null any 
> +----+--------------+--------------+--------------+
> |Time|root.sg1.d1.s1|root.sg1.d1.s2|root.sg1.d1.s3|
> +----+--------------+--------------+--------------+
> |   0|         1|          2|          3| 
> +----+--------------+--------------+--------------+
> Total line number = 1
> It costs 0.04s{code}
> {code:java}
> IoTDB> select * from root.sg1.d1 without null any (s1, s2) 
> +----+--------------+--------------+--------------+
> |Time|root.sg1.d1.s1|root.sg1.d1.s2|root.sg1.d1.s3|
> +----+--------------+--------------+--------------+
> |   0|         1|          2|         3|
> |   3|         1|          2|       null|
> +----+--------------+--------------+--------------+
> Total line number = 2 
> It costs 0.006s {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to