You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2021/06/04 04:06:00 UTC

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

    [ 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:#FF0000}start-cli.sh -e   SQL contains *   parser error{color}
> {color:#FF0000}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.777777,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),2,'lily2',25,'usa',5678.34,7.777777,false);
>  
> ./sbin/start-cli.sh{color:#FF0000} -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)