Content Comparison

MACHSQL is a tool to dynamically execute SQL queries against Machbase server in the console, and it also allows you to check the results on the screen.

...

MACHSQL은 터미널 화면을 통해 SQL질의를 수행하는 대화형 도구이다.

구동 옵션 설명

Code Block
[mach@localhost]$ machsql -h

...

Table 1. MACHSQL options and description

...

짧은 옵션	긴 옵션	설명
-s	--serverIt	specifies the IP address of the server where machbased is running. (e.g. localhost접속할 서버의 IP 주소 (default : 127.0.0.1)
-u	--user	It specifies the user ID to login machbased. (e.g. 사용자명 (default : SYS)
-p	--password	It specifies the user's password to login machbased. (e.g. 사용자 패스워드 (default : MANAGER)
-P	--portIt specifies	the port number to access machbased. The default value is 5656, and it is set in machbase.conf file.서버의 포트 번호 (default : 5656)
-n	--nls	It specifies the NLS .설정
-f	--scriptIt	designates the external file name to execute.실행할 SQL 스크립트 파일
-o	--outputIt	specifies the external file name to store the execution results. It is stored as a tab delimiter. 질의 결과를 저장할 파일명
-i	--silentIt	doesn't display copyright statements.저작권 출력 없이 실행
-v	--verbose	Run in Verbose mode.	-t	--testing	Run in Testing mode.	상세 출력
-r	--formatIt	specifies teh format of the file to be output. (e.g. csv)) 출력 파일 포맷 지정 (default: csv)
-h	--helpDisplay help message.	옵션 출력

Example:

Code Block
machsql -s localhost -u sys -p manager machsql --server=localhost --user=sys --password=manager machsql -s localhost -u sys -p manager -f script.sql

...

SHOW

...

The commands display information about index, tablespace, and other servers.

...

명령어

테이블, 테이블스페이스, 인덱스 등의 정보를 출력한다.

SHOW 명령어 목록

SHOW INDEX
SHOW INDEXES
SHOW INDEXGAP
SHOW LSM
SHOW LICENSE
SHOW STATEMENTS
SHOW TABLE
SHOW TABLES
SHOW TABLESPACE
SHOW TABLESPACES
SHOW USERS

SHOW INDEX

It displays the detailed information about a specified index인덱스 정보를 출력한다.

Syntax:

Code Block
SHOW INDEX index_name

...

Example:

Code Block

Mach> CREATE TABLE t1 (c1 INTEGER, c2 VARCHAR(10));
Created successfully.
Mach> CREATE VOLATILE TABLE t2 (c1 INTEGER, c2 VARCHAR(10));
Created successfully.
Mach> CREATE INDEX t1_idx1 ON t1(c1) INDEX_TYPE LSM;
Created successfully.
Mach> CREATE INDEX t1_idx2 ON t1(c1) INDEX_TYPE BITMAP;
Created successfully.
Mach> CREATE INDEX t2_idx1 ON t2(c1) INDEX_TYPE REDBLACK;
Created successfully.
Mach> CREATE INDEX t2_idx2 ON t2(c2) INDEX_TYPE REDBLACK;
Created successfully.

Mach> SHOW INDEX t1_idx2;
TABLE_NAME                                COLUMN_NAME                               INDEX_NAME                       
----------------------------------------------------------------------------------------------------------------------------------
INDEX_TYPE   BLOOM_FILTER  KEY_COMPRESS  MAX_LEVEL   PART_VALUE_COUNT BITMAP_ENCODE
--------------------------------------------------------------------------------------------
T1                                        C1                                        T1_IDX2                          
LSM          ENABLE   COMPRESSED    2           100000      EQUAL
[1] row(s) selected

...

SHOW INDEXES

It displays the list of all indexes인덱스 전체 리스트를 출력한다.

Syntax:

Code Block
SHOW INDEXES

...

Example:

Code Block

Mach> CREATE TABLE t1 (c1 INTEGER, c2 VARCHAR(10));
Created successfully.
Mach> CREATE VOLATILE TABLE t2 (c1 INTEGER, c2 VARCHAR(10));
Created successfully.
Mach> CREATE INDEX t1_idx1 ON t1(c1) INDEX_TYPE LSM;
Created successfully.
Mach> CREATE INDEX t1_idx2 ON t1(c1) INDEX_TYPE BITMAP;
Created successfully.
Mach> CREATE INDEX t2_idx1 ON t2(c1) INDEX_TYPE REDBLACK;
Created successfully.
Mach> CREATE INDEX t2_idx2 ON t2(c2) INDEX_TYPE REDBLACK;
Created successfully.

Mach> SHOW INDEXES;
TABLE_NAME                                COLUMN_NAME                               INDEX_NAME                       
----------------------------------------------------------------------------------------------------------------------------------
INDEX_TYPE
---------------
T1                                        C1                                        T1_IDX1                          
LSM
T1                                        C1                                        T1_IDX2                          
LSM
T2                                        C2                                        T2_IDX2                          
REDBLACK
T2                                        C1                                        T2_IDX1                          
REDBLACK
[4] row(s) selected.

...

SHOW INDEXGAP

It displays information about index gap.인덱스 생성 GAP 정보를 출력한다.

Example:

Code Block
Mach> SHOW INDEXGAP TABLE_NAME INDEX_NAME GAP ------------------------------------------------------------------------------------------------------------- INDEX_TABLE T1_IDX1 0 INDEX_TABLE T1_IDX2 0

...

SHOW LSM

It displays information about LSM indexLSM 인덱스 생성 정보를 출력한다.

Example:

Code Block

Mach> SHOW LSM;
TABLE_NAME                                INDEX_NAME                                LEVEL       COUNT
--------------------------------------------------------------------------------------------------------------------------
T1                                        IDX1                                      0           0
T1                                        IDX1                                      1           100000
T1                                        IDX1                                      2           0
T1                                        IDX1                                      3           0
T1                                        IDX2                                      0           100000
T1                                        IDX2                                      1           0
[6] row(s) selected.

...

SHOW LICENSE

It displays the license information라이선스 정보를 출력한다.

Example:

Code Block

Mach> SHOW LICENSE
INSTALL_DATE          ISSUE_DATE            EXPIRY_DATE  TYPE        POLICY     
---------------------------------------------------------------------------------------
2016-07-01 10:24:37   20160325              20170325    2           0          
[1] row(s) selected.

...

SHOW STATEMENTS

It displays SQL statements used in all sessions서버에 등록(Prepare, Execute, Fetch)된 모든 질의문을 출력한다.

Example:

Code Block

Mach> SHOW STATEMENTS
USER_ID     SESSION_ID  QUERY                                                                            
--------------------------------------------------------------------------------------------------------------
0           2           SELECT ID USER_ID, SESS_ID SESSION_ID, QUERY FROM V$STMT                         
[1] row(s) selected.

...

SHOW TABLE

It displays information about table info사용자가 생성한 테이블의 정보를 출력한다.

Syntax:

Code Block
SHOW TABLE table_name

...

Example:

Code Block

Mach> CREATE TABLE t1 (c1 INTEGER, c2 VARCHAR(10));
Created successfully.
Mach> CREATE INDEX t1_idx1 ON t1(c1) INDEX_TYPE LSM;
Created successfully.
Mach> CREATE INDEX t1_idx2 ON t1(c1) INDEX_TYPE BITMAP;
Created successfully.

Mach> SHOW TABLE T1
[ COLUMN ]
----------------------------------------------------------------
NAME                          TYPE                LENGTH
----------------------------------------------------------------
C1                            integer             11
C2                            varchar             10

[ INDEX ]
----------------------------------------------------------------
NAME                          TYPE                COLUMN
----------------------------------------------------------------
T1_IDX1                       LSM                 C1
T1_IDX2                       LSM                 C1

...

SHOW TABLES

It displays lists of a table사용자가 생성한 테이블 전체 목록을 출력한다.

Example:

Code Block
Mach> SHOW TABLES NAME -------------------------------------------- BONUS DEPT EMP SALGRADE [4] row(s) selected.

...

SHOW TABLESPACE

It displays information about tablespace테이블 스페이스 정보를 출력한다.

Example:

Code Block
Mach> CREATE TABLE t1 (id integer)

...

;
Created successfully.
Mach> CREATE INDEX t1_idx_id ON t1(id);
Created successfully

...



Mach> SHOW TABLESPACE SYSTEM_TABLESPACE;
[TABLE]
NAME                                      TYPE
-------------------------------------------------------
T1                                        LOG
[1] row(s) selected.

...

[INDEX]
TABLE_NAME                                COLUMN_NAME                               INDEX_NAME                       
----------------------------------------------------------------------------------------------------------------------------------
T1                                        ID                                        T1_IDX_ID                    
[1] row(s) selected.

...

SHOW TABLESPACES

It displays information about tablespaces테이블스페이스 전체 목록을 출력한다.

Example:

Code Block

language	sql

Mach> CREATE TABLESPACE tbs1 DATADISK disk1 (DISK_PATH="tbs1_disk1"), disk2 (DISK_PATH="tbs1_disk2"), disk3 (DISK_PATH="tbs1_disk3");
Created successfully.

...

--

...

데이터를 입력한다
...
...


Mach> SHOW TABLESPACES;
NAME                                                                              DISK_COUNT  USAGE
-----------------------------------------------------------------------------------------------------------------------
SYSTEM_TABLESPACE                                                                 1           0
TBS1                                                                              3           25824256
[2] row(s) selected.

...

SHOW USERS

It displays names of registered users사용자 목록을 출력한다.

Example:

Code Block
Mach> CREATE USER testuser IDENTIFIED BY 'test1234'; Created successfully. Mach> SHOW USERS; USER_NAME -------------------------------------------- SYS TESTUSER [2] row(s) selected.

Version	Old Version 1	New Version Current
Changes made by	Grey Shim	Ryan Park
Saved on	Nov 26, 2018	Feb 26, 2019

Versions Compared

Key

구동 옵션 설명

SHOW

명령어

SHOW INDEX

SHOW INDEXES

SHOW INDEXGAP

SHOW LSM

SHOW LICENSE

SHOW STATEMENTS

SHOW TABLE

SHOW TABLES

SHOW TABLESPACE

SHOW TABLESPACES

SHOW USERS