You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "Jialin Qiao (Jira)" <ji...@apache.org> on 2020/02/26 12:30:00 UTC

[jira] [Closed] (IOTDB-444) Enhanced wildcard query on device path

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

Jialin Qiao closed IOTDB-444.
-----------------------------
    Fix Version/s: 0.10.0-SNAPSHOT
       Resolution: Fixed

> Enhanced wildcard query on device path
> --------------------------------------
>
>                 Key: IOTDB-444
>                 URL: https://issues.apache.org/jira/browse/IOTDB-444
>             Project: Apache IoTDB
>          Issue Type: New Feature
>          Components: Core/Engine, Planner/SQLParser
>            Reporter: Xiangdong Huang
>            Assignee: Zesong Sun
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 0.10.0-SNAPSHOT
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> Hi,
> Now we have `show child paths PATH_PREFIX` to show the children nodes of the PREFIX PATH.
> However, sometimes we need more complex queries, like
> 1. show all path prefixes (level6) which start with "root.a.b.*.d" (level1=root, level2=a, and level3=b, level4 can be everything, and level5=d).
> 2. show all path prefixes which start with "root.a.b*" (level1= root, level2=a and level3 starts with b).
> 3. combine 1 and 2 together. e.g., "root.a.b*.**.d.**", etc..
> 4. For select queries, it is also good to support wildcard like "select * from root.a.**.b**" (which means that the level4 starts with 'b');
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)