Re: [DISCUSSION] The name of a UDF

[Yuan Tian]

Deduplicate actions just happen in query result not for the real stored data.

On Wed, Aug 3, 2022 at 9:10 AM Yuan Tian  wrote:
>
> Not really delete data, just remove the duplicated data continuously,
> like   , we will only keep 1 2 1.
>
> On Tue, Aug 2, 2022 at 8:28 PM Xiangdong Huang  wrote:
> >
> > A UDF to REMOVE data?  (with a query sql to delete data?)
> > ---
> > Xiangdong Huang
> > School of Software, Tsinghua University
> >
> >  黄向东
> > 清华大学 软件学院
> >
> > Zhou Yifu  于2022年8月2日周二 20:19写道：
> > >
> > > Hmm… ‘discontinuous’ is much like the antonym of the continuous rather 
> > > than ‘distinct’ in my opinion.
> > >
> > > Thanks,
> > > Yifu Zhou
> > >
> > > 获取 Outlook for iOS<https://aka.ms/o0ukef>
> > > ________
> > > 发件人: 18110526...@163.com <18110526...@163.com>
> > > 发送时间: Tuesday, August 2, 2022 7:36:04 PM
> > > 收件人: dev@iotdb.apache.org 
> > > 主题: Re: [DISCUSSION] The name of a UDF
> > >
> > > Hi,
> > >
> > > Thanks to reply.
> > > I have an another idea : ‘ discontinuous’. This name looks like distinct 
> > > but have a different meaning.
> > >
> > > Best,
> > > 
> > > Weihao Li
> > >
> > > > 2022年8月2日 18:53，Zhou Yifu  写道：
> > > >
> > > > How about duplicateFilter, which is kind of same as distinct.
> > > >
> > > > Thanks,
> > > > Yifu Zhou
> > > >
> > > > 获取 Outlook for iOS<https://aka.ms/o0ukef>
> > > > 
> > > > 发件人: Jialin Qiao 
> > > > 发送时间: Tuesday, August 2, 2022 6:08:53 PM
> > > > 收件人: dev@iotdb.apache.org 
> > > > 主题: Re: [DISCUSSION] The name of a UDF
> > > >
> > > > Hi,
> > > >
> > > > How about mutation
> > > >
> > > > Thanks,
> > > > Jialin Qiao
> > > >
> > > > On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> > > >> Hi everyone,
> > > >>
> > > >> We are developing a UDF to remove a sequence of consecutive identical 
> > > >> values (keeping only the first one), but have not come up with a 
> > > >> proper name for it. We can't name it ‘distinct' because it has a 
> > > >> different meaning. Here are some of the alternatives we came up with, 
> > > >> and if you have a better one, we are happy to discuss!
> > > >>
> > > >> 1.removeContinuous
> > > >> 2.removeConsecutiveIdentity
> > > >>
> > > >> The issue related:
> > > >>> https://github.com/apache/iotdb/issues/6751 
> > > >>> <https://github.com/apache/iotdb/issues/6751>
> > > >>
> > > >> Best,
> > > >> 
> > > >> Weihao Li
> > > >>
> > > >>
> > >

Re: [DISCUSSION] The name of a UDF

[Yuan Tian]

Not really delete data, just remove the duplicated data continuously,
like   , we will only keep 1 2 1.

On Tue, Aug 2, 2022 at 8:28 PM Xiangdong Huang  wrote:
>
> A UDF to REMOVE data?  (with a query sql to delete data?)
> ---
> Xiangdong Huang
> School of Software, Tsinghua University
>
>  黄向东
> 清华大学 软件学院
>
> Zhou Yifu  于2022年8月2日周二 20:19写道：
> >
> > Hmm… ‘discontinuous’ is much like the antonym of the continuous rather than 
> > ‘distinct’ in my opinion.
> >
> > Thanks,
> > Yifu Zhou
> >
> > 获取 Outlook for iOS<https://aka.ms/o0ukef>
> > 
> > 发件人: 18110526...@163.com <18110526...@163.com>
> > 发送时间: Tuesday, August 2, 2022 7:36:04 PM
> > 收件人: dev@iotdb.apache.org 
> > 主题: Re: [DISCUSSION] The name of a UDF
> >
> > Hi,
> >
> > Thanks to reply.
> > I have an another idea : ‘ discontinuous’. This name looks like distinct 
> > but have a different meaning.
> >
> > Best,
> > 
> > Weihao Li
> >
> > > 2022年8月2日 18:53，Zhou Yifu  写道：
> > >
> > > How about duplicateFilter, which is kind of same as distinct.
> > >
> > > Thanks,
> > > Yifu Zhou
> > >
> > > 获取 Outlook for iOS<https://aka.ms/o0ukef>
> > > 
> > > 发件人: Jialin Qiao 
> > > 发送时间: Tuesday, August 2, 2022 6:08:53 PM
> > > 收件人: dev@iotdb.apache.org 
> > > 主题: Re: [DISCUSSION] The name of a UDF
> > >
> > > Hi,
> > >
> > > How about mutation
> > >
> > > Thanks,
> > > Jialin Qiao
> > >
> > > On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> > >> Hi everyone,
> > >>
> > >> We are developing a UDF to remove a sequence of consecutive identical 
> > >> values (keeping only the first one), but have not come up with a proper 
> > >> name for it. We can't name it ‘distinct' because it has a different 
> > >> meaning. Here are some of the alternatives we came up with, and if you 
> > >> have a better one, we are happy to discuss!
> > >>
> > >> 1.removeContinuous
> > >> 2.removeConsecutiveIdentity
> > >>
> > >> The issue related:
> > >>> https://github.com/apache/iotdb/issues/6751 
> > >>> <https://github.com/apache/iotdb/issues/6751>
> > >>
> > >> Best,
> > >> 
> > >> Weihao Li
> > >>
> > >>
> >

Re: [DISCUSSION] The name of a UDF

[Yuan Tian]

Hi,

I also think that dedup is ok.


Best,

Yuan Tian

On Tue, Aug 2, 2022 at 3:32 PM 18110526...@163.com <18110526...@163.com> wrote:
>
> Hi everyone,
>
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss!
>
> 1.removeContinuous
> 2.removeConsecutiveIdentity
>
> The issue related:
> > https://github.com/apache/iotdb/issues/6751 
> > 
>
> Best,
> 
> Weihao Li
>

Re: [DISCUSSION] The name of a UDF

[Trevor Hart]

In Windows OS that kind of action is referred to as "deduplication" or dedup.





Thanks 

Trevor Hart

Ope Limited

w: http://www.ope.nz/

m: +64212728039








 On Wed, 03 Aug 2022 01:47:08 +1200 Jialin Qiao  
wrote ---



Hi, 
 
change_points may be a good option. 
 
Refer to https://help.aliyun.com/document_detail/93197.html 
 
Thanks, 
Jialin Qiao 
 
On 2022/08/02 07:32:19 "mailto:18110526...@163.com; wrote: 
> Hi everyone, 
> 
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss! 
> 
> 1.removeContinuous 
> 2.removeConsecutiveIdentity 
> 
> The issue related: 
> > https://github.com/apache/iotdb/issues/6751 
> >  
> 
> Best, 
>  
> Weihao Li 
> 
>

Re: [DISCUSSION] The name of a UDF

[Jialin Qiao]

Hi,

change_points may be a good option.

Refer to https://help.aliyun.com/document_detail/93197.html

Thanks,
Jialin Qiao

On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> Hi everyone,
> 
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss!
> 
> 1.removeContinuous
> 2.removeConsecutiveIdentity
> 
> The issue related:
> > https://github.com/apache/iotdb/issues/6751 
> > 
> 
> Best,
> 
> Weihao Li
> 
> 

Re: [DISCUSSION] The name of a UDF

[Xiangdong Huang]

A UDF to REMOVE data?  (with a query sql to delete data?)
---
Xiangdong Huang
School of Software, Tsinghua University

 黄向东
