[IOTDB-2602] Null Value Filter: support filtering based on partial columns

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: master branch
• Component/s: Core/Query
• Labels: pull-request-available
• Sprint: 2022-3-Tian
• Assignee: JiaXin Zhang
• Reporter: Minghui Liu
• Due: 11/Mar/22
• Created: 24/Feb/22 07:11
• Updated: 01/Jul/22 01:13
• Resolved: 13/Mar/22 14:13

Description

E.g.

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 

 

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

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 

Issue Links

• links to: GitHub Pull Request #5184
• links to: GitHub Pull Request #6541