<database>
is the name of the database to connect to. The default database name is heavyai.-h [ --help ]
-v [ --version ]
-n [ --no-header ]
-t [ --timing ]
-d [ --delimiter ]
arg
(=|)
--db
arg
heavyai
).-u [ --user ]
arg
(=admin)
--ca-cert
arg
-p [ --passwd ]
arg
--history
arg
-s [ --server ]
arg
(=localhost)
--port
arg
--http
--https
--skip-verify
-q [ --quiet ]
heavy_web_server
--timeout
option.\d
command lists only those databases to which the active heavysql user has access privileges.\c <database> <user> <password>
\clear_cpu
\clear_gpu
\copy <file path> <table>
.tsv
. HEAVY.AI supports Latin-1 ASCII format and UTF-8. If you want to load data with another encoding (for example, UTF-16), convert the data to UTF-8 before loading it to HEAVY.AI.\cpu
\d <table>
\d <view>
\dash
\detect [geo | parquet | raster] <filename> {<filePath> | <s3Link>}
\detect
does not support custom parameters. It uses default values, such as commas as the delimiter (tabs in .tsv files). This is not applicable for geo, Parquet, or raster files.\export_dashboard <dashboard name> <filename>
\gpu
\h
\historylen <number>
\import_dashboard <dashboard name> <filename>
\l
\memory_summary
\multiline
\notiming
\o <table>
\t
, \u
, and \v
commands might return a long list of values. You can use a regular expression match pattern to filter the results. For example, you could use the following command to return only tables that start with the word flight.