[ 
https://issues.apache.org/jira/browse/IOTDB-622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17094115#comment-17094115
 ] 

WangChao commented on IOTDB-622:
--------------------------------

Ok, that looks good.

 

I have one question, if the the database has two storage group: root.ln, 
root.a.b, when I want to count the total records, I should type

 

Select count(s1) from root level 3 or 4?  

 

Or only one stroage group, but has two device with different depth level: 
root.ln.d1, root.ln.gate.d2, how to count the total number of the storage group?

 

Actually, I don't like level, I think we should give group name to every level, 
then group by the group name, not the level number.

 

Maybe we should rethink the query grammar for user,  I think we could change 
the query grammar more like standard sql, and use a proxy to transfer old 
grammar to new query model, this also has downward compatibility.

 

 

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

Reply via email to