[jira] [Commented] (IOTDB-1274) ./sbin/start-cli.sh -e 'select last * from root.*' Parser error : Msg: 401

2021-05-27 Thread Jira 


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

刘珍 commented on IOTDB-1274:
---

 ./sbin/start-cli.sh -p 6677 -e 'select last* from root'

*和前面的单词连着。可以执行。


> ./sbin/start-cli.sh -e 'select last * from root.*'  Parser error  : Msg: 401
> 
>
> Key: IOTDB-1274
> URL: https://issues.apache.org/jira/browse/IOTDB-1274
> Project: Apache IoTDB
>  Issue Type: Bug
>  Components: Client/CLI
>Reporter: 刘珍
>Priority: Minor
>
> 0.11.3  9e371454b05f9a0e24fabb2c84f7ce690f14a882
> {color:#FF}start-cli.sh -e   SQL contains *   parser error{color}
> {color:#FF}Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, 
> ',', '.'}{color}
>  
> set storage group root.db1;
> CREATE TIMESERIES root.db1.tab1.id WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.name WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN
>  
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),1,'lily',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),2,'lily2',25,'usa',5678.34,7.77,false);
>  
> ./sbin/start-cli.sh{color:#FF} -e{color} 'select last * from root.*'
> Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, ',', '.'}
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Commented] (IOTDB-1274) ./sbin/start-cli.sh -e 'select last * from root.*' Parser error : Msg: 401

2021-06-03 Thread Haonan Hou (Jira) 


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

Haonan Hou commented on IOTDB-1274:
---

[https://github.com/apache/iotdb/pull/3336]

 

> ./sbin/start-cli.sh -e 'select last * from root.*'  Parser error  : Msg: 401
> 
>
> Key: IOTDB-1274
> URL: https://issues.apache.org/jira/browse/IOTDB-1274
> Project: Apache IoTDB
>  Issue Type: Bug
>  Components: Client/CLI
>Reporter: 刘珍
>Priority: Minor
>
> 0.11.3  9e371454b05f9a0e24fabb2c84f7ce690f14a882
> {color:#FF}start-cli.sh -e   SQL contains *   parser error{color}
> {color:#FF}Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, 
> ',', '.'}{color}
>  
> set storage group root.db1;
> CREATE TIMESERIES root.db1.tab1.id WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.name WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN
>  
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),1,'lily',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),2,'lily2',25,'usa',5678.34,7.77,false);
>  
> ./sbin/start-cli.sh{color:#FF} -e{color} 'select last * from root.*'
> Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, ',', '.'}
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Commented] (IOTDB-1274) ./sbin/start-cli.sh -e 'select last * from root.*' Parser error : Msg: 401

2021-06-06 Thread Jira 


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

刘珍 commented on IOTDB-1274:
---

已解决。

> ./sbin/start-cli.sh -e 'select last * from root.*'  Parser error  : Msg: 401
> 
>
> Key: IOTDB-1274
> URL: https://issues.apache.org/jira/browse/IOTDB-1274
> Project: Apache IoTDB
>  Issue Type: Bug
>  Components: Client/CLI
>Reporter: 刘珍
>Priority: Minor
>
> 0.11.3  9e371454b05f9a0e24fabb2c84f7ce690f14a882
> {color:#FF}start-cli.sh -e   SQL contains *   parser error{color}
> {color:#FF}Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, 
> ',', '.'}{color}
>  
> set storage group to root.db1;
> CREATE TIMESERIES root.db1.tab1.id WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.name WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN
> CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN
>  
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),1,'lily',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),2,'lily2',25,'usa',5678.34,7.77,false);
>  
> ./sbin/start-cli.sh{color:#FF} -e{color} 'select last * from root.*'
> Msg: 401: line 1:18 mismatched input 'conf' expecting \{FROM, ',', '.'}
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)