You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "Boris Zhu (Jira)" <ji...@apache.org> on 2020/01/11 16:39:00 UTC
[jira] [Commented] (IOTDB-414) Create Time series and show storage
group Statements can not execute successfully
[ https://issues.apache.org/jira/browse/IOTDB-414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013537#comment-17013537 ]
Boris Zhu commented on IOTDB-414:
---------------------------------
the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
> Create Time series and show storage group Statements can not execute successfully
> ----------------------------------------------------------------------------------
>
> Key: IOTDB-414
> URL: https://issues.apache.org/jira/browse/IOTDB-414
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: master branch
> Reporter: Xiangdong Huang
> Assignee: Boris Zhu
> Priority: Major
>
> Hi, current master branch has some issues for executing some sqls. e.g.,:
>
> IoTDB> show timeseries;
> show timeseries;
> +-------------+-------------+-------------+-------------+-------------+
> | timeseries|storage group| dataType| encoding| compression|
> +-------------+-------------+-------------+-------------+-------------+
> |root.sg1.d1.s1| root.sg1| INT64| RLE| SNAPPY|
> |root.sg1.d1.s2| root.sg1| INT64| RLE| SNAPPY|
> |root.sg1.d1.s3| root.sg1| INT64| RLE| SNAPPY|
> +-------------+-------------+-------------+-------------+-------------+
> Total line number = 3
> It costs 0.006s
> IoTDB> create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE, compression=SNAPPY;
> create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE, compression=SNAPPY;
> Msg: The resultDataType or encoding or compression of the last node s1 is conflicting in the storage group root.sg1
> It costs 0.003s
> IoTDB> show storage group;
> show storage group;
> Msg: column 2 does not exist
> It costs 0.001s
> # The create timeseries statement should be executed successfully.
> # what is the problem of "show storage group"?
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
Re: [jira] [Commented] (IOTDB-414) Create Time series and show
storage group Statements can not execute successfully
Posted by Boris Zhu <zh...@gmail.com>.
because of the wrong syntax, `create timeseries root.sg1.d2.s1 with
datatype=INT64, encoding=RLE, compression=SNAPPY` is equal to `create
timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE,
compressor=UNCOMPRESSED`
On Sun, Jan 12, 2020 at 12:51 AM Boris Zhu <zh...@gmail.com>
wrote:
> Why create two totally same time series? you mean error message isn't
> correct?
>
> On Sun, Jan 12, 2020 at 12:40 AM Xiangdong Huang <sa...@gmail.com>
> wrote:
>
>> > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
>>
>> But the error message is "The resultDataType or encoding or compression of
>> the last node s1 is conflicting in the storage group root.sg1" ...
>>
>> Best,
>> -----------------------------------
>> Xiangdong Huang
>> School of Software, Tsinghua University
>>
>> 黄向东
>> 清华大学 软件学院
>>
>>
>> Boris Zhu (Jira) <ji...@apache.org> 于2020年1月12日周日 上午12:39写道：
>>
>> >
>> > [
>> >
>> https://issues.apache.org/jira/browse/IOTDB-414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013537#comment-17013537
>> > ]
>> >
>> > Boris Zhu commented on IOTDB-414:
>> > ---------------------------------
>> >
>> > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
>> >
>> >
>> >
>> > > Create Time series and show storage group Statements can not execute
>> > successfully
>> > >
>> >
>> ----------------------------------------------------------------------------------
>> > >
>> > > Key: IOTDB-414
>> > > URL: https://issues.apache.org/jira/browse/IOTDB-414
>> > > Project: Apache IoTDB
>> > > Issue Type: Bug
>> > > Affects Versions: master branch
>> > > Reporter: Xiangdong Huang
>> > > Assignee: Boris Zhu
>> > > Priority: Major
>> > >
>> > > Hi, current master branch has some issues for executing some sqls.
>> e.g.,:
>> > >
>> > > IoTDB> show timeseries;
>> > > show timeseries;
>> > >
>> +-------------+-------------+-------------+-------------+-------------+
>> > > | timeseries|storage group| dataType| encoding| compression|
>> > >
>> +-------------+-------------+-------------+-------------+-------------+
>> > > |root.sg1.d1.s1| root.sg1| INT64| RLE| SNAPPY|
>> > > |root.sg1.d1.s2| root.sg1| INT64| RLE| SNAPPY|
>> > > |root.sg1.d1.s3| root.sg1| INT64| RLE| SNAPPY|
>> > >
>> +-------------+-------------+-------------+-------------+-------------+
>> > > Total line number = 3
>> > > It costs 0.006s
>> > > IoTDB> create timeseries root.sg1.d2.s1 with datatype=INT64,
>> > encoding=RLE, compression=SNAPPY;
>> > > create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE,
>> > compression=SNAPPY;
>> > > Msg: The resultDataType or encoding or compression of the last node s1
>> > is conflicting in the storage group root.sg1
>> > > It costs 0.003s
>> > > IoTDB> show storage group;
>> > > show storage group;
>> > > Msg: column 2 does not exist
>> > > It costs 0.001s
>> > > # The create timeseries statement should be executed successfully.
>> > > # what is the problem of "show storage group"?
>> > >
>> >
>> >
>> >
>> > --
>> > This message was sent by Atlassian Jira
>> > (v8.3.4#803005)
>> >
>>
>
Re: [jira] [Commented] (IOTDB-414) Create Time series and show
storage group Statements can not execute successfully
Posted by Jialin Qiao <qi...@apache.org>.
Hi,
It's not two totally the same time series, one is d1, another is d2.
Boris Zhu <zh...@gmail.com> 于2020年1月12日周日 上午12:52写道：
> Why create two totally same time series? you mean error message isn't
> correct?
>
> On Sun, Jan 12, 2020 at 12:40 AM Xiangdong Huang <sa...@gmail.com>
> wrote:
>
> > > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
> >
> > But the error message is "The resultDataType or encoding or compression
> of
> > the last node s1 is conflicting in the storage group root.sg1" ...
> >
> > Best,
> > -----------------------------------
> > Xiangdong Huang
> > School of Software, Tsinghua University
> >
> > 黄向东
> > 清华大学 软件学院
> >
> >
> > Boris Zhu (Jira) <ji...@apache.org> 于2020年1月12日周日 上午12:39写道：
> >
> > >
> > > [
> > >
> >
> https://issues.apache.org/jira/browse/IOTDB-414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013537#comment-17013537
> > > ]
> > >
> > > Boris Zhu commented on IOTDB-414:
> > > ---------------------------------
> > >
> > > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
> > >
> > >
> > >
> > > > Create Time series and show storage group Statements can not execute
> > > successfully
> > > >
> > >
> >
> ----------------------------------------------------------------------------------
> > > >
> > > > Key: IOTDB-414
> > > > URL: https://issues.apache.org/jira/browse/IOTDB-414
> > > > Project: Apache IoTDB
> > > > Issue Type: Bug
> > > > Affects Versions: master branch
> > > > Reporter: Xiangdong Huang
> > > > Assignee: Boris Zhu
> > > > Priority: Major
> > > >
> > > > Hi, current master branch has some issues for executing some sqls.
> > e.g.,:
> > > >
> > > > IoTDB> show timeseries;
> > > > show timeseries;
> > > >
> +-------------+-------------+-------------+-------------+-------------+
> > > > | timeseries|storage group| dataType| encoding| compression|
> > > >
> +-------------+-------------+-------------+-------------+-------------+
> > > > |root.sg1.d1.s1| root.sg1| INT64| RLE| SNAPPY|
> > > > |root.sg1.d1.s2| root.sg1| INT64| RLE| SNAPPY|
> > > > |root.sg1.d1.s3| root.sg1| INT64| RLE| SNAPPY|
> > > >
> +-------------+-------------+-------------+-------------+-------------+
> > > > Total line number = 3
> > > > It costs 0.006s
> > > > IoTDB> create timeseries root.sg1.d2.s1 with datatype=INT64,
> > > encoding=RLE, compression=SNAPPY;
> > > > create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE,
> > > compression=SNAPPY;
> > > > Msg: The resultDataType or encoding or compression of the last node
> s1
> > > is conflicting in the storage group root.sg1
> > > > It costs 0.003s
> > > > IoTDB> show storage group;
> > > > show storage group;
> > > > Msg: column 2 does not exist
> > > > It costs 0.001s
> > > > # The create timeseries statement should be executed successfully.
> > > > # what is the problem of "show storage group"?
> > > >
> > >
> > >
> > >
> > > --
> > > This message was sent by Atlassian Jira
> > > (v8.3.4#803005)
> > >
> >
>
--
—————————————————
Jialin Qiao
School of Software, Tsinghua University
乔嘉林
清华大学 软件学院
Re: [jira] [Commented] (IOTDB-414) Create Time series and show
storage group Statements can not execute successfully
Posted by Boris Zhu <zh...@gmail.com>.
Why create two totally same time series? you mean error message isn't
correct?
On Sun, Jan 12, 2020 at 12:40 AM Xiangdong Huang <sa...@gmail.com> wrote:
> > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
>
> But the error message is "The resultDataType or encoding or compression of
> the last node s1 is conflicting in the storage group root.sg1" ...
>
> Best,
> -----------------------------------
> Xiangdong Huang
> School of Software, Tsinghua University
>
> 黄向东
> 清华大学 软件学院
>
>
> Boris Zhu (Jira) <ji...@apache.org> 于2020年1月12日周日 上午12:39写道：
>
> >
> > [
> >
> https://issues.apache.org/jira/browse/IOTDB-414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013537#comment-17013537
> > ]
> >
> > Boris Zhu commented on IOTDB-414:
> > ---------------------------------
> >
> > the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
> >
> >
> >
> > > Create Time series and show storage group Statements can not execute
> > successfully
> > >
> >
> ----------------------------------------------------------------------------------
> > >
> > > Key: IOTDB-414
> > > URL: https://issues.apache.org/jira/browse/IOTDB-414
> > > Project: Apache IoTDB
> > > Issue Type: Bug
> > > Affects Versions: master branch
> > > Reporter: Xiangdong Huang
> > > Assignee: Boris Zhu
> > > Priority: Major
> > >
> > > Hi, current master branch has some issues for executing some sqls.
> e.g.,:
> > >
> > > IoTDB> show timeseries;
> > > show timeseries;
> > > +-------------+-------------+-------------+-------------+-------------+
> > > | timeseries|storage group| dataType| encoding| compression|
> > > +-------------+-------------+-------------+-------------+-------------+
> > > |root.sg1.d1.s1| root.sg1| INT64| RLE| SNAPPY|
> > > |root.sg1.d1.s2| root.sg1| INT64| RLE| SNAPPY|
> > > |root.sg1.d1.s3| root.sg1| INT64| RLE| SNAPPY|
> > > +-------------+-------------+-------------+-------------+-------------+
> > > Total line number = 3
> > > It costs 0.006s
> > > IoTDB> create timeseries root.sg1.d2.s1 with datatype=INT64,
> > encoding=RLE, compression=SNAPPY;
> > > create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE,
> > compression=SNAPPY;
> > > Msg: The resultDataType or encoding or compression of the last node s1
> > is conflicting in the storage group root.sg1
> > > It costs 0.003s
> > > IoTDB> show storage group;
> > > show storage group;
> > > Msg: column 2 does not exist
> > > It costs 0.001s
> > > # The create timeseries statement should be executed successfully.
> > > # what is the problem of "show storage group"?
> > >
> >
> >
> >
> > --
> > This message was sent by Atlassian Jira
> > (v8.3.4#803005)
> >
>
Re: [jira] [Commented] (IOTDB-414) Create Time series and show
storage group Statements can not execute successfully
Posted by Xiangdong Huang <sa...@gmail.com>.
> the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
But the error message is "The resultDataType or encoding or compression of
the last node s1 is conflicting in the storage group root.sg1" ...
Best,
-----------------------------------
Xiangdong Huang
School of Software, Tsinghua University
黄向东
清华大学 软件学院
Boris Zhu (Jira) <ji...@apache.org> 于2020年1月12日周日 上午12:39写道：
>
> [
> https://issues.apache.org/jira/browse/IOTDB-414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013537#comment-17013537
> ]
>
> Boris Zhu commented on IOTDB-414:
> ---------------------------------
>
> the correct syntax is compressor=SNAPPY instead of compression=SNAPPY.
>
>
>
> > Create Time series and show storage group Statements can not execute
> successfully
> >
> ----------------------------------------------------------------------------------
> >
> > Key: IOTDB-414
> > URL: https://issues.apache.org/jira/browse/IOTDB-414
> > Project: Apache IoTDB
> > Issue Type: Bug
> > Affects Versions: master branch
> > Reporter: Xiangdong Huang
> > Assignee: Boris Zhu
> > Priority: Major
> >
> > Hi, current master branch has some issues for executing some sqls. e.g.,:
> >
> > IoTDB> show timeseries;
> > show timeseries;
> > +-------------+-------------+-------------+-------------+-------------+
> > | timeseries|storage group| dataType| encoding| compression|
> > +-------------+-------------+-------------+-------------+-------------+
> > |root.sg1.d1.s1| root.sg1| INT64| RLE| SNAPPY|
> > |root.sg1.d1.s2| root.sg1| INT64| RLE| SNAPPY|
> > |root.sg1.d1.s3| root.sg1| INT64| RLE| SNAPPY|
> > +-------------+-------------+-------------+-------------+-------------+
> > Total line number = 3
> > It costs 0.006s
> > IoTDB> create timeseries root.sg1.d2.s1 with datatype=INT64,
> encoding=RLE, compression=SNAPPY;
> > create timeseries root.sg1.d2.s1 with datatype=INT64, encoding=RLE,
> compression=SNAPPY;
> > Msg: The resultDataType or encoding or compression of the last node s1
> is conflicting in the storage group root.sg1
> > It costs 0.003s
> > IoTDB> show storage group;
> > show storage group;
> > Msg: column 2 does not exist
> > It costs 0.001s
> > # The create timeseries statement should be executed successfully.
> > # what is the problem of "show storage group"?
> >
>
>
>
> --
> This message was sent by Atlassian Jira
> (v8.3.4#803005)
>