You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/04/30 04:29:04 UTC
[GitHub] [iotdb] herowzz opened a new issue #3113: 如何知道某个节点下面的子路径，是节点，还是时间序列？
herowzz opened a new issue #3113:
URL: https://github.com/apache/iotdb/issues/3113
show child paths 无法分辨下一级是不是timeseries
show timeseries 会把下面子节点以及子子节点所有路径下的都查出来
能否只查询当前节点下1级子节点呢？
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on issue #3113: 如何知道某个节点下面的子路径，是节点，还是时间序列？
Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #3113:
URL: https://github.com/apache/iotdb/issues/3113#issuecomment-839375824
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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] herowzz commented on issue #3113: 如何知道某个节点下面的子路径，是节点，还是时间序列？
Posted by GitBox <gi...@apache.org>.
herowzz commented on issue #3113:
URL: https://github.com/apache/iotdb/issues/3113#issuecomment-842747612
我觉得是不是在 show child paths加一列属性比较好，不然我想拿下一级节点不要序列，得先执行show child path ，然后再执行show child timeseries，然后再过滤，这样感觉比较麻烦
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin closed issue #3113: 如何知道某个节点下面的子路径，是节点，还是时间序列？
Posted by GitBox <gi...@apache.org>.
qiaojialin closed issue #3113:
URL: https://github.com/apache/iotdb/issues/3113
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin closed issue #3113: 如何知道某个节点下面的子路径，是节点，还是时间序列？
Posted by GitBox <gi...@apache.org>.
qiaojialin closed issue #3113:
URL: https://github.com/apache/iotdb/issues/3113
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org