나그네소

[ table sharding key 조회 ] gSQL> select * from user_shard_key_columns; TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_POSITION ------------ ---------- ----------- --------------- PUBLIC T1 C1 1 PUBLIC T2 C1 1 [ local member 확인 ] select local_member_name() from dual; ============================== LOCAL_MEMBER_NAME() G1N1 [ \ddl_cluster ] cluster 정보 출력. [ sharding key, 속성 확인 ] gSQL> select SHARDING_ST..

[Linux Install Guide] [Windows Clien Install Guide]

[Goldilocks Cluster 운영 Guide] [Goldilocks Cluster 운영 Guide (command)] > DROP TABLE IF EXISTS CDRLOAD; CREATE TABLE CDRLOAD ( CREATE_TIME char(9), FILE_NAME char(10), TASK_NUM smallint, RECORD_SEQ smallint, NODE_NUM smallint, SERVICE_ID char(10), CDR_RECORD char(200), primary key (CREATE_TIME, FILE_NAME, TASK_NUM, RECORD_SEQ, NODE_NUM) ) SHARDING BY RANGE (NODE_NUM) SHARD s1 VALUES LESS THAN ( 2 ..