Less than 1 minuteAbout 264 words
Run the following command to start the CLI program in the root directory of CnosDB source code.
The parameters of CLI program are as follows:
-h --host CnosDB Host of the service. The default is "localhost". -p --port CnosDB Port of the service. The default is 8902. -u --user Username. The default value is "CnosDB". -p --password Password. None by default. -d --database Connected database. The default value is "public". -t --target-partitions Optional; the number of slices to execute the query, increasing which can increase concurrency. Not specified by default. --data-path Data storage location of CLI program. The default is the directory where the client is executed. -f --file Optional; it executse multiple command scripts and exits. --rc Optional; profile. --format Output format. The default is "Table" format. --quiet To run in quiet mode, output only the result, not execution time. --tenant Tenant name. The default value is "cnosdb".
After entering the program you can run the command or SQL:.
Run an SQL example:
❯ CREATE DATABASE test; Query took 0.050 seconds. ❯
Run a command example:
The commands for the program are as follows:
\? Command Help \q Exit CLI \c <db> Connect the database "db_name", db_name is case sensitive \d <table> Describe the table "table" \quiet Switch to quiet mode, output only the result, not execution time \w <path> Read a file in Line Protocol format and write it to the database, if path is a directory, all files in the directory will be written to the database