You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by 毛东方 <ma...@mails.tsinghua.edu.cn> on 2019/04/04 02:08:52 UTC
Reforma the output of TimeSeries in JSON
Hi,
Recently I found out that the output of TimeSeries metadata is not in standard JSON format, which creates difficulties for development of distributed version. As a result, I’m going to reformat the output of TImeSeries metadata inJSON, to make it in standard JSON format. The details of changes are as bellow:
BEFORE:
root:{
a:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
}
},
d1:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
}
},
b:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.b.d0
}
}
}
}
}
AFTER:
{
"root":[
{
"a":[
{
"d0":[
{
"s0":{
"args":{},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"d1":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"b":[
{
"d0":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.b.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
}
]
}
]
}
]
}
Best regards
——————————————————————————————————————————
毛东方
maodf17@mails.tsinghua.edu.cn
Re: Reforma the output of TimeSeries in JSON
Posted by Julian Feinauer <j....@pragmaticminds.de>.
Hi all,
I send this message especially as we have this discussion with the Calcite integration.
If we want to use Calcite as JDBC Frontend (which I highly suggest) then we have to handle things according to the (SQL) standard.
This means, that the result of this (Custom) Command would need a result type.
This could be a STRING with arbitrary format or a JSON which can be parsed by other programs or used in SQL directly (there is some JSON Support in the standard and also some in Calcite builtin).
So I highly recommend to consider this.
Julian
Am 04.04.19, 14:39 schrieb "Jiaye Wu" <wu...@gmail.com>:
Or just show the series names like other RDBMS did for show tables and show
databases.
Detail information of series can be shown when `describe <series/group>`.
Just a suggestion.
Thanks,
Jiaye
On Thu, Apr 4, 2019 at 8:35 PM Jiaye Wu <wu...@gmail.com> wrote:
> I think we should display human readable message for `show timeseries`. As
> it is a SQL command, maybe it is better to response a result *table* like
> other queries. I'am afraid JSON is too long for the CLI.
> JSON format is friendly for program to parse, so we can provide standard
> JSON message through RESTful API. Do we have plan for that?
>
> Thanks,
> Jiaye
>
> On Thu, Apr 4, 2019 at 5:14 PM Xiangdong Huang <sa...@gmail.com> wrote:
>
>> so, is the proposal of "time series schema with JSON format" rejected?
>> -----------------------------------
>> Xiangdong Huang
>> School of Software, Tsinghua University
>>
>> 黄向东
>> 清华大学 软件学院
>>
>>
>> 毛东方 <ma...@mails.tsinghua.edu.cn> 于2019年4月4日周四 下午4:23写道：
>>
>> > Hi,
>> >
>> > Thanks for XuYi’s suggestion, now I remove all the JSONArray, so the
>> > output will be:
>> >
>> > {
>> > "a":{
>> > "b":{
>> > "d0":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.b.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > }
>> > },
>> > "d0":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > },
>> > "s1":{
>> > "args":{},
>> > "StorageGroup":"root.a.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > },
>> > "d1":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.d1",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > },
>> > "s1":{
>> > "args":{},
>> > "StorageGroup":"root.a.d1",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > }
>> > }
>> > }
>> >
>> > ——————————————————————————————————
>> > 毛东方
>> > maodf17@mails.tsinghua.edu.cn
>> >
>> >
>> >
>> > > 在 2019年4月4日，下午2:57，徐毅 <xu...@126.com> 写道：
>> > >
>> > >
>> > >
>> > > Hi,
>> > >
>> > >
>> > > It seems you replace a object by using a list? Is it necessary?
>> > > By the way, in new format, what does
>> > ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
>> > >
>> > >
>> > > Thanks
>> > > XuYi
>> > > On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de>
>> wrote：
>> > > +1
>> > >
>> > > Von meinem Mobiltelefon gesendet
>> > >
>> > > -------- Ursprüngliche Nachricht --------
>> > > Betreff: Reforma the output of TimeSeries in JSON
>> > > Von: 毛东方
>> > > An: dev@iotdb.apache.org
>> > > Cc:
>> > >
>> > > Hi,
>> > >
>> > > Recently I found out that the output of TimeSeries metadata is not in
>> > standard JSON format, which creates difficulties for development of
>> > distributed version. As a result, I’m going to reformat the output of
>> > TImeSeries metadata inJSON, to make it in standard JSON format. The
>> details
>> > of changes are as bellow:
>> > >
>> > > BEFORE:
>> > >
>> > > root:{
>> > > a:{
>> > > d0:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d0
>> > > },
>> > > s1:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d0
>> > > }
>> > > },
>> > > d1:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d1
>> > > },
>> > > s1:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d1
>> > > }
>> > > },
>> > > b:{
>> > > d0:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.b.d0
>> > > }
>> > > }
>> > > }
>> > > }
>> > > }
>> > >
>> > >
>> > >
>> > > AFTER:
>> > >
>> > > {
>> > > "root":[
>> > > {
>> > > "a":[
>> > > {
>> > > "d0":[
>> > > {
>> > > "s0":{
>> > > "args":{},
>> > > "StorageGroup":"root.a.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > },
>> > > {
>> > > "s1":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > },
>> > > {
>> > > "d1":[
>> > > {
>> > > "s0":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d1",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > },
>> > > {
>> > > "s1":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d1",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > },
>> > > {
>> > > "b":[
>> > > {
>> > > "d0":[
>> > > {
>> > > "s0":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.b.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > >
>> > > Best regards
>> > > ——————————————————————————————————————————
>> > > 毛东方
>> > > maodf17@mails.tsinghua.edu.cn
>> > >
>> > >
>> > >
>> >
>> >
>>
>
Re: Reforma the output of TimeSeries in JSON
Posted by Jiaye Wu <wu...@gmail.com>.
Or just show the series names like other RDBMS did for show tables and show
databases.
Detail information of series can be shown when `describe <series/group>`.
Just a suggestion.
Thanks,
Jiaye
On Thu, Apr 4, 2019 at 8:35 PM Jiaye Wu <wu...@gmail.com> wrote:
> I think we should display human readable message for `show timeseries`. As
> it is a SQL command, maybe it is better to response a result *table* like
> other queries. I'am afraid JSON is too long for the CLI.
> JSON format is friendly for program to parse, so we can provide standard
> JSON message through RESTful API. Do we have plan for that?
>
> Thanks,
> Jiaye
>
> On Thu, Apr 4, 2019 at 5:14 PM Xiangdong Huang <sa...@gmail.com> wrote:
>
>> so, is the proposal of "time series schema with JSON format" rejected?
>> -----------------------------------
>> Xiangdong Huang
>> School of Software, Tsinghua University
>>
>> 黄向东
>> 清华大学 软件学院
>>
>>
>> 毛东方 <ma...@mails.tsinghua.edu.cn> 于2019年4月4日周四 下午4:23写道：
>>
>> > Hi,
>> >
>> > Thanks for XuYi’s suggestion, now I remove all the JSONArray, so the
>> > output will be:
>> >
>> > {
>> > "a":{
>> > "b":{
>> > "d0":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.b.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > }
>> > },
>> > "d0":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > },
>> > "s1":{
>> > "args":{},
>> > "StorageGroup":"root.a.d0",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > },
>> > "d1":{
>> > "s0":{
>> > "args":{},
>> > "StorageGroup":"root.a.d1",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > },
>> > "s1":{
>> > "args":{},
>> > "StorageGroup":"root.a.d1",
>> > "DataType":"INT32",
>> > "Compressor":"UNCOMPRESSED",
>> > "Encoding":"RLE"
>> > }
>> > }
>> > }
>> > }
>> >
>> > ——————————————————————————————————
>> > 毛东方
>> > maodf17@mails.tsinghua.edu.cn
>> >
>> >
>> >
>> > > 在 2019年4月4日，下午2:57，徐毅 <xu...@126.com> 写道：
>> > >
>> > >
>> > >
>> > > Hi,
>> > >
>> > >
>> > > It seems you replace a object by using a list? Is it necessary?
>> > > By the way, in new format, what does
>> > ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
>> > >
>> > >
>> > > Thanks
>> > > XuYi
>> > > On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de>
>> wrote：
>> > > +1
>> > >
>> > > Von meinem Mobiltelefon gesendet
>> > >
>> > > -------- Ursprüngliche Nachricht --------
>> > > Betreff: Reforma the output of TimeSeries in JSON
>> > > Von: 毛东方
>> > > An: dev@iotdb.apache.org
>> > > Cc:
>> > >
>> > > Hi,
>> > >
>> > > Recently I found out that the output of TimeSeries metadata is not in
>> > standard JSON format, which creates difficulties for development of
>> > distributed version. As a result, I’m going to reformat the output of
>> > TImeSeries metadata inJSON, to make it in standard JSON format. The
>> details
>> > of changes are as bellow:
>> > >
>> > > BEFORE:
>> > >
>> > > root:{
>> > > a:{
>> > > d0:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d0
>> > > },
>> > > s1:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d0
>> > > }
>> > > },
>> > > d1:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d1
>> > > },
>> > > s1:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.d1
>> > > }
>> > > },
>> > > b:{
>> > > d0:{
>> > > s0:{
>> > > DataType: INT32,
>> > > Encoding: RLE,
>> > > Compressor: UNCOMPRESSED,
>> > > args: {},
>> > > StorageGroup: root.a.b.d0
>> > > }
>> > > }
>> > > }
>> > > }
>> > > }
>> > >
>> > >
>> > >
>> > > AFTER:
>> > >
>> > > {
>> > > "root":[
>> > > {
>> > > "a":[
>> > > {
>> > > "d0":[
>> > > {
>> > > "s0":{
>> > > "args":{},
>> > > "StorageGroup":"root.a.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > },
>> > > {
>> > > "s1":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > },
>> > > {
>> > > "d1":[
>> > > {
>> > > "s0":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d1",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > },
>> > > {
>> > > "s1":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.d1",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > },
>> > > {
>> > > "b":[
>> > > {
>> > > "d0":[
>> > > {
>> > > "s0":{
>> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
>> > > "StorageGroup":"root.a.b.d0",
>> > > "DataType":"INT32",
>> > > "Compressor":"UNCOMPRESSED",
>> > > "Encoding":"RLE"
>> > > }
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > > ]
>> > > }
>> > >
>> > > Best regards
>> > > ——————————————————————————————————————————
>> > > 毛东方
>> > > maodf17@mails.tsinghua.edu.cn
>> > >
>> > >
>> > >
>> >
>> >
>>
>
Re: Reforma the output of TimeSeries in JSON
Posted by Jiaye Wu <wu...@gmail.com>.
I think we should display human readable message for `show timeseries`. As
it is a SQL command, maybe it is better to response a result *table* like
other queries. I'am afraid JSON is too long for the CLI.
JSON format is friendly for program to parse, so we can provide standard
JSON message through RESTful API. Do we have plan for that?
Thanks,
Jiaye
On Thu, Apr 4, 2019 at 5:14 PM Xiangdong Huang <sa...@gmail.com> wrote:
> so, is the proposal of "time series schema with JSON format" rejected?
> -----------------------------------
> Xiangdong Huang
> School of Software, Tsinghua University
>
> 黄向东
> 清华大学 软件学院
>
>
> 毛东方 <ma...@mails.tsinghua.edu.cn> 于2019年4月4日周四 下午4:23写道：
>
> > Hi,
> >
> > Thanks for XuYi’s suggestion, now I remove all the JSONArray, so the
> > output will be:
> >
> > {
> > "a":{
> > "b":{
> > "d0":{
> > "s0":{
> > "args":{},
> > "StorageGroup":"root.a.b.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > }
> > },
> > "d0":{
> > "s0":{
> > "args":{},
> > "StorageGroup":"root.a.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > },
> > "s1":{
> > "args":{},
> > "StorageGroup":"root.a.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > },
> > "d1":{
> > "s0":{
> > "args":{},
> > "StorageGroup":"root.a.d1",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > },
> > "s1":{
> > "args":{},
> > "StorageGroup":"root.a.d1",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > }
> > }
> > }
> >
> > ——————————————————————————————————
> > 毛东方
> > maodf17@mails.tsinghua.edu.cn
> >
> >
> >
> > > 在 2019年4月4日，下午2:57，徐毅 <xu...@126.com> 写道：
> > >
> > >
> > >
> > > Hi,
> > >
> > >
> > > It seems you replace a object by using a list? Is it necessary?
> > > By the way, in new format, what does
> > ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
> > >
> > >
> > > Thanks
> > > XuYi
> > > On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de> wrote：
> > > +1
> > >
> > > Von meinem Mobiltelefon gesendet
> > >
> > > -------- Ursprüngliche Nachricht --------
> > > Betreff: Reforma the output of TimeSeries in JSON
> > > Von: 毛东方
> > > An: dev@iotdb.apache.org
> > > Cc:
> > >
> > > Hi,
> > >
> > > Recently I found out that the output of TimeSeries metadata is not in
> > standard JSON format, which creates difficulties for development of
> > distributed version. As a result, I’m going to reformat the output of
> > TImeSeries metadata inJSON, to make it in standard JSON format. The
> details
> > of changes are as bellow:
> > >
> > > BEFORE:
> > >
> > > root:{
> > > a:{
> > > d0:{
> > > s0:{
> > > DataType: INT32,
> > > Encoding: RLE,
> > > Compressor: UNCOMPRESSED,
> > > args: {},
> > > StorageGroup: root.a.d0
> > > },
> > > s1:{
> > > DataType: INT32,
> > > Encoding: RLE,
> > > Compressor: UNCOMPRESSED,
> > > args: {},
> > > StorageGroup: root.a.d0
> > > }
> > > },
> > > d1:{
> > > s0:{
> > > DataType: INT32,
> > > Encoding: RLE,
> > > Compressor: UNCOMPRESSED,
> > > args: {},
> > > StorageGroup: root.a.d1
> > > },
> > > s1:{
> > > DataType: INT32,
> > > Encoding: RLE,
> > > Compressor: UNCOMPRESSED,
> > > args: {},
> > > StorageGroup: root.a.d1
> > > }
> > > },
> > > b:{
> > > d0:{
> > > s0:{
> > > DataType: INT32,
> > > Encoding: RLE,
> > > Compressor: UNCOMPRESSED,
> > > args: {},
> > > StorageGroup: root.a.b.d0
> > > }
> > > }
> > > }
> > > }
> > > }
> > >
> > >
> > >
> > > AFTER:
> > >
> > > {
> > > "root":[
> > > {
> > > "a":[
> > > {
> > > "d0":[
> > > {
> > > "s0":{
> > > "args":{},
> > > "StorageGroup":"root.a.d0",
> > > "DataType":"INT32",
> > > "Compressor":"UNCOMPRESSED",
> > > "Encoding":"RLE"
> > > }
> > > },
> > > {
> > > "s1":{
> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > > "StorageGroup":"root.a.d0",
> > > "DataType":"INT32",
> > > "Compressor":"UNCOMPRESSED",
> > > "Encoding":"RLE"
> > > }
> > > }
> > > ]
> > > },
> > > {
> > > "d1":[
> > > {
> > > "s0":{
> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > > "StorageGroup":"root.a.d1",
> > > "DataType":"INT32",
> > > "Compressor":"UNCOMPRESSED",
> > > "Encoding":"RLE"
> > > }
> > > },
> > > {
> > > "s1":{
> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > > "StorageGroup":"root.a.d1",
> > > "DataType":"INT32",
> > > "Compressor":"UNCOMPRESSED",
> > > "Encoding":"RLE"
> > > }
> > > }
> > > ]
> > > },
> > > {
> > > "b":[
> > > {
> > > "d0":[
> > > {
> > > "s0":{
> > > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > > "StorageGroup":"root.a.b.d0",
> > > "DataType":"INT32",
> > > "Compressor":"UNCOMPRESSED",
> > > "Encoding":"RLE"
> > > }
> > > }
> > > ]
> > > }
> > > ]
> > > }
> > > ]
> > > }
> > > ]
> > > }
> > >
> > > Best regards
> > > ——————————————————————————————————————————
> > > 毛东方
> > > maodf17@mails.tsinghua.edu.cn
> > >
> > >
> > >
> >
> >
>
Re: Reforma the output of TimeSeries in JSON
Posted by Xiangdong Huang <sa...@gmail.com>.
so, is the proposal of "time series schema with JSON format" rejected?
-----------------------------------
Xiangdong Huang
School of Software, Tsinghua University
黄向东
清华大学 软件学院
毛东方 <ma...@mails.tsinghua.edu.cn> 于2019年4月4日周四 下午4:23写道：
> Hi,
>
> Thanks for XuYi’s suggestion, now I remove all the JSONArray, so the
> output will be:
>
> {
> "a":{
> "b":{
> "d0":{
> "s0":{
> "args":{},
> "StorageGroup":"root.a.b.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> }
> },
> "d0":{
> "s0":{
> "args":{},
> "StorageGroup":"root.a.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> },
> "s1":{
> "args":{},
> "StorageGroup":"root.a.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> },
> "d1":{
> "s0":{
> "args":{},
> "StorageGroup":"root.a.d1",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> },
> "s1":{
> "args":{},
> "StorageGroup":"root.a.d1",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> }
> }
> }
>
> ——————————————————————————————————
> 毛东方
> maodf17@mails.tsinghua.edu.cn
>
>
>
> > 在 2019年4月4日，下午2:57，徐毅 <xu...@126.com> 写道：
> >
> >
> >
> > Hi,
> >
> >
> > It seems you replace a object by using a list? Is it necessary?
> > By the way, in new format, what does
> ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
> >
> >
> > Thanks
> > XuYi
> > On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de> wrote：
> > +1
> >
> > Von meinem Mobiltelefon gesendet
> >
> > -------- Ursprüngliche Nachricht --------
> > Betreff: Reforma the output of TimeSeries in JSON
> > Von: 毛东方
> > An: dev@iotdb.apache.org
> > Cc:
> >
> > Hi,
> >
> > Recently I found out that the output of TimeSeries metadata is not in
> standard JSON format, which creates difficulties for development of
> distributed version. As a result, I’m going to reformat the output of
> TImeSeries metadata inJSON, to make it in standard JSON format. The details
> of changes are as bellow:
> >
> > BEFORE:
> >
> > root:{
> > a:{
> > d0:{
> > s0:{
> > DataType: INT32,
> > Encoding: RLE,
> > Compressor: UNCOMPRESSED,
> > args: {},
> > StorageGroup: root.a.d0
> > },
> > s1:{
> > DataType: INT32,
> > Encoding: RLE,
> > Compressor: UNCOMPRESSED,
> > args: {},
> > StorageGroup: root.a.d0
> > }
> > },
> > d1:{
> > s0:{
> > DataType: INT32,
> > Encoding: RLE,
> > Compressor: UNCOMPRESSED,
> > args: {},
> > StorageGroup: root.a.d1
> > },
> > s1:{
> > DataType: INT32,
> > Encoding: RLE,
> > Compressor: UNCOMPRESSED,
> > args: {},
> > StorageGroup: root.a.d1
> > }
> > },
> > b:{
> > d0:{
> > s0:{
> > DataType: INT32,
> > Encoding: RLE,
> > Compressor: UNCOMPRESSED,
> > args: {},
> > StorageGroup: root.a.b.d0
> > }
> > }
> > }
> > }
> > }
> >
> >
> >
> > AFTER:
> >
> > {
> > "root":[
> > {
> > "a":[
> > {
> > "d0":[
> > {
> > "s0":{
> > "args":{},
> > "StorageGroup":"root.a.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > },
> > {
> > "s1":{
> > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > "StorageGroup":"root.a.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > }
> > ]
> > },
> > {
> > "d1":[
> > {
> > "s0":{
> > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > "StorageGroup":"root.a.d1",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > },
> > {
> > "s1":{
> > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > "StorageGroup":"root.a.d1",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > }
> > ]
> > },
> > {
> > "b":[
> > {
> > "d0":[
> > {
> > "s0":{
> > "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> > "StorageGroup":"root.a.b.d0",
> > "DataType":"INT32",
> > "Compressor":"UNCOMPRESSED",
> > "Encoding":"RLE"
> > }
> > }
> > ]
> > }
> > ]
> > }
> > ]
> > }
> > ]
> > }
> >
> > Best regards
> > ——————————————————————————————————————————
> > 毛东方
> > maodf17@mails.tsinghua.edu.cn
> >
> >
> >
>
>
Re: Reforma the output of TimeSeries in JSON
Posted by 毛东方 <ma...@mails.tsinghua.edu.cn>.
Hi,
Thanks for XuYi’s suggestion, now I remove all the JSONArray, so the output will be:
{
"a":{
"b":{
"d0":{
"s0":{
"args":{},
"StorageGroup":"root.a.b.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
},
"d0":{
"s0":{
"args":{},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
},
"s1":{
"args":{},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
"d1":{
"s0":{
"args":{},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
},
"s1":{
"args":{},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
}
}
——————————————————————————————————
毛东方
maodf17@mails.tsinghua.edu.cn
> 在 2019年4月4日，下午2:57，徐毅 <xu...@126.com> 写道：
>
>
>
> Hi,
>
>
> It seems you replace a object by using a list? Is it necessary?
> By the way, in new format, what does ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
>
>
> Thanks
> XuYi
> On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de> wrote：
> +1
>
> Von meinem Mobiltelefon gesendet
>
> -------- Ursprüngliche Nachricht --------
> Betreff: Reforma the output of TimeSeries in JSON
> Von: 毛东方
> An: dev@iotdb.apache.org
> Cc:
>
> Hi,
>
> Recently I found out that the output of TimeSeries metadata is not in standard JSON format, which creates difficulties for development of distributed version. As a result, I’m going to reformat the output of TImeSeries metadata inJSON, to make it in standard JSON format. The details of changes are as bellow:
>
> BEFORE:
>
> root:{
> a:{
> d0:{
> s0:{
> DataType: INT32,
> Encoding: RLE,
> Compressor: UNCOMPRESSED,
> args: {},
> StorageGroup: root.a.d0
> },
> s1:{
> DataType: INT32,
> Encoding: RLE,
> Compressor: UNCOMPRESSED,
> args: {},
> StorageGroup: root.a.d0
> }
> },
> d1:{
> s0:{
> DataType: INT32,
> Encoding: RLE,
> Compressor: UNCOMPRESSED,
> args: {},
> StorageGroup: root.a.d1
> },
> s1:{
> DataType: INT32,
> Encoding: RLE,
> Compressor: UNCOMPRESSED,
> args: {},
> StorageGroup: root.a.d1
> }
> },
> b:{
> d0:{
> s0:{
> DataType: INT32,
> Encoding: RLE,
> Compressor: UNCOMPRESSED,
> args: {},
> StorageGroup: root.a.b.d0
> }
> }
> }
> }
> }
>
>
>
> AFTER:
>
> {
> "root":[
> {
> "a":[
> {
> "d0":[
> {
> "s0":{
> "args":{},
> "StorageGroup":"root.a.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> },
> {
> "s1":{
> "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> "StorageGroup":"root.a.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> }
> ]
> },
> {
> "d1":[
> {
> "s0":{
> "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> "StorageGroup":"root.a.d1",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> },
> {
> "s1":{
> "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> "StorageGroup":"root.a.d1",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> }
> ]
> },
> {
> "b":[
> {
> "d0":[
> {
> "s0":{
> "args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
> "StorageGroup":"root.a.b.d0",
> "DataType":"INT32",
> "Compressor":"UNCOMPRESSED",
> "Encoding":"RLE"
> }
> }
> ]
> }
> ]
> }
> ]
> }
> ]
> }
>
> Best regards
> ——————————————————————————————————————————
> 毛东方
> maodf17@mails.tsinghua.edu.cn
>
>
>
Re: AW: Reforma the output of TimeSeries in JSON
Posted by 徐毅 <xu...@126.com>.
Hi,
It seems you replace a object by using a list? Is it necessary?
By the way, in new format, what does ""args":{"$ref":"$.root[0].a[0].d0[0].s0.args"}," mean ?
Thanks
XuYi
On 4/4/2019 12:23，Julian Feinauer<j....@pragmaticminds.de> wrote：
+1
Von meinem Mobiltelefon gesendet
-------- Ursprüngliche Nachricht --------
Betreff: Reforma the output of TimeSeries in JSON
Von: 毛东方
An: dev@iotdb.apache.org
Cc:
Hi,
Recently I found out that the output of TimeSeries metadata is not in standard JSON format, which creates difficulties for development of distributed version. As a result, I’m going to reformat the output of TImeSeries metadata inJSON, to make it in standard JSON format. The details of changes are as bellow:
BEFORE:
root:{
a:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
}
},
d1:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
}
},
b:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.b.d0
}
}
}
}
}
AFTER:
{
"root":[
{
"a":[
{
"d0":[
{
"s0":{
"args":{},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"d1":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"b":[
{
"d0":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.b.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
}
]
}
]
}
]
}
Best regards
——————————————————————————————————————————
毛东方
maodf17@mails.tsinghua.edu.cn
AW: Reforma the output of TimeSeries in JSON
Posted by Julian Feinauer <j....@pragmaticminds.de>.
+1
Von meinem Mobiltelefon gesendet
-------- Ursprüngliche Nachricht --------
Betreff: Reforma the output of TimeSeries in JSON
Von: 毛东方
An: dev@iotdb.apache.org
Cc:
Hi,
Recently I found out that the output of TimeSeries metadata is not in standard JSON format, which creates difficulties for development of distributed version. As a result, I’m going to reformat the output of TImeSeries metadata inJSON, to make it in standard JSON format. The details of changes are as bellow:
BEFORE:
root:{
a:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d0
}
},
d1:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
},
s1:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.d1
}
},
b:{
d0:{
s0:{
DataType: INT32,
Encoding: RLE,
Compressor: UNCOMPRESSED,
args: {},
StorageGroup: root.a.b.d0
}
}
}
}
}
AFTER:
{
"root":[
{
"a":[
{
"d0":[
{
"s0":{
"args":{},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"d1":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
},
{
"s1":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.d1",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
},
{
"b":[
{
"d0":[
{
"s0":{
"args":{"$ref":"$.root[0].a[0].d0[0].s0.args"},
"StorageGroup":"root.a.b.d0",
"DataType":"INT32",
"Compressor":"UNCOMPRESSED",
"Encoding":"RLE"
}
}
]
}
]
}
]
}
]
}
Best regards
――――――――――――――――――――――――――――――――――――――――――
毛东方
maodf17@mails.tsinghua.edu.cn