Versions Compared

Version Old Version 1 New Version Current
Changes made by

jake shin (Unlicensed)

jake shin (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

태그 데이터 삭제 제약 사항

마크베이스는 태그 테이블 전체에 대해서 특정 시간 이전의 전체 데이터에 대한 삭제만을 지원한다.

불가능한 태그 데이터 삭제 조건 

  • 특정 태그 데이터 만을 삭제
  • 특정 시간 범위의 데이터를 삭제
  • 특정 태그의 특정 시간 범위 데이터 삭제 

가능한 태그 데이터 삭제 조건

특정 시간 이전의 전체 태그에 대한 삭제 

Tag data deletion constraints

Machbase only supports deletion of data before a specific time.

Unsupported tag data deletion condition

  • Delete specific tag data

  • Delete data for a specific time range

  • Delete specific time range data for a specific tag

Supported tag data deletion condition

  • Delete all tags before a specific time



목차

Table of Contents
maxLevel3
indent30px
exclude목차
classtoc

DELETE

구문 수행 

문법

Syntax

Code Block
DELETE FROM TAG BEFORE TO_DATE('Time-string');

위에서 BEFORE 구문의 시간을 지정하면 그 시간 이전의 태그는 모두 삭제한다.

만일 BEFORE 구문을 지정하지 않는 경우에는 태그 테이블의 모든 데이터를 삭제한다.

일부 삭제 예제 

In the above example, if you specify the time of the BEFORE statement, all tags before that time are deleted.

If the BEFORE clause is not specified, all data in the tag table is deleted.

Example of some data deletion

Code Block
languagesql
# 현재Original 데이터Data
Mach> select * from tag;
NAME TIME VALUE
--------------------------------------------------------------------------------------
TAG_0001 2018-01-01 01:00:00 000:000:000 1
TAG_0001 2018-01-02 02:00:00 000:000:000 2
TAG_0001 2018-01-03 03:00:00 000:000:000 3
TAG_0001 2018-01-04 04:00:00 000:000:000 4
TAG_0001 2018-01-05 05:00:00 000:000:000 5
TAG_0001 2018-01-06 06:00:00 000:000:000 6
TAG_0001 2018-01-07 07:00:00 000:000:000 7
TAG_0001 2018-01-08 08:00:00 000:000:000 8
TAG_0001 2018-01-09 09:00:00 000:000:000 9
TAG_0001 2018-01-10 10:00:00 000:000:000 10
TAG_0002 2018-02-01 01:00:00 000:000:000 11
TAG_0002 2018-02-02 02:00:00 000:000:000 12
TAG_0002 2018-02-03 03:00:00 000:000:000 13
TAG_0002 2018-02-04 04:00:00 000:000:000 14
TAG_0002 2018-02-05 05:00:00 000:000:000 15
TAG_0002 2018-02-06 06:00:00 000:000:000 16
TAG_0002 2018-02-07 07:00:00 000:000:000 17
TAG_0002 2018-02-08 08:00:00 000:000:000 18
TAG_0002 2018-02-09 09:00:00 000:000:000 19
TAG_0002 2018-02-10 10:00:00 000:000:000 20
[20] row(s) selected.

Mach> delete from tag before to_date('2018-02-01');
10 row(s) deleted.

Mach> select * from tag;
NAME TIME VALUE
--------------------------------------------------------------------------------------
TAG_0002 2018-02-01 01:00:00 000:000:000 11
TAG_0002 2018-02-02 02:00:00 000:000:000 12
TAG_0002 2018-02-03 03:00:00 000:000:000 13
TAG_0002 2018-02-04 04:00:00 000:000:000 14
TAG_0002 2018-02-05 05:00:00 000:000:000 15
TAG_0002 2018-02-06 06:00:00 000:000:000 16
TAG_0002 2018-02-07 07:00:00 000:000:000 17
TAG_0002 2018-02-08 08:00:00 000:000:000 18
TAG_0002 2018-02-09 09:00:00 000:000:000 19
TAG_0002 2018-02-10 10:00:00 000:000:000 20
[10] row(s) selected.
전체 삭제 예제 


Example of deleting all data

Code Block
Mach> delete from tag;
10 row(s) deleted.

Mach> select * from tag;
NAME TIME VALUE
--------------------------------------------------------------------------------------
[0] row(s) selected.

위와 같이 모두 삭제 되었다All of tag data were deleted.

Delete ROLLUP

데이터의 삭제문법

Data

Example of deleting rollup data

Code Block
DELETE FROM TAG ROLLUP BEFORE TO_DATE('Time-string');

위에서 BEFORE 구문의 시간을 지정하면 그 시간 이전의 시, 분, 초 ROLLUP 데이터가 삭제된다.

만일 BEFORE 구문을 지정하지 않는 경우에는 ROLLUP의 모든 데이터를 삭제한다if you specify the time of the BEFORE statement, all rollup data before that time are deleted.

if you don't specify the  time of the BEFORE statement, all rollup data is deleted.