如何知道某个节点下面的子路径，是节点，还是时间序列？ #3113

Activity

1. HTHou commented on May 12, 2021

   

   HTHou

   on May 12, 2021

   Contributor

   More actions

   Add a new sql show child timeseries root.xxx

   IoTDB> show timeseries
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   |      timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   |   root.sg.d1.s3| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |   root.sg.d1.s1| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |   root.sg.d1.s2| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |root.sg.d1.c1.s4| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |root.sg.d1.c1.s5| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   Total line number = 5
   It costs 0.026s
   
   IoTDB> show child paths root.sg.d1
   +-------------+
   |  child paths|
   +-------------+
   |root.sg.d1.s1|
   |root.sg.d1.s2|
   |root.sg.d1.s3|
   |root.sg.d1.c1|
   +-------------+
   Total line number = 4
   It costs 0.015s
   
   IoTDB> show child timeseries root.sg.d1
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   |      timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   |   root.sg.d1.s3| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |   root.sg.d1.s1| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   |   root.sg.d1.s2| null|      root.sg|   INT32|     RLE|     SNAPPY|null|      null|
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   Total line number = 3
   It costs 0.015s
   
   IoTDB> show child timeseries root.sg
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   |      timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   +----------------+-----+-------------+--------+--------+-----------+----+----------+
   Total line number = 0
   

   How do you think?
2. herowzz commented on May 18, 2021

   

   herowzz

   on May 18, 2021

   Author

   More actions

   我觉得是不是在 show child paths加一列属性比较好，不然我想拿下一级节点不要序列，得先执行show child path ，然后再执行show child timeseries，然后再过滤，这样感觉比较麻烦
3. apache

   locked and limited conversation to collaborators on Aug 31, 2021
4. qiaojialin

   closed this as completedon Aug 31, 2021