경로 {SQREAM_HOME}/sqream/bin
sqream sql의 옵션
[sqream@v100-sqream:: /home/sqream/SQREAM/sqream/bin ]$ sqream sql --help
Open an SQL shell and connect to a SQream DB database.
Usage:
sqream sql [flags]
Flags:
--port=PORT Server port. Default: 5000
--username=USERNAME Login username. Mandatory, No default
--password=PASSWORD Login password. Optional, No default (Input prompt when omitted)
--chunksize=CHUNKSIZE Network chunk size. Default: 128 * 1024 (128 Kb)
--host=HOSTNAME Server address to connect to. Default: 127.0.0.1
--clustered Is there a load balancer for a clustered installation?
--results-only Turn off printing of operation execution time and result row count.
-d DATABASENAME --databasename=DATABASENAME Database name. No default
--showresults=BOOLEAN Should results be sent to stdout? Default: True
--delimiter=DELIMITER delimiter for csv. Default is ','
-c SQL --command=SQL Specify query or command to be run, without entering interactive mode. Query should be enclosed in double quotes.
-f FILE --file=FILE Specifies file containing semicolon (;) separated SQL queries/commands.
-s NAME --service=NAME Service name. Default is sqream.
--no-history Do not save commands history.
--trim-varchars Turn off printing of varchar padding spaces.
ClientCmd의 옵션
[sqream@v100-sqream:: /home/sqream/SQREAM/sqream/bin ]$ ClientCmd --help
Open an SQL shell and connect to a SQream DB database.
Usage:
sqream sql [flags]
Flags:
--port=PORT Server port. Default: 5000
--username=USERNAME Login username. Mandatory, No default
--password=PASSWORD Login password. Optional, No default (Input prompt when omitted)
--chunksize=CHUNKSIZE Network chunk size. Default: 128 * 1024 (128 Kb)
--host=HOSTNAME Server address to connect to. Default: 127.0.0.1
--clustered Is there a load balancer for a clustered installation?
--results-only Turn off printing of operation execution time and result row count.
-d DATABASENAME --databasename=DATABASENAME Database name. No default
--showresults=BOOLEAN Should results be sent to stdout? Default: True
--delimiter=DELIMITER delimiter for csv. Default is ','
-c SQL --command=SQL Specify query or command to be run, without entering interactive mode. Query should be enclosed in double quotes.
-f FILE --file=FILE Specifies file containing semicolon (;) separated SQL queries/commands.
-s NAME --service=NAME Service name. Default is sqream.
--no-history Do not save commands history.
--trim-varchars Turn off printing of varchar padding spaces.실행 예시
- database : 접속할 Database
- username, password : 접속에 사용할 계정
- host : SQREAM 서버 IP
- port : SQREAM 접속 Port
- service : 사용할 SQREAM Worker의 Service명
ClientCmd --database=lyj --username=user --password=passwd --host=000.000.000.000 --port=00000 --clustered --trim-varchars --service=a40
MZC