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" <[email protected]>: 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 <[email protected]> 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 <[email protected]> wrote: > >> so, is the proposal of "time series schema with JSON format" rejected? >> ----------------------------------- >> Xiangdong Huang >> School of Software, Tsinghua University >> >> 黄向东 >> 清华大学 软件学院 >> >> >> 毛东方 <[email protected]> 于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" >> > } >> > } >> > } >> > } >> > >> > —————————————————————————————————— >> > 毛东方 >> > [email protected] >> > >> > >> > >> > > 在 2019年4月4日，下午2:57，徐毅 <[email protected]> 写道： >> > > >> > > >> > > >> > > 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<[email protected]> >> wrote： >> > > +1 >> > > >> > > Von meinem Mobiltelefon gesendet >> > > >> > > -------- Ursprüngliche Nachricht -------- >> > > Betreff: Reforma the output of TimeSeries in JSON >> > > Von: 毛东方 >> > > An: [email protected] >> > > 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 >> > > —————————————————————————————————————————— >> > > 毛东方 >> > > [email protected] >> > > >> > > >> > > >> > >> > >> >
