Hi, I have created an issue on jira. I’d like to fix it.
Thanks, Haonan Hou > On Apr 28, 2020, at 2:15 PM, Xiangdong Huang <saint...@gmail.com> wrote: > > Hi jialin, > > Thanks for pointing it out. > > You are right. In [1], "root" is level 0. We need to keep consistent in the > whole system. > > [1] > http://iotdb.apache.org/UserGuide/Master/5-Operation%20Manual/1-DDL%20Data%20Definition%20Language.html#count-timeseries > Best, > ----------------------------------- > Xiangdong Huang > School of Software, Tsinghua University > > 黄向东 > 清华大学 软件学院 > > > Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年4月28日周二 下午1:33写道： > >> Hi, >> >> There is a configoration in iotdb-engine.properties: >> >> # Storage group level when creating schema automatically is enabled >> # e.g. root.sg0.d1.s2 >> # we will set root.sg0 as the storage group if storage group level is >> 2 >> default_storage_group_level=2 >> >> The level of root is 1. We may need to change this. >> >> Thanks, >> -- >> Jialin Qiao >> School of Software, Tsinghua University >> >> 乔嘉林 >> 清华大学 软件学院 >> >>> -----原始邮件----- >>> 发件人: "WangChao (Jira)" <j...@apache.org> >>> 发送时间: 2020-04-28 12:30:00 (星期二) >>> 收件人: notificati...@iotdb.apache.org >>> 抄送: >>> 主题: [jira] [Commented] (IOTDB-622) count all records of the whole >> database >>> >>> >>> [ >> https://issues.apache.org/jira/browse/IOTDB-622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17094143#comment-17094143 >> ] >>> >>> WangChao commented on IOTDB-622: >>> -------------------------------- >>> >>> Ok, that seems reasonable. >>> >>> >>> >>> Maybe we could support level=0 to return total number of the database. >>> >>> >>> >>>> Actually you mean to call the tag name back. >>> >>> >>> >>> Yes，like tag name on every level, not the whole timeseries. >>> >>> >>> >>> level seems can't express those sqls: >>> >>> >>> >>> like root.sgcc.wf03.wt01, but I want to group by sgcc, wt01. >>> >>> >>> >>> Well, focus on this issue, level is enough, I will try to implement it. >>> >>> >>> >>>> count all records of the whole database >>>> --------------------------------------- >>>> >>>> Key: IOTDB-622 >>>> URL: https://issues.apache.org/jira/browse/IOTDB-622 >>>> Project: Apache IoTDB >>>> Issue Type: Improvement >>>> Components: Core/Engine >>>> Reporter: WangChao >>>> Assignee: WangChao >>>> Priority: Trivial >>>> >>>> Now the count function only count the number of every timeseries, it's >> useful to count the total record of the specific path. >>>> >>>> like: >>>> >>>> *_select count(*) from root.ln._** should return the total number of >> the records in storage group root.ln, but now it returns the number of each >> timeseries which is in root.ln. >>>> >>>> Please leave your opinion. >>>> >>> >>> >>> >>> -- >>> This message was sent by Atlassian Jira >>> (v8.3.4#803005) >>