清华大学 软件学院

Zhou Yifu  于2022年8月2日周二 20:19写道：
>
> Hmm… ‘discontinuous’ is much like the antonym of the continuous rather than 
> ‘distinct’ in my opinion.
>
> Thanks,
> Yifu Zhou
>
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> 
> 发件人: 18110526...@163.com <18110526...@163.com>
> 发送时间: Tuesday, August 2, 2022 7:36:04 PM
> 收件人: dev@iotdb.apache.org 
> 主题: Re: [DISCUSSION] The name of a UDF
>
> Hi,
>
> Thanks to reply.
> I have an another idea : ‘ discontinuous’. This name looks like distinct but 
> have a different meaning.
>
> Best,
> 
> Weihao Li
>
> > 2022年8月2日 18:53，Zhou Yifu  写道：
> >
> > How about duplicateFilter, which is kind of same as distinct.
> >
> > Thanks,
> > Yifu Zhou
> >
> > 获取 Outlook for iOS<https://aka.ms/o0ukef>
> > ____________
> > 发件人: Jialin Qiao 
> > 发送时间: Tuesday, August 2, 2022 6:08:53 PM
> > 收件人: dev@iotdb.apache.org 
> > 主题: Re: [DISCUSSION] The name of a UDF
> >
> > Hi,
> >
> > How about mutation
> >
> > Thanks,
> > Jialin Qiao
> >
> > On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> >> Hi everyone,
> >>
> >> We are developing a UDF to remove a sequence of consecutive identical 
> >> values (keeping only the first one), but have not come up with a proper 
> >> name for it. We can't name it ‘distinct' because it has a different 
> >> meaning. Here are some of the alternatives we came up with, and if you 
> >> have a better one, we are happy to discuss!
> >>
> >> 1.removeContinuous
> >> 2.removeConsecutiveIdentity
> >>
> >> The issue related:
> >>> https://github.com/apache/iotdb/issues/6751 
> >>> <https://github.com/apache/iotdb/issues/6751>
> >>
> >> Best,
> >> 
> >> Weihao Li
> >>
> >>
>

Re: [DISCUSSION] The name of a UDF

[Zhou Yifu]

Hmm… ‘discontinuous’ is much like the antonym of the continuous rather than 
‘distinct’ in my opinion.

Thanks,
Yifu Zhou

获取 Outlook for iOS<https://aka.ms/o0ukef>

发件人: 18110526...@163.com <18110526...@163.com>
发送时间: Tuesday, August 2, 2022 7:36:04 PM
收件人: dev@iotdb.apache.org 
主题: Re: [DISCUSSION] The name of a UDF

Hi,

Thanks to reply.
I have an another idea : ‘ discontinuous’. This name looks like distinct but 
have a different meaning.

Best,

Weihao Li

> 2022年8月2日 18:53，Zhou Yifu  写道：
>
> How about duplicateFilter, which is kind of same as distinct.
>
> Thanks,
> Yifu Zhou
>
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> 
> 发件人: Jialin Qiao 
> 发送时间: Tuesday, August 2, 2022 6:08:53 PM
> 收件人: dev@iotdb.apache.org 
> 主题: Re: [DISCUSSION] The name of a UDF
>
> Hi,
>
> How about mutation
>
> Thanks,
> Jialin Qiao
>
> On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
>> Hi everyone,
>>
>> We are developing a UDF to remove a sequence of consecutive identical values 
>> (keeping only the first one), but have not come up with a proper name for 
>> it. We can't name it ‘distinct' because it has a different meaning. Here are 
>> some of the alternatives we came up with, and if you have a better one, we 
>> are happy to discuss!
>>
>> 1.removeContinuous
>> 2.removeConsecutiveIdentity
>>
>> The issue related:
>>> https://github.com/apache/iotdb/issues/6751 
>>> <https://github.com/apache/iotdb/issues/6751>
>>
>> Best,
>> 
>> Weihao Li
>>
>>

Re: [DISCUSSION] The name of a UDF

[18110526...@163.com]

Hi,

Thanks to reply. 
I have an another idea : ‘ discontinuous’. This name looks like distinct but 
have a different meaning.

Best,

Weihao Li

> 2022年8月2日 18:53，Zhou Yifu  写道：
> 
> How about duplicateFilter, which is kind of same as distinct.
> 
> Thanks,
> Yifu Zhou
> 
> 获取 Outlook for iOS<https://aka.ms/o0ukef>
> 
> 发件人: Jialin Qiao 
> 发送时间: Tuesday, August 2, 2022 6:08:53 PM
> 收件人: dev@iotdb.apache.org 
> 主题: Re: [DISCUSSION] The name of a UDF
> 
> Hi,
> 
> How about mutation
> 
> Thanks,
> Jialin Qiao
> 
> On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
>> Hi everyone,
>> 
>> We are developing a UDF to remove a sequence of consecutive identical values 
>> (keeping only the first one), but have not come up with a proper name for 
>> it. We can't name it ‘distinct' because it has a different meaning. Here are 
>> some of the alternatives we came up with, and if you have a better one, we 
>> are happy to discuss!
>> 
>> 1.removeContinuous
>> 2.removeConsecutiveIdentity
>> 
>> The issue related:
>>> https://github.com/apache/iotdb/issues/6751 
>>> <https://github.com/apache/iotdb/issues/6751>
>> 
>> Best,
>> 
>> Weihao Li
>> 
>> 

Re: [DISCUSSION] The name of a UDF

[Zhou Yifu]

How about duplicateFilter, which is kind of same as distinct.

Thanks,
Yifu Zhou

获取 Outlook for iOS<https://aka.ms/o0ukef>

发件人: Jialin Qiao 
发送时间: Tuesday, August 2, 2022 6:08:53 PM
收件人: dev@iotdb.apache.org 
主题: Re: [DISCUSSION] The name of a UDF

Hi,

How about mutation

Thanks,
Jialin Qiao

On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> Hi everyone,
>
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss!
>
> 1.removeContinuous
> 2.removeConsecutiveIdentity
>
> The issue related:
> > https://github.com/apache/iotdb/issues/6751 
> > <https://github.com/apache/iotdb/issues/6751>
>
> Best,
> 
> Weihao Li
>
>

Re: [DISCUSSION] The name of a UDF

[Jialin Qiao]

Hi,

How about mutation

Thanks,
Jialin Qiao

On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> Hi everyone,
> 
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss!
> 
> 1.removeContinuous
> 2.removeConsecutiveIdentity
> 
> The issue related:
> > https://github.com/apache/iotdb/issues/6751 
> > 
> 
> Best,
> 
> Weihao Li
> 
> 

Re: [DISCUSSION] The name of a UDF

[Jialin Qiao]

Hi,

How about variation?

select variation(s1) from root.sg.d1

Thanks,
Jialin Qiao

On 2022/08/02 07:32:19 "18110526...@163.com" wrote:
> Hi everyone,
> 
> We are developing a UDF to remove a sequence of consecutive identical values 
> (keeping only the first one), but have not come up with a proper name for it. 
> We can't name it ‘distinct' because it has a different meaning. Here are some 
> of the alternatives we came up with, and if you have a better one, we are 
> happy to discuss!
> 
> 1.removeContinuous
> 2.removeConsecutiveIdentity
> 
> The issue related:
> > https://github.com/apache/iotdb/issues/6751 
> > 
> 
> Best,
> 
> Weihao Li
> 
> 

[DISCUSSION] The name of a UDF

[18110526...@163.com]

Hi everyone,

We are developing a UDF to remove a sequence of consecutive identical values 
(keeping only the first one), but have not come up with a proper name for it. 
We can't name it ‘distinct' because it has a different meaning. Here are some 
of the alternatives we came up with, and if you have a better one, we are happy 
to discuss!

1.removeContinuous
2.removeConsecutiveIdentity

The issue related:
> https://github.com/apache/iotdb/issues/6751 
> 

Best,

Weihao Li