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

["Xiangdong Huang (Jira)" <ji...@apache.org>]

Xiangdong Huang created IOTDB-444:
-------------------------------------

             Summary: 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


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", "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)