SELECT pd.start_time, pd.end_time, td.time, pd.name
FROM process_data pd, tag td
WHERE pd.name = td.name
 AND td.time BETWEEN pd.start_time AND pd.end_time
 AND td.name = '1';

SELECT * FROM tag WHERE name LIKE 'TAG!%';

CREATE TAGDATA TABLE TAG (name VARCHAR(20) PRIMARY KEY, 
                          time DATETIME BASETIME, 
                          value DOUBLE SUMMARIZED);
INSERT INTO TAG METADATA VALUES ('TAG-A');

-- 아래 데이터를 APPEND 로 입력할 때엔, 
-- TAG-B 는 저장되어 있지 않지만 입력이 성공한다.
--   ('TAG-B', '2019-03-01 01:23:45', 36.5)

현재는 APPEND 에서만 지원되며, INSERT 는 추후 패치를 통해 지원될 예정입니다.

    if (SQLPrepare(sStmt, 
           (SQLCHAR *)"INSERT INTO TAG VALUES (?, '2010-01-01', 1.0)", 
           SQL_NTS) == SQL_ERROR) {
        printf("Prepare error\n");
    }

    if (SQLBindParameter(sStmt,
                         1,
                         SQL_PARAM_INPUT,
                         SQL_C_CHAR,
                         SQL_VARCHAR,
                         0,
                         0,
                         tagnameData,
                         0,
                         &tagnameDataSize) == SQL_ERROR) {
        printf("Bind error tag name");
    }

    if (SQLPrepare(sStmt, 
           (SQLCHAR *)"SELECT * FROM tab1 DURATION ? SECOND", 
           SQL_NTS) == SQL_ERROR) {
        printf("Prepare error\n");
    }

    if (SQLBindParameter(sStmt,
                         1,
                         SQL_PARAM_INPUT,
                         SQL_C_UBIGINT,
                         SQL_INTEGER,
                         0,
                         0,
                         &sSecond,
                         0,
                         NULL) == SQL_ERROR) {
        printf("Bind error tag name");
    }

$ cat alert-2018_12_19_18_21_59.trc 

[2018-12-19 18:12:51]
[WARN] Storage space exhausted...
	1019Giga, 476Mega, 376832 bytes total.
	346Giga, 643Mega, 421888 bytes used.
	(34.0%) used, (66.0%) free, (34.0%) cap.

[2018-12-19 18:12:55]
[INFO] Storage space secured...
	1019Giga, 476Mega, 376832 bytes total.
	337Giga, 295Mega, 339968 bytes used.
	(33.1%) used, (66.9%) free, (34.0%) cap.

[2018-12-19 18:21:59]
[STARTUP]

[2019-02-19 18:45:04 P-19295 T-139902498887424][INFO] Session is opened (Client IP : 192.168.0.31)
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (PREPARE): 0.173(ms) [insert into tag metadata values ('TAG_1', 'this is first!',  10, '192.168.0.1',  '2010-01-01')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (EXECUTE): 8.986(ms) [insert into tag metadata values ('TAG_1', 'this is first!',  10, '192.168.0.1',  '2010-01-01')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (PREPARE): 0.094(ms) [insert into tag metadata values ('TAG!_2', 'this is second.', 20, '192.168.1.20', '2009-01-02')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (EXECUTE): 9.128(ms) [insert into tag metadata values ('TAG!_2', 'this is second.', 20, '192.168.1.20', '2009-01-02')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (PREPARE): 0.093(ms) [insert into tag metadata values ('TAG!_4', 'this is fourth?',  40, null, '2008-01-03 12:00:00')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (EXECUTE): 9.223(ms) [insert into tag metadata values ('TAG!_4', 'this is fourth?',  40, null, '2008-01-03 12:00:00')]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (PREPARE): 0.105(ms) [insert into tag metadata values ('TAG_5', null,  50, '192.168.2.50', null)]
[2019-02-19 18:45:05 P-19295 T-139902498887424][MM] Elapsed time (EXECUTE): 9.167(ms) [insert into tag metadata values ('TAG_5', null,  50, '192.168.2.50', null)]
[2019-02-19 18:45:05 P-19295 T-139902375159552][INFO] Session is opened (Client IP : 192.168.0.31)
[2019-02-19 18:45:05 P-19295 T-139902375159552][MM] Append Open. (TAG)
[2019-02-19 18:45:05 P-19295 T-139902375159552][MM] Append Close. (TAG)
[2019-02-19 18:45:05 P-19295 T-139902375159552][OK] Service Thread Finished !!
[2019-02-19 18:45:05 P-19295 T-139902375159552][INFO] Session is closed (Client IP : 192.168.0.31)

Pictures necessary

(Tag Analyzer Option Windows)

-- _arrival_time 이 가장 작은 레코드의 i1 값을 획득
select first(_arrival_time, i1) from t1;

-- _arrival_time 이 가장 작은 레코드의 i1 값과, 
-- _arrival_time 이 가장 큰 레코드의 i1 값을 획득
select first(_arrival_time, i1), last(_arrival_time, i1) from t1;

-- '입력 시점'에 다음을 검사한다.
--   >> 최근 삭제 시점보다 1시간 이상 경과한 경우, 
--      최근 2일치를 제외한 모든 레코드를 삭제한다.
CREATE TABLE t1 (...) KEEP 2 DAY AFTER APPEND INTERVAL 1 HOUR;

// Set the SQL_ATTR_PARAM_BIND_TYPE statement attribute to use 
// column-wise binding. 
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAM_BIND_TYPE, SQL_PARAM_BIND_BY_COLUMN, 0); 
 
// Specify the number of elements in each parameter array. 
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAMSET_SIZE, ARRAY_SIZE, 0); 
 
// Specify an array in which to return the status of each set of 
// parameters. 
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAM_STATUS_PTR, ParamStatusArray, 0); 
 
// Specify an SQLUINTEGER value in which to return the number of sets of 
// parameters processed. 
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAMS_PROCESSED_PTR, &ParamsProcessed, 0); 
 
// Bind the parameters in column-wise fashion. 
SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_ULONG, SQL_INTEGER, 5, 0, 
                  PartIDArray, 0, PartIDIndArray); 
SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, DESC_LEN - 1, 0, 
                  DescArray, DESC_LEN, DescLenOrIndArray); 
SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_FLOAT, SQL_REAL, 7, 0, 
                  PriceArray, 0, PriceIndArray);

Pictures necessary

(Coordinator Role)

$ machcoordinatoradmin --get-host-resource -i
-------------------------------------------------------------------------
     Machbase Coordinator Administration Tool
     Release Version - d35aa87.develop
     Copyright 2014, MACHBASE Corp. or its subsidiaries
     All Rights Reserved
-------------------------------------------------------------------------
Host Name : 192.168.0.32
   CPU Info :
      Model Name          : Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz
      Number of CPUs      : 8
      Number of CPU Cores : 4
      CPU Utilization     : 18.5%
      CPU IOWait Ratio    : 0.0%
   Memory Info :
      Physical Memory Utilization : 94.2%
      Virtual Memory Utilization  : 85.1%
   Network Info :
      Receive Bytes(per second)    : 35827
      Receive Packets(per second)  : 250
      Transmit Bytes(per second)   : 35716
      Transmit Packets(per second) : 248
   Disk Info :
      /dev/sda1 : 87.0%
         |-> 192.168.0.32:32110   /home/cumulus/work/nfx/test/nodes/coordinator1
         |-> 192.168.0.32:32310   /home/cumulus/work/nfx/test/nodes/broker1
         |-> 192.168.0.32:32410   /home/cumulus/work/nfx/test/nodes/active1_1
         |-> 192.168.0.32:32520   /home/cumulus/work/nfx/test/nodes/active2_2

# Coordinator host 에서 command-line 을 통해 요청
machcoordinatoradmin --get-host-resource -i

# Coordinator 의 HTTP Admin Host:Port 에서 RESTful API 요청
curl http://192.168.0.32:32112/Get-Host-Resource