Re: Re: An easier way to create time series.

2019-08-14 Thread Xiangdong Huang
e. > >> > >>Some feasible schema organization ways and "select * from the table" > results: > > > > >>(1) Each type of datasource is a table, which has a time column, > some tag columns and some field columns. > >> > >

Re: An easier way to create time series.

2019-08-14 Thread Julian Feinauer
> >>Table: source2(tag1=device2) >>time, field1, field2 >>2, 2, 2 >> >> >>Best, >>-- > >Jialin Qiao >>School of Software, Tsinghua University >> >>乔嘉林

Re:Re: An easier way to create time series.

2019-08-14 Thread Tian Jiang
rce1(tag1=device1) >>time, field1, field2 >>1, 1, 1 >>2, 2, 2 >> >>Table: source2(tag1=device2) >>time, field1, field2 > >2, 2, 2 > > >> >>Best, >>-- >>Jialin Qiao >>Sc

Re: An easier way to create time series.

2019-08-14 Thread Julian Feinauer
> >Best, >-- >Jialin Qiao >School of Software, Tsinghua University > >乔嘉林 >清华大学 软件学院 > >> -原始邮件- >> 发件人: "Julian Feinauer" >> 发送时间: 2019-08-14 16:10:22 (星期三) >> 收件人: &q

Re:Re: An easier way to create time series.

2019-08-14 Thread Tian Jiang
ice1) >time, field1, field2 >1, 1, 1 >2, 2, 2 > >Table: source2(tag1=device2) >time, field1, field2 >2, 2, 2 > > >Best, >-- >Jialin Qiao >School of Software, Tsinghua University > >乔嘉林 >清华大学 软件学院 > >> -原始邮件----- >> 发件人: "

Re: An easier way to create time series.

2019-08-14 Thread Jialin Qiao
送时间: 2019-08-14 16:10:22 (星期三) > 收件人: "dev@iotdb.apache.org" > 抄送: > 主题: Re: An easier way to create time series. > > Hi, > > let me stick in hier also. > One of the things which was at first a bit "unfamiliar" for me was this > device focus. > I

Re: An easier way to create time series.

2019-08-14 Thread Julian Feinauer
; If all datatypes(or encodings) are the same, you can write the equal form: >> >> CREATE DEVICE TEMPLATE vehicle MEASUREMENTS (speed, direction, >> temperature, fuel) DATATYPE DOUBLE ENCODING PLAIN >> >> Then you will be able to create time ser

Re:Re: An easier way to create time series.

2019-08-13 Thread Tian Jiang
DOUBLE PLAIN) >> >> If all datatypes(or encodings) are the same, you can write the equal form: >> >> CREATE DEVICE TEMPLATE vehicle MEASUREMENTS (speed, direction, >> temperature, fuel) DATATYPE DOUBLE ENCODING PLAIN >> >> Then you will be able to create time

Re: An easier way to create time series.

2019-08-13 Thread Xiangdong Huang
MEASUREMENTS (speed, direction, > temperature, fuel) DATATYPE DOUBLE ENCODING PLAIN > > Then you will be able to create time series in an easier way: > > CREATE DEVICE (vehicle) root.sg1.vehicle1 > > Which equals: > > CREATE TIMESERIES root.sg1.vehicle1.speed WITH > DATAT

An easier way to create time series.

2019-08-13 Thread Tian Jiang
DING PLAIN Then you will be able to create time series in an easier way: CREATE DEVICE (vehicle) root.sg1.vehicle1 Which equals: CREATE TIMESERIES root.sg1.vehicle1.speed WITH DATATYPE=DOUBLE,ENCODING=PLAIN CREATE TIMESERIES root.sg1.vehicle1.direction WITH DATATYPE=DOUBLE,ENCODING=PLA