create partition function [pf_date](datetime) as range right for values('2018-03-13','2018-03-14','2018-03-15')
create partition scheme [ps_data1] as partition [pf_date] to ([primary],[20180313_d1],[20180314_d1],[20180315_d1],[primary])
create partition scheme [ps_data2] as partition [pf_date] to ([primary],[20180313_d2],[20180314_d2],[20180315_d2],[primary])
create table [T_Data1]
(
    [id] bigint(1,1) not null
   ,[DateTime] datetime not null
   ,[Param] varchar(50) not null
   ,[Value] varchar(100) not null
) on [ps_data1]([DateTime])
create table [T_Data2]
(
    [id] bigint(1,1) not null
   ,[DateTime] datetime not null
   ,[Param] varchar(50) not null
   ,[Value] varchar(100) not null
) on [ps_data2]([DateTime])

create table [T_Data1_20180314]
(
    [id] bigint(1,1) not null
   ,[DateTime] datetime not null
   ,[Param] varchar(50) not null
   ,[Value] varchar(100) not null
) on [ps_data1]([DateTime])
create table [T_Data2_20180314]
(
    [id] bigint(1,1) not null
   ,[DateTime] datetime not null
   ,[Param] varchar(50) not null
   ,[Value] varchar(100) not null
) on [ps_data2]([DateTime])
alter table [T_Data1] switch partition $partition.pg_date('2018-03-14') to [T_Data1_20180314]
alter table [T_Data2] switch partition $partition.pg_date('2018-03-14') to [T_Data2_20180314]
create index [idx_DateTime] on [T_Data1]([DateTime])
create index [idx_Param] on [T_Data1]([Param])
create index [idx_Value] on [T_Data1]([Value])
create index [idx_DateTime] on [T_Data2]([DateTime])
create index [idx_Param] on [T_Data2]([Param])
create index [idx_Value] on [T_Data2]([Value])