Команды YTsaurus CLI
Cypress commands
concatenate
concatenates cypress nodes. This command applicable only to files and tables
usage: yt concatenate [-h] [--params PARAMS] --src SOURCE_PATHS --dst DESTINATION_PATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--src(Required) Source paths Accepted multiple times.
--dst(Required) Destination paths
copy
copies Cypress node
usage: yt copy [-h] [--params PARAMS] [--source-path SOURCE_PATH] [--destination-path DESTINATION_PATH] [--preserve-account | --no-preserve-account] [--preserve-owner | --no-preserve-owner]
[--preserve-creation-time] [--preserve-modification-time] [--preserve-expiration-time] [--preserve-expiration-timeout] [--preserve-acl | --no-preserve-acl] [-r] [-i] [-l] [-f]
[--no-pessimistic-quota-check]
[source_path] [destination_path]
Positional Arguments
source_pathsource address, path must exist. See also: YPATH
destination_pathdestination address, path must not exist. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--source-pathsource address, path must exist. See also: YPATH
--destination-pathdestination address, path must not exist. See also: YPATH
--preserve-account
--no-preserve-account
--preserve-owner
--no-preserve-owner
--preserve-creation-timepreserve creation time of node
--preserve-modification-timepreserve modification time of node
--preserve-expiration-timepreserve expiration time of node
--preserve-expiration-timeoutpreserve expiration timeout of node
--preserve-acl
--no-preserve-acl
-r, --recursive
-i, --ignore-existing
-l, --lock-existing
-f, --force
--no-pessimistic-quota-check
create
creates Cypress node
usage: yt create [-h] [--params PARAMS] [--type TYPE] [--path PATH] [-r] [-i] [-l] [-f] [--attributes ATTRIBUTES] [type] [path]
Positional Arguments
typeone of table, file, document, account, user, map_node, string_node, int64_node, uint64_node, double_node, …
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--typeone of table, file, document, account, user, map_node, string_node, int64_node, uint64_node, double_node, …
--pathaddress in Cypress. See also: YPATH
-r, --recursive
-i, --ignore-existing
-l, --lock-existing
-f, --force
--attributesstructured attributes in yson format
create-account
. creates account
usage: yt create-account [-h] [--params PARAMS] [--name NAME] [--parent-name PARENT_NAME] [--resource-limits RESOURCE_LIMITS] [-i] [--allow-children-limit-overcommit] [--attributes ATTRIBUTES] [name]
Positional Arguments
name
Named Arguments
--paramsspecify additional params. structured params in yson format
--name
--parent-name
--resource-limitsstructured resource-limits in yson format
-i, --ignore-existing
--allow-children-limit-overcommit
--attributesstructured attributes in yson format
create-pool
. creates scheduler pool
usage: yt create-pool [-h] [--params PARAMS] [--name NAME] [--pool-tree POOL_TREE] [--parent-name PARENT_NAME] [--weight WEIGHT] [--mode MODE] [--fifo-sort-parameters FIFO_SORT_PARAMETERS]
[--max-operation-count MAX_OPERATION_COUNT] [--max-running-operation-count MAX_RUNNING_OPERATION_COUNT] [--forbid-immediate-operations] [--resource-limits RESOURCE_LIMITS]
[--min-share-resources MIN_SHARE_RESOURCES] [--create-ephemeral-subpools] [--ephemeral-subpool-config EPHEMERAL_SUBPOOL_CONFIG] [-i] [--attributes ATTRIBUTES]
[name] [pool_tree]
Positional Arguments
name
pool_tree
Named Arguments
--paramsspecify additional params. structured params in yson format
--name
--pool-tree
--parent-name
--weight
--modefifo or fair_share
--fifo-sort-parametersstructured fifo-sort-parameters in yson format
--max-operation-count
--max-running-operation-count
--forbid-immediate-operations
--resource-limitsstructured resource-limits in yson format
--min-share-resourcesstructured min-share-resources in yson format
--create-ephemeral-subpools
--ephemeral-subpool-configstructured ephemeral-subpool-config in yson format
-i, --ignore-existing
--attributesstructured attributes in yson format
exists
checks if Cypress node exists
usage: yt exists [-h] [--params PARAMS] [--path PATH] [--suppress-transaction-coordinator-sync] [--read-from READ_FROM] [--cache-sticky-group-size CACHE_STICKY_GROUP_SIZE] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--suppress-transaction-coordinator-syncsuppress transaction coordinator sync
--read-fromCan be set to «cache» to enable reads from system cache
--cache-sticky-group-sizeSize of sticky group size for read_from=»cache» mode
externalize
externalize cypress node
usage: yt externalize [-h] [--params PARAMS] [--path PATH] --cell-tag CELL_TAG [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--cell-tag(Required)
find
searches for some nodes in Cypress subtree
usage: yt find [-h] [--params PARAMS] [--path PATH] [--name NAME] [--type TYPE] [--account ACCOUNT] [--owner OWNER] [--follow-links] [--attribute-filter ATTRIBUTE_FILTER] [--depth DEPTH] [-l]
[--recursive-resource-usage] [--time-type {access_time,modification_time,creation_time}] [--read-from READ_FROM] [--cache-sticky-group-size CACHE_STICKY_GROUP_SIZE]
[path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--name, -namepattern of node name, use shell-style wildcards:
*
, ?, [seq], [!seq]
--typeone of table, file, document, account, user, map_node, string_node, int64_node, uint64_node, double_node, …
--account
--owner
--follow-linksfollow links
--attribute-filteryson map fragment with filtering attributes, e.g. k1=v1;k2=v2
--depthrecursion depth (infinite by default)
-l, --long-formatprint some extra information about nodes
--recursive-resource-usageuse recursive resource usage for in long format mode
--time-typePossible choices: access_time, modification_time, creation_time
type of time to use in long-format, default:
«modification_time»
--read-fromCan be set to «cache» to enable reads from system cache
--cache-sticky-group-sizeSize of sticky group size for read_from=»cache» mode
get
gets Cypress node content (attribute tree)
usage: yt get [-h] [--params PARAMS] [--path PATH] [--max-size MAX_SIZE] [--format FORMAT] [--attribute ATTRIBUTES] [--suppress-transaction-coordinator-sync] [--read-from READ_FROM]
[--cache-sticky-group-size CACHE_STICKY_GROUP_SIZE]
[path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--max-sizemaximum size of entries returned by get; if actual directory size exceeds that value only subset of entries will be listed (it’s not specified which subset); default value is enough to list any nonsystem directory.
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«<format=pretty>yson»
--attributedesired node attributes in the response Accepted multiple times.
--suppress-transaction-coordinator-syncsuppress transaction coordinator sync
--read-fromCan be set to «cache» to enable reads from system cache
--cache-sticky-group-sizeSize of sticky group size for read_from=»cache» mode
internalize
internalize cypress node
usage: yt internalize [-h] [--params PARAMS] [--path PATH] --cell-tag CELL_TAG [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--cell-tag(Required)
link
makes link to Cypress node
usage: yt link [-h] [--params PARAMS] [--target-path TARGET_PATH] [--link-path LINK_PATH] [-r] [-i] [-l] [-f] [--attributes ATTRIBUTES] [target_path] [link_path]
Positional Arguments
target_pathaddress of original node to link, path must exist. See also: YPATH
link_pathaddress of resulting link, path must not exist. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--target-pathaddress of original node to link, path must exist. See also: YPATH
--link-pathaddress of resulting link, path must not exist. See also: YPATH
-r, --recursivecreate parent nodes recursively
-i, --ignore-existing
-l, --lock-existing
-f, --forceforce create link even if destination already exists (supported only on cluster with 19+ version)
--attributesstructured attributes in yson format
list
lists directory (map_node) content. Node type must be «map_node»
usage: yt list [-h] [--params PARAMS] [--path PATH] [-l] [--format FORMAT] [--attribute ATTRIBUTES] [--max-size MAX_SIZE] [--recursive-resource-usage] [--suppress-transaction-coordinator-sync]
[--read-from READ_FROM] [--cache-sticky-group-size CACHE_STICKY_GROUP_SIZE] [--absolute]
[path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
-l, --long-formatprint some extra information about nodes
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
--attributenode attributes to add into response Accepted multiple times.
--max-sizemaximum size of entries returned by list; if actual directory size exceeds that value only subset of entries will be listed (it’s not specified which subset); default value is enough to list any nonsystem directory.
--recursive-resource-usageuse recursive resource usage for in long format mode
--suppress-transaction-coordinator-syncsuppress transaction coordinator sync
--read-fromCan be set to «cache» to enable reads from system cache
--cache-sticky-group-sizeSize of sticky group size for read_from=»cache» mode
--absoluteprint absolute paths
move
moves (renames) Cypress node
usage: yt move [-h] [--params PARAMS] [--source-path SOURCE_PATH] [--destination-path DESTINATION_PATH] [--preserve-account | --no-preserve-account] [--preserve-owner | --no-preserve-owner]
[--preserve-creation-time] [--preserve-modification-time] [--preserve-expiration-time] [--preserve-expiration-timeout] [-r] [-f] [--no-pessimistic-quota-check]
[source_path] [destination_path]
Positional Arguments
source_pathold node address, path must exist. See also: YPATH
destination_pathnew node address, path must not exist. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--source-pathold node address, path must exist. See also: YPATH
--destination-pathnew node address, path must not exist. See also: YPATH
--preserve-account
--no-preserve-account
--preserve-owner
--no-preserve-owner
--preserve-creation-timepreserve creation time of node
--preserve-modification-timepreserve modification time of node
--preserve-expiration-timepreserve expiration time of node
--preserve-expiration-timeoutpreserve expiration timeout of node
-r, --recursive
-f, --force
--no-pessimistic-quota-check
remove
removes Cypress node
usage: yt remove [-h] [--params PARAMS] [--path PATH] [-r] [-f] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
-r, --recursive
-f, --force
remove-attribute
removes attribute at given path
usage: yt remove-attribute [-h] [--params PARAMS] [--path PATH] [-r] [path] name
Positional Arguments
pathaddress in Cypress. See also: YPATH
name
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
-r, --recursive
set
sets new value to Cypress node
usage: yt set [-h] [--params PARAMS] [--path PATH] [--format FORMAT] [-r] [-f] [--suppress-transaction-coordinator-sync] [--value VALUE] [path] [value]
Positional Arguments
pathaddress in Cypress. See also: YPATH
valuenew node attribute value, in yson format. You can specify in bash pipe: «cat file_with_value | yt set //tmp/my_node»
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«yson»
-r, --recursive
-f, --force
--suppress-transaction-coordinator-syncsuppress transaction coordinator sync
--valuenew node attribute value, in yson format. You can specify in bash pipe: «cat file_with_value | yt set //tmp/my_node»
set-attribute
sets attribute at given path
usage: yt set-attribute [-h] [--params PARAMS] [--path PATH] [-r] [path] name value
Positional Arguments
pathaddress in Cypress. See also: YPATH
name
valuestructured value in yson format
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
-r, --recursive
File commands
download
downloads file from path in Cypress to local machine
usage: yt download [-h] [--params PARAMS] [--path PATH] [--file-reader FILE_READER] [--offset OFFSET] [--length LENGTH] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--file-readerstructured file-reader in yson format
--offsetoffset in input file in bytes, 0 by default
--lengthlength in bytes of desired part of input file, all file without offset by default
read-file
downloads file from path in Cypress to local machine
usage: yt read-file [-h] [--params PARAMS] [--path PATH] [--file-reader FILE_READER] [--offset OFFSET] [--length LENGTH] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--file-readerstructured file-reader in yson format
--offsetoffset in input file in bytes, 0 by default
--lengthlength in bytes of desired part of input file, all file without offset by default
upload
uploads file to destination path from stream on local machine
usage: yt upload [-h] [--params PARAMS] [--destination DESTINATION] [--file-writer FILE_WRITER] [--compressed] [--executable] [--compute-md5] [--no-compression] [destination]
Positional Arguments
destinationaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--destinationaddress in Cypress. See also: YPATH
--file-writerstructured file-writer in yson format
--compressedexpect stream to contain compressed file data. Warning! This option disables retries. Data is passed directly to proxy without recompression.
--executabledo file executable
--compute-md5compute md5 of file content
--no-compressiondisable compression
write-file
uploads file to destination path from stream on local machine
usage: yt write-file [-h] [--params PARAMS] [--destination DESTINATION] [--file-writer FILE_WRITER] [--compressed] [--executable] [--compute-md5] [--no-compression] [destination]
Positional Arguments
destinationaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--destinationaddress in Cypress. See also: YPATH
--file-writerstructured file-writer in yson format
--compressedexpect stream to contain compressed file data. Warning! This option disables retries. Data is passed directly to proxy without recompression.
--executabledo file executable
--compute-md5compute md5 of file content
--no-compressiondisable compression
Table commands
alter-table
performs schema and other table meta information modifications
usage: yt alter-table [-h] [--params PARAMS] [--path PATH] [--schema [SCHEMA]] [--dynamic | --static] [--upstream-replica-id UPSTREAM_REPLICA_ID] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--schemanew schema value, in yson format.
--dynamic
--static
--upstream-replica-idupstream replica id
create-temp-table
creates temporary table by given path with given prefix and return name
usage: yt create-temp-table [-h] [--params PARAMS] [--path PATH] [--name-prefix NAME_PREFIX] [--expiration-timeout EXPIRATION_TIMEOUT] [--attributes ATTRIBUTES]
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathpath where temporary table will be created. See also: YPATH
--name-prefixprefix of table name
--expiration-timeoutexpiration timeout in ms
--attributesstructured attributes in yson format
dirtable
Upload/download to file system commands
usage: yt dirtable [-h] dirtable_command ...
Positional Arguments
dirtable_commandPossible choices: upload, download, list-files, append-single-file
Sub-commands
upload
Upload directory to YTsaurus
yt dirtable upload [-h] --directory DIRECTORY [--store-full-path] [--part-size PART_SIZE] [--recursive] [--no-recursive] --yt-table YT_TABLE [--process-count PROCESS_COUNT] [--exact-filenames EXACT_FILENAMES]
[--filter-by-regexp FILTER_BY_REGEXP] [--exclude-by-regexp EXCLUDE_BY_REGEXP] [--force] [--prepare-for-sky-share]
Named Arguments
--directory
--store-full-pathStoring files" full path as provided in –directory
--part-sizeDefault:4194304
--recursive
--no-recursive
--yt-table
--process-countDefault:4
--exact-filenamesFiles to upload (separated by comma)
--filter-by-regexpFiles with name matching that regexp will be uploaded
--exclude-by-regexpFiles with name matching that regexp will not be uploaded
--force
--prepare-for-sky-share
download
Download directory from YTsaurus
yt dirtable download [-h] --directory DIRECTORY --yt-table YT_TABLE [--process-count PROCESS_COUNT] [--exact-filenames EXACT_FILENAMES] [--filter-by-regexp FILTER_BY_REGEXP]
[--exclude-by-regexp EXCLUDE_BY_REGEXP]
Named Arguments
--directory
--yt-table
--process-countDefault:4
--exact-filenamesFiles to extract (separated by comma)
--filter-by-regexpFiles with name matching that regexp will be extracted
--exclude-by-regexpFiles with name matching that regexp will not be extracted
list-files
List files from YTsaurus
yt dirtable list-files [-h] --yt-table YT_TABLE [--raw]
Named Arguments
--yt-table
--rawRaw output with file list only
append-single-file
Append single file to table
yt dirtable append-single-file [-h] --yt-table YT_TABLE [--yt-name YT_NAME] --fs-path FS_PATH [--store-full-path] [--process-count PROCESS_COUNT]
Named Arguments
--yt-table
--yt-name
--fs-path
--store-full-pathStoring file’s full path as provided in –directory
--process-countDefault:4
get-table-columnar-statistics
gets columnar statistics of tables listed in paths
usage: yt get-table-columnar-statistics [-h] [--params PARAMS] --path PATHS
Named Arguments
--paramsspecify additional params. structured params in yson format
--path(Required) Path to source table. See also: YPATH Accepted multiple times.
read
reads rows from table and parse (optionally)
usage: yt read [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--table-reader TABLE_READER] [--control-attributes CONTROL_ATTRIBUTES] [--unordered] [--as-json-list] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatoutput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--table-readerstructured table-reader in yson format
--control-attributesstructured control-attributes in yson format
--unordered
--as-json-listIn case of JSON format output stream as JSON list instead of JSON lines format
read-blob-table
reads file from blob table
usage: yt read-blob-table [-h] [--params PARAMS] [--table TABLE] [--part-index-column-name PART_INDEX_COLUMN_NAME] [--data-column-name DATA_COLUMN_NAME] [--part-size PART_SIZE] [--table-reader TABLE_READER]
[table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--part-index-column-namename of column with part indexes
--data-column-namename of column with data
--part-sizesize of each blob
--table-readerstructured table-reader in yson format
read-table
reads rows from table and parse (optionally)
usage: yt read-table [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--table-reader TABLE_READER] [--control-attributes CONTROL_ATTRIBUTES] [--unordered] [--as-json-list] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatoutput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--table-readerstructured table-reader in yson format
--control-attributesstructured control-attributes in yson format
--unordered
--as-json-listIn case of JSON format output stream as JSON list instead of JSON lines format
write
writes rows from input_stream to table
usage: yt write [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--table-writer TABLE_WRITER] [--compressed] [--no-compression] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatinput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--table-writerstructured table-writer in yson format
--compressedexpect stream to contain compressed file data. Warning! This option disables retries. Data is passed directly to proxy without recompression.
--no-compressiondisable compression
write-table
writes rows from input_stream to table
usage: yt write-table [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--table-writer TABLE_WRITER] [--compressed] [--no-compression] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatinput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--table-writerstructured table-writer in yson format
--compressedexpect stream to contain compressed file data. Warning! This option disables retries. Data is passed directly to proxy without recompression.
--no-compressiondisable compression
Dynamic table commands
alter-table-replica
changes mode and enables or disables a table replica or replicated table tracker for table replica
usage: yt alter-table-replica [-h] [--params PARAMS] [--enable | --disable] [--enable-replicated-table-tracker | --disable-replicated-table-tracker] [--mode MODE] replica_id
Positional Arguments
replica_id
Named Arguments
--paramsspecify additional params. structured params in yson format
--enableenable table replica
--disabledisable table replica
--enable-replicated-table-trackerenable replicated table tracker for table replica
--disable-replicated-table-trackerdisable replicated table tracker for table replica
--modealternation mode, can be «sync» or «async»
balance-tablet-cells
reassign tablets evenly among tablet cells
usage: yt balance-tablet-cells [-h] [--params PARAMS] [--bundle BUNDLE] [--tables [TABLES ...]] [--sync] [bundle]
Positional Arguments
bundletablet cell bundle
Named Arguments
--paramsspecify additional params. structured params in yson format
--bundletablet cell bundle
--tablestables to balance. If omitted, all tables of bundle will be balanced
--sync
delete
. Use "delete-rows" instead of "delete"
usage: yt delete [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
delete-rows
deletes rows with keys from input_stream from dynamic table
usage: yt delete-rows [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--atomicity {full,none}] [--durability {sync,async}] [--require-sync-replica | --no-require-sync-replica] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatinput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--atomicityPossible choices: full, none
--durabilityPossible choices: sync, async
--require-sync-replica
--no-require-sync-replica
explain-query
explains a SQL-like query on dynamic table
usage: yt explain-query [-h] [--params PARAMS] [--query QUERY] [--timestamp TIMESTAMP] [--input-row-limit INPUT_ROW_LIMIT] [--output-row-limit OUTPUT_ROW_LIMIT] [--allow-full-scan | --forbid-full-scan]
[--allow-join-without-index | --forbid-join-without-index] [--execution-pool EXECUTION_POOL] [--format FORMAT] [--syntax-version SYNTAX_VERSION] [--udf-registry-path UDF_REGISTRY_PATH]
[query]
Positional Arguments
query
Named Arguments
--paramsspecify additional params. structured params in yson format
--query
--timestamp
--input-row-limit
--output-row-limit
--allow-full-scan
--forbid-full-scan
--allow-join-without-index
--forbid-join-without-index
--execution-pool
--format
--syntax-version
--udf-registry-path
freeze-table
freezes the table
usage: yt freeze-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [--sync] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
--sync
get-tablet-errors
returns dynamic table tablet and replication errors
usage: yt get-tablet-errors [-h] [--params PARAMS] [--path PATH] [--limit LIMIT] [--format FORMAT] [path]
Positional Arguments
pathpath to dynamic table. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathpath to dynamic table. See also: YPATH
--limitnumber of tablets with errors
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
get-tablet-infos
returns various runtime tablet information
usage: yt get-tablet-infos [-h] [--params PARAMS] [--path PATH] [--tablet-indexes TABLET_INDEXES [TABLET_INDEXES ...]] [--format FORMAT] [path]
Positional Arguments
pathpath to dynamic table. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathpath to dynamic table. See also: YPATH
--tablet-indexes
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
insert
. Use "insert-rows" instead of "insert"
usage: yt insert [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
insert-rows
inserts rows from input_stream to dynamic table
usage: yt insert-rows [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--atomicity {full,none}] [--durability {sync,async}] [--require-sync-replica | --no-require-sync-replica] [--update | --no-update]
[--aggregate | --no-aggregate] [--lock_type LOCK_TYPE]
[table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatinput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--atomicityPossible choices: full, none
--durabilityPossible choices: sync, async
--require-sync-replica
--no-require-sync-replica
--update
--no-update
--aggregate
--no-aggregate
--lock_type
lookup
. Use "lookup-rows" instead of "lookup"
usage: yt lookup [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
lookup-rows
lookups rows in dynamic table
usage: yt lookup-rows [-h] [--params PARAMS] [--table TABLE] [--format FORMAT] [--versioned] [--column-name COLUMN_NAMES] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--formatinput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--versionedreturn all versions of the requested rows
--column-namecolumn name to lookup Accepted multiple times.
mount-table
mounts the table
usage: yt mount-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [--freeze] [--sync]
[--cell-id CELL_ID | --target-cell-ids TARGET_CELL_IDS [TARGET_CELL_IDS ...]]
[path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
--freeze
--sync
--cell-idtablet cell id where the tablets will be mounted to, if omitted then an appropriate cell is chosen automatically
--target-cell-idstablet cell id for each tablet in range [first-tablet-index, last-tablet-index]. Should be used if exact destination cell for each tablet is known.
remount-table
remounts the table
usage: yt remount-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
reshard-table
changes pivot keys separating tablets of a given table
usage: yt reshard-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [--tablet-count TABLET_COUNT] [--sync] [--uniform] [--enable-slicing]
[--slicing-accuracy SLICING_ACCURACY]
[path] [pivot_keys ...]
Positional Arguments
pathaddress in Cypress. See also: YPATH
pivot_keys
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
--tablet-count
--sync
--uniform
--enable-slicing
--slicing-accuracy
reshard-table-automatic
automatically balance tablets of a mounted table according to tablet balancer config
usage: yt reshard-table-automatic [-h] [--params PARAMS] [--path PATH] [--sync] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--sync
select
. Use "select-rows" instead of "select"
usage: yt select [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
select-rows
executes a SQL-like query on dynamic table
usage: yt select-rows [-h] [--params PARAMS] [--query QUERY] [--timestamp TIMESTAMP] [--input-row-limit INPUT_ROW_LIMIT] [--output-row-limit OUTPUT_ROW_LIMIT] [--verbose-logging]
[--enable-code-cache | --disable-code-cache] [--allow-full-scan | --forbid-full-scan] [--allow-join-without-index | --forbid-join-without-index] [--execution-pool EXECUTION_POOL]
[--format FORMAT] [--print-statistics] [--syntax-version SYNTAX_VERSION] [--udf-registry-path UDF_REGISTRY_PATH] [--merge-versioned-rows | --do-not-merge-versioned-rows]
[query]
Positional Arguments
query
Named Arguments
--paramsspecify additional params. structured params in yson format
--query
--timestamp
--input-row-limit
--output-row-limit
--verbose-logging
--enable-code-cache
--disable-code-cache
--allow-full-scan
--forbid-full-scan
--allow-join-without-index
--forbid-join-without-index
--execution-pool
--format
--print-statistics
--syntax-version
--udf-registry-path
--merge-versioned-rows
--do-not-merge-versioned-rows
trim-rows
trim rows of the dynamic table
usage: yt trim-rows [-h] [--params PARAMS] [--path PATH] [path] tablet_index trimmed_row_count
Positional Arguments
pathaddress in Cypress. See also: YPATH
tablet_index
trimmed_row_count
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
unfreeze-table
unfreezes the table
usage: yt unfreeze-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [--sync] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
--sync
unmount-table
unmounts the table
usage: yt unmount-table [-h] [--params PARAMS] [--path PATH] [--first-tablet-index FIRST_TABLET_INDEX] [--last-tablet-index LAST_TABLET_INDEX] [--force] [--sync] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--first-tablet-index
--last-tablet-index
--force
--sync
Run operation commands
erase
erases table or part of it
usage: yt erase [-h] [--params PARAMS] [--table TABLE] [--print-statistics] [--async] [--spec SPEC] [table]
Positional Arguments
tablepath to table to erase. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tablepath to table to erase. See also: YPATH
--print-statistics
--asyncdo not track operation progress
--specstructured spec in yson format
join-reduce
runs join-reduce operation
usage: yt join-reduce [-h] [--params PARAMS] [--binary command] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE [--file YT_FILES] [--local-file LOCAL_FILES] [--job-count JOB_COUNT]
[--memory-limit MEMORY_LIMIT] [--spec SPEC] [--format FORMAT] [--input-format INPUT_FORMAT] [--output-format OUTPUT_FORMAT] [--print-statistics] [--async] --join-by JOIN_BY
[command]
Positional Arguments
command
Named Arguments
--paramsspecify additional params. structured params in yson format
--binary
--src(Required) Accepted multiple times.
--dst(Required) Accepted multiple times.
--file> Accepted multiple times.
--local-file> Accepted multiple times.
--job-count
--memory-limitin MB
--specstructured spec in yson format
--format
--input-format
--output-format
--print-statistics
--asyncdo not track operation progress
--join-by(Required) Columns to join by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
map
runs map operation
usage: yt map [-h] [--params PARAMS] [--binary command] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE [--file YT_FILES] [--local-file LOCAL_FILES] [--job-count JOB_COUNT]
[--memory-limit MEMORY_LIMIT] [--spec SPEC] [--format FORMAT] [--input-format INPUT_FORMAT] [--output-format OUTPUT_FORMAT] [--print-statistics] [--async] [--ordered]
[command]
Positional Arguments
command
Named Arguments
--paramsspecify additional params. structured params in yson format
--binary
--src(Required) Accepted multiple times.
--dst(Required) Accepted multiple times.
--file> Accepted multiple times.
--local-file> Accepted multiple times.
--job-count
--memory-limitin MB
--specstructured spec in yson format
--format
--input-format
--output-format
--print-statistics
--asyncdo not track operation progress
--orderedForce ordered input for mapper.
map-reduce
runs map (optionally), sort, reduce and reduce-combine (optionally) operations
usage: yt map-reduce [-h] [--params PARAMS] [--mapper MAPPER] --reducer REDUCER [--reduce-combiner REDUCE_COMBINER] --src SOURCE_TABLE --dst DESTINATION_TABLE [--map-file MAP_YT_FILES]
[--map-local-file MAP_LOCAL_FILES] [--reduce-file REDUCE_YT_FILES] [--reduce-local-file REDUCE_LOCAL_FILES] [--reduce-combiner-file REDUCE_COMBINER_YT_FILES]
[--reduce-combiner-local-file REDUCE_COMBINER_LOCAL_FILES] [--mapper-memory-limit MAPPER_MEMORY_LIMIT] [--reducer-memory-limit REDUCER_MEMORY_LIMIT]
[--reduce-combiner-memory-limit REDUCE_COMBINER_MEMORY_LIMIT] --reduce-by REDUCE_BY [--sort-by SORT_BY] [--spec SPEC] [--format FORMAT] [--map-input-format MAP_INPUT_FORMAT]
[--map-output-format MAP_OUTPUT_FORMAT] [--reduce-input-format REDUCE_INPUT_FORMAT] [--reduce-output-format REDUCE_OUTPUT_FORMAT] [--reduce-combiner-input-format REDUCE_COMBINER_INPUT_FORMAT]
[--reduce-combiner-output-format REDUCE_COMBINER_OUTPUT_FORMAT] [--async]
Named Arguments
--paramsspecify additional params. structured params in yson format
--mapper
--reducer(Required)
--reduce-combiner
--src(Required) Accepted multiple times.
--dst(Required) Accepted multiple times.
--map-file> Accepted multiple times.
--map-local-file> Accepted multiple times.
--reduce-file> Accepted multiple times.
--reduce-local-file> Accepted multiple times.
--reduce-combiner-file> Accepted multiple times.
--reduce-combiner-local-file> Accepted multiple times.
--mapper-memory-limit, --map-memory-limitin MB
--reducer-memory-limit, --reduce-memory-limitin MB
--reduce-combiner-memory-limitin MB
--reduce-by(Required) Columns to reduce by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
--sort-byColumns to sort by. Must be superset of reduce-by columns. By default is equal to –reduce-by option. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
--specstructured spec in yson format
--format(yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
--map-input-formatsee –format help
--map-output-formatsee –format help
--reduce-input-formatsee –format help
--reduce-output-formatsee –format help
--reduce-combiner-input-formatsee –format help
--reduce-combiner-output-formatsee –format help
--asyncdo not track operation progress
merge
merges source tables to destination table
usage: yt merge [-h] [--params PARAMS] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE [--mode {unordered,ordered,sorted,auto}] [--print-statistics] [--async] [--spec SPEC]
Named Arguments
--paramsspecify additional params. structured params in yson format
--src(Required) Accepted multiple times.
--dst(Required) path to destination table. For append mode add <append=true> before path. See also: YPATH
--modePossible choices: unordered, ordered, sorted, auto
use sorted mode for saving sortedness. unordered mode by default, ordered for saving order of chunks. Mode auto chooses from sorted and unordered modes depending on sortedness of source tables., default:
«auto»
--print-statistics
--asyncdo not track operation progress
--specstructured spec in yson format
reduce
runs reduce operation
usage: yt reduce [-h] [--params PARAMS] [--binary command] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE [--file YT_FILES] [--local-file LOCAL_FILES] [--job-count JOB_COUNT]
[--memory-limit MEMORY_LIMIT] [--spec SPEC] [--format FORMAT] [--input-format INPUT_FORMAT] [--output-format OUTPUT_FORMAT] [--print-statistics] [--async] [--reduce-by REDUCE_BY]
[--sort-by SORT_BY] [--join-by JOIN_BY]
[command]
Positional Arguments
command
Named Arguments
--paramsspecify additional params. structured params in yson format
--binary
--src(Required) Accepted multiple times.
--dst(Required) Accepted multiple times.
--file> Accepted multiple times.
--local-file> Accepted multiple times.
--job-count
--memory-limitin MB
--specstructured spec in yson format
--format
--input-format
--output-format
--print-statistics
--asyncdo not track operation progress
--reduce-byColumns to reduce by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
--sort-byColumns to sort by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
--join-byColumns to join by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
remote-copy
copies source table from remote cluster to destination table on current cluster
usage: yt remote-copy [-h] [--params PARAMS] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE --cluster CLUSTER_NAME [--network NETWORK_NAME] [--copy-attributes] [--print-statistics] [--async]
[--cluster-connection CLUSTER_CONNECTION] [--spec SPEC]
Named Arguments
--paramsspecify additional params. structured params in yson format
--src(Required) path to source tables in remote cluster Accepted multiple times.
--dst(Required) path to destination table in current cluster
--cluster(Required) remote cluster proxy, like smith
--network
--copy-attributesspecify this flag to coping node attributes too
--print-statistics
--asyncdo not track operation progress
--cluster-connectionstructured cluster-connection in yson format
--specstructured spec in yson format
shuffle
shuffles table randomly
usage: yt shuffle [-h] [--params PARAMS] --table TABLE [--temp-column-name TEMP_COLUMN_NAME] [--print-statistics] [--async]
Named Arguments
--paramsspecify additional params. structured params in yson format
--table(Required)
--temp-column-name
--print-statistics
--asyncdo not track operation progress
sort
sorts source tables to destination table
usage: yt sort [-h] [--params PARAMS] --src SOURCE_TABLE [SOURCE_TABLE ...] --dst DESTINATION_TABLE --sort-by SORT_BY [--print-statistics] [--async] [--spec SPEC]
Named Arguments
--paramsspecify additional params. structured params in yson format
--src(Required) Accepted multiple times.
--dst(Required)
--sort-by(Required) Columns to sort by. In order to choose descending sort order, provide a map of form "{name=foo; sort_order=descending}"
--print-statistics
--asyncdo not track operation progress
--specstructured spec in yson format
vanilla
run vanilla operation
usage: yt vanilla [-h] [--params PARAMS] [--print-statistics] [--async] [--tasks TASKS] [--spec SPEC]
Named Arguments
--paramsspecify additional params. structured params in yson format
--print-statistics
--asyncdo not track operation progress
--taskstask descriptions. structured tasks in yson format
--specstructured spec in yson format
Operation commands
abort-op
aborts operation
usage: yt abort-op [-h] [--params PARAMS] [--reason REASON] [--operation OPERATION] [operation]
Positional Arguments
operationoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--reasonabort reason
--operationoperation id
complete-op
completes operation
usage: yt complete-op [-h] [--params PARAMS] [--operation OPERATION] [operation]
Positional Arguments
operationoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
get-operation
get operation attributes through API
usage: yt get-operation [-h] [--params PARAMS] [--attribute ATTRIBUTES] [--include-scheduler] [--operation OPERATION_ID] [--format FORMAT] [operation_id]
Positional Arguments
operation_idoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--attributedesired attributes in the response Accepted multiple times.
--include-schedulerrequest runtime operation information
--operationoperation id
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
list-operations
list operations that satisfy given options
usage: yt list-operations [-h] [--params PARAMS] [--user USER] [--state STATE] [--type TYPE] [--filter FILTER] [--pool-tree POOL_TREE] [--pool POOL] [--with-failed-jobs | --without-failed-jobs]
[--from-time FROM_TIME] [--to-time TO_TIME] [--cursor-time CURSOR_TIME] [--cursor-direction CURSOR_DIRECTION] [--include-archive] [--no-include-counters] [--limit LIMIT]
[--format FORMAT]
Named Arguments
--paramsspecify additional params. structured params in yson format
--userfilter operations by user
--statefilter operations by state
--typefilter operations by operation type
--filterfilter operation by some text factor. For example, part of the title can be passed to this option
--pool-treefilter operations by pool tree
--poolfilter operations by pool. If –pool-tree is set, filters operations with this pool in specified pool tree
--with-failed-jobsshow only operations with failed jobs
--without-failed-jobsshow only operations without failed jobs
--from-timelower limit for operations start time. Time is accepted as unix timestamp or time string in YTsaurus format
--to-timeupper limit for operations start time. Time is accepted as unix timestamp or time string in YTsaurus format
--cursor-timecursor time. Used in combination with –cursor-direction and –limit. Time is accepted as unix timestamp or time string in YTsaurus format
--cursor-directioncursor direction, can be one of («none», «past», «future»). Used in combination with –cursor-time and –limit
--include-archiveinclude operations from archive in result
--no-include-countersdo not include operation counters in result
--limitmaximum number of operations in output
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
resume-op
continues operation after suspending
usage: yt resume-op [-h] [--params PARAMS] [--operation OPERATION] [operation]
Positional Arguments
operationoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
suspend-op
suspends operation
usage: yt suspend-op [-h] [--params PARAMS] [--operation OPERATION] [--abort-running-jobs] [operation]
Positional Arguments
operationoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
--abort-running-jobsabort running jobs
track-op
synchronously tracks operation, prints current progress and finalize at the completion
usage: yt track-op [-h] [--params PARAMS] [--operation OPERATION] [operation]
Positional Arguments
operationoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
update-op-parameters
updates operation runtime parameters
usage: yt update-op-parameters [-h] [--params PARAMS] [--operation OPERATION_ID] [operation_id] parameters
Positional Arguments
operation_idoperation id
parametersstructured parameters in yson format
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
Job commands
abort-job
interrupts running job with preserved result
usage: yt abort-job [-h] [--params PARAMS] [--interrupt-timeout INTERRUPT_TIMEOUT] job_id
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--interrupt-timeouttry to interrupt job before abort during timeout (in ms)
get-job
get job of operation
usage: yt get-job [-h] [--params PARAMS] [--job-id JOB_ID] [--operation-id OPERATION_ID] [--format FORMAT] [job_id] [operation_id]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
operation_idoperation id, for example: 876084ca-efd01a47-3e8-7a62e787
Named Arguments
--paramsspecify additional params. structured params in yson format
--job-idjob id, for example: 5c51-24e204-384-9f3f6437
--operation-idoperation id, for example: 876084ca-efd01a47-3e8-7a62e787
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
get-job-input
get full input of the specified job
usage: yt get-job-input [-h] [--params PARAMS] [--job-id JOB_ID] [job_id]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--job-idjob id, for example: 5c51-24e204-384-9f3f6437
get-job-input-paths
get input paths of the specified job
usage: yt get-job-input-paths [-h] [--params PARAMS] [--job-id JOB_ID] [job_id]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--job-idjob id, for example: 5c51-24e204-384-9f3f6437
get-job-spec
get spec of the specified job
usage: yt get-job-spec [-h] [--params PARAMS] [--job-id JOB_ID] [--omit-node-directory | --no-omit-node-directory] [--omit-input-table-specs | --no-omit-input-table-specs]
[--omit-output-table-specs | --no-omit-output-table-specs]
[job_id]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--job-idjob id, for example: 5c51-24e204-384-9f3f6437
--omit-node-directoryWhether node directory should be removed from job spec (true by default)
--no-omit-node-directoryWhether node directory should be removed from job spec (true by default)
--omit-input-table-specsWhether input table specs should be removed from job spec (false by default)
--no-omit-input-table-specsWhether input table specs should be removed from job spec (false by default)
--omit-output-table-specsWhether output table specs should be removed from job spec (false by default)
--no-omit-output-table-specsWhether output table specs should be removed from job spec (false by default)
get-job-stderr
gets stderr of the specified job
usage: yt get-job-stderr [-h] [--params PARAMS] [--job-id JOB_ID] [--operation-id OPERATION_ID] [job_id] [operation_id]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
operation_idoperation id, for example: 876084ca-efd01a47-3e8-7a62e787
Named Arguments
--paramsspecify additional params. structured params in yson format
--job-idjob id, for example: 5c51-24e204-384-9f3f6437
--operation-idoperation id, for example: 876084ca-efd01a47-3e8-7a62e787
list-jobs
list jobs of operation
usage: yt list-jobs [-h] [--params PARAMS] [--operation OPERATION_ID] [--job-type JOB_TYPE] [--job-state JOB_STATE] [--address ADDRESS] [--job-competition-id JOB_COMPETITION_ID]
[--sort-field {type,state,start_time,finish_time,address,duration,progress,id}] [--sort-order SORT_ORDER] [--limit LIMIT] [--offset OFFSET] [--with-spec] [--with-stderr] [--with-fail-context]
[--with-competitors] [--with-monitoring-descriptor] [--with-interruption-info] [--include-cypress] [--include-runtime] [--include-archive] [--data-source {auto,runtime,archive,manual}]
[--format FORMAT] [operation_id]
Positional Arguments
operation_idoperation id
Named Arguments
--paramsspecify additional params. structured params in yson format
--operationoperation id
--job-typefilter jobs by job type
--job-statefilter jobs by job state
--addressfilter jobs by node address
--job-competition-idfilter jobs by job competition id
--sort-fieldPossible choices: type, state, start_time, finish_time, address, duration, progress, id
field to sort jobs by
--sort-ordersort order. Can be either «ascending» or «descending»
--limitoutput limit
--offsetoffset starting from zero
--with-spec
--with-stderr
--with-fail-context
--with-competitorswith competitive jobs
--with-monitoring-descriptor
--with-interruption-info
--include-cypressinclude jobs from Cypress in result. Have effect only if –data-source is set to «manual»
--include-runtimeinclude jobs from controller agents in result. Have effect only if –data-source is set to «manual»
--include-archiveinclude jobs from archive in result. Have effect only if –data-source is set to «manual»
--data-sourcePossible choices: auto, runtime, archive, manual
data sources to list jobs from
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
run-job-shell
runs interactive shell in the job sandbox
usage: yt run-job-shell [-h] [--params PARAMS] [--shell-name SHELL_NAME] [--timeout TIMEOUT] [--command COMMAND] job_id [command]
Positional Arguments
job_idjob id, for example: 5c51-24e204-384-9f3f6437
command
Named Arguments
--paramsspecify additional params. structured params in yson format
--shell-namename of the job shell to start
--timeoutinactivity timeout in milliseconds after job has finished, by default 60000 milliseconds
--command
Transaction commands
abort-tx
aborts transaction. All changes will be lost
usage: yt abort-tx [-h] [--params PARAMS] [--transaction TRANSACTION] [transaction]
Positional Arguments
transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
commit-tx
saves all transaction changes
usage: yt commit-tx [-h] [--params PARAMS] [--transaction TRANSACTION] [transaction]
Positional Arguments
transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
lock
tries to lock the path. Do not forget about global –tx option
usage: yt lock [-h] [--params PARAMS] [--path PATH] [--mode {snapshot,shared,exclusive}] [--waitable] [--wait-for WAIT_FOR] [--child-key CHILD_KEY] [--attribute-key ATTRIBUTE_KEY] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
--modePossible choices: snapshot, shared, exclusive
blocking type, exclusive by default
--waitablewait for lock if node is under blocking
--wait-forwait interval in milliseconds
--child-keychild key of shared lock
--attribute-keyattribute key of shared lock
ping-tx
prolongs transaction lifetime
usage: yt ping-tx [-h] [--params PARAMS] [--transaction TRANSACTION] [transaction]
Positional Arguments
transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
Named Arguments
--paramsspecify additional params. structured params in yson format
--transactiontransaction id, for example: 5c51-24e204-1-9f3f6437
start-tx
starts transaction
usage: yt start-tx [-h] [--params PARAMS] [--attributes ATTRIBUTES] [--timeout TIMEOUT]
Named Arguments
--paramsspecify additional params. structured params in yson format
--attributesstructured attributes in yson format
--timeouttransaction lifetime since last ping in milliseconds
unlock
tries to unlock the path
usage: yt unlock [-h] [--params PARAMS] [--path PATH] [path]
Positional Arguments
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--pathaddress in Cypress. See also: YPATH
ACL (permission) commands
add-member
adds member to Cypress node group
usage: yt add-member [-h] [--params PARAMS] [--member MEMBER] [--group GROUP] [member] [group]
Positional Arguments
member
group
Named Arguments
--paramsspecify additional params. structured params in yson format
--member
--group
check-permission
checks permission for Cypress node
usage: yt check-permission [-h] [--params PARAMS] [--user USER] [--permission PERMISSION] [--path PATH] [--read-from READ_FROM] [--cache-sticky-group-size CACHE_STICKY_GROUP_SIZE] [--columns COLUMNS]
[--format FORMAT]
[user] [permission] [path]
Positional Arguments
user
permissionone of read, write, administer, create, use
pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--user
--permissionone of read, write, administer, create, use
--pathaddress in Cypress. See also: YPATH
--read-fromCan be set to «cache» to enable reads from system cache
--cache-sticky-group-sizeSize of sticky group size for read_from=»cache» mode
--columnsstructured columns in yson format
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«<format=pretty>yson»
issue-token
issues a new token for user, reading password interactively and securely from console
usage: yt issue-token [-h] [--params PARAMS] user
Positional Arguments
useruser to issue token
Named Arguments
--paramsspecify additional params. structured params in yson format
list-user-tokens
lists sha256-encoded user tokens, reading password interactively and securely from console
usage: yt list-user-tokens [-h] [--params PARAMS] user
Positional Arguments
useruser to revoke token
Named Arguments
--paramsspecify additional params. structured params in yson format
remove-member
removes member from Cypress node group
usage: yt remove-member [-h] [--params PARAMS] [--member MEMBER] [--group GROUP] [member] [group]
Positional Arguments
member
group
Named Arguments
--paramsspecify additional params. structured params in yson format
--member
--group
revoke-token
revokes user token, reading password and maybe token value interactively and securely from console
usage: yt revoke-token [-h] [--params PARAMS] [--token-sha256 TOKEN_SHA256] user
Positional Arguments
useruser to revoke token
Named Arguments
--paramsspecify additional params. structured params in yson format
--token-sha256sha256-encoded token to revoke; if omitted, token value is requested interactively
set-user-password
updates user password, reading it and optionally a current password
usage: yt set-user-password [-h] [--params PARAMS] user
Positional Arguments
useruser to set password
Named Arguments
--paramsspecify additional params. structured params in yson format
Diagnostics
download-core-dump
downloads core dump for a given operation_id and job_id from a given core_table_path. Tool for downloading job core dumps
usage: yt download-core-dump [-h] [--params PARAMS] [--operation-id OPERATION_ID] [--core-table-path CORE_TABLE_PATH] [--job-id JOB_ID] [--core-index CORE_INDICES] [--output-directory OUTPUT_DIRECTORY]
Named Arguments
--paramsspecify additional params. structured params in yson format
--operation-idOperation id (should be specified if proper core file naming is needed)
--core-table-pathA path to the core table
--job-idId of a job that produced core dump. If not specified, an arbitrary job with core dumps is taken
--core-indexIndices of core dumps to download (indexing inside single job). Several indices may be specified. If not specified, all core dumps will be downloaded. Requires –job-id to be specified Accepted multiple times.
--output-directoryA directory to save the core dumps. Defaults to the current working directory, default:«.»
job-tool
Tool helps to debug user job code by preparing job environment on local machine.
It downloads all necessary job files, fail context (small portion of job input data)
and prepares run script.
usage: yt job-tool [-h] [--params PARAMS] command ...
Positional Arguments
commandPossible choices: prepare-job-environment, run-job
Named Arguments
--paramsspecify additional params. structured params in yson format
Sub-commands
prepare-job-environment
prepare all necessary stuff for job
yt job-tool prepare-job-environment [-h] [--operation-id OPERATION_ID] [--job-id JOB_ID] [--job-path JOB_PATH] [--run] [--full-input | --context] [operation_id] [job_id]
Positional Arguments
operation_id
job_id
Named Arguments
--operation-id
--job-id
--job-pathoutput directory to store job environment. Default:<cwd>/job_<job_id>
--runrun job when job environment is prepared
--full-input, --fulldownload input context of a job
--contextdownload fail context of a job
run-job
runs job binary
yt job-tool run-job [-h] [--job-path JOB_PATH] [--env ENV] [job_path]
Positional Arguments
job_pathpath to prepared job environment
Named Arguments
--job-pathpath to prepared job environment
--envenvironment to use in script run in YSON format
Parquet commands
dump-orc
dump table with a strict schema as ORC https://orc.apache.org/ file
usage: yt dump-orc [-h] [--params PARAMS] [--table TABLE] --output-file OUTPUT_FILE [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--output-file(Required)
dump-parquet
dump table with a strict schema as Parquet https://parquet.apache.org/docs file
usage: yt dump-parquet [-h] [--params PARAMS] [--table TABLE] [--output-path OUTPUT_PATH] [--output-file OUTPUT_FILE] [--enable-several-files] [--unordered] [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--output-path
--output-file
--enable-several-filesallowing parquet to be written to multiple files
--unordered
upload-orc
upload ORC https://orc.apache.org/ file as a table
usage: yt upload-orc [-h] [--params PARAMS] [--table TABLE] --input-file INPUT_FILE [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--input-file(Required)
upload-parquet
upload Parquet https://parquet.apache.org/docs file as a table
usage: yt upload-parquet [-h] [--params PARAMS] [--table TABLE] --input-file INPUT_FILE [table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--input-file(Required)
Queue
advance-consumer
advances consumer offset for the given queue
usage: yt advance-consumer [-h] [--params PARAMS] [--consumer-path CONSUMER_PATH] [--queue-path QUEUE_PATH] --partition-index PARTITION_INDEX [--old-offset OLD_OFFSET] --new-offset NEW_OFFSET
[consumer_path] [queue_path]
Positional Arguments
consumer_pathaddress in Cypress. See also: YPATH
queue_pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--consumer-pathaddress in Cypress. See also: YPATH
--queue-pathaddress in Cypress. See also: YPATH
--partition-index(Required)
--old-offset
--new-offset(Required)
list-queue-consumer-registrations
lists queue consumer registrations
usage: yt list-queue-consumer-registrations [-h] [--params PARAMS] [--queue-path QUEUE_PATH] [--consumer-path CONSUMER_PATH] [--format FORMAT]
Named Arguments
--paramsspecify additional params. structured params in yson format
--queue-pathPath to queue in Cypress; cluster may be specified. See also: YPATH
--consumer-pathPath to consumer in Cypress; cluster may be specified. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
pull-consumer
reads rows from a single partition of a queue (i.e. any ordered dynamic table) with authorization via consumer
usage: yt pull-consumer [-h] [--params PARAMS] [--consumer-path CONSUMER_PATH] [--queue-path QUEUE_PATH] --offset OFFSET --partition-index PARTITION_INDEX [--max-row-count MAX_ROW_COUNT]
[--max-data-weight MAX_DATA_WEIGHT] [--replica-consistency {none,sync}] [--format FORMAT]
[consumer_path] [queue_path]
Positional Arguments
consumer_pathaddress in Cypress. See also: YPATH
queue_pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--consumer-pathaddress in Cypress. See also: YPATH
--queue-pathaddress in Cypress. See also: YPATH
--offset(Required)
--partition-index(Required)
--max-row-count
--max-data-weight
--replica-consistencyPossible choices: none, sync
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
pull-queue
reads rows from a single partition of a queue (i.e. any ordered dynamic table)
usage: yt pull-queue [-h] [--params PARAMS] [--queue-path QUEUE_PATH] --offset OFFSET --partition-index PARTITION_INDEX [--max-row-count MAX_ROW_COUNT] [--max-data-weight MAX_DATA_WEIGHT]
[--replica-consistency {none,sync}] [--format FORMAT]
[queue_path]
Positional Arguments
queue_pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--queue-pathaddress in Cypress. See also: YPATH
--offset(Required)
--partition-index(Required)
--max-row-count
--max-data-weight
--replica-consistencyPossible choices: none, sync
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
register-queue-consumer
registers queue consumer
usage: yt register-queue-consumer [-h] [--params PARAMS] [--queue-path QUEUE_PATH] [--consumer-path CONSUMER_PATH] (--vital | --non-vital) [--partitions [PARTITIONS ...]] [queue_path] [consumer_path]
Positional Arguments
queue_pathaddress in Cypress. See also: YPATH
consumer_pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--queue-pathaddress in Cypress. See also: YPATH
--consumer-pathaddress in Cypress. See also: YPATH
--vitalWhether the consumer is vital
--non-vitalWhether the consumer is vital
--partitions
unregister-queue-consumer
unregisters queue consumer
usage: yt unregister-queue-consumer [-h] [--params PARAMS] [--queue-path QUEUE_PATH] [--consumer-path CONSUMER_PATH] [queue_path] [consumer_path]
Positional Arguments
queue_pathaddress in Cypress. See also: YPATH
consumer_pathaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--queue-pathaddress in Cypress. See also: YPATH
--consumer-pathaddress in Cypress. See also: YPATH
Query tracker
abort-query
abort query
usage: yt abort-query [-h] [--params PARAMS] [--message MESSAGE] [--stage STAGE] query_id
Positional Arguments
query_idquery id
Named Arguments
--paramsspecify additional params. structured params in yson format
--messageoptional abort message
--stagequery tracker stage, defaults to «production»
alter-query
alter query
usage: yt alter-query [-h] [--params PARAMS] [--annotations ANNOTATIONS] [--access-control-objects ACCESS_CONTROL_OBJECTS] [--stage STAGE] query_id
Positional Arguments
query_idquery id
Named Arguments
--paramsspecify additional params. structured params in yson format
--annotationsa YSON map of annotations. structured annotations in yson format
--access-control-objectsaccess control objects, a YSON list of ACO names. structured access-control-objects in yson format
--stagequery tracker stage, defaults to «production»
get-query
get query
usage: yt get-query [-h] [--params PARAMS] [--attribute ATTRIBUTES] [--stage STAGE] [--format FORMAT] query_id
Positional Arguments
query_idquery id
Named Arguments
--paramsspecify additional params. structured params in yson format
--attributedesired attributes in the response Accepted multiple times.
--stagequery tracker stage, defaults to «production»
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
get-query-result
get query result
usage: yt get-query-result [-h] [--params PARAMS] [--result-index RESULT_INDEX] [--stage STAGE] [--format FORMAT] query_id
Positional Arguments
query_idquery id
Named Arguments
--paramsspecify additional params. structured params in yson format
--result-indexindex of query result, defaults to 0
--stagequery tracker stage, defaults to «production»
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
list-queries
list operations that satisfy given options
usage: yt list-queries [-h] [--params PARAMS] [--user USER] [--engine ENGINE] [--state STATE] [--filter FILTER] [--from-time FROM_TIME] [--to-time TO_TIME] [--cursor-time CURSOR_TIME]
[--cursor-direction CURSOR_DIRECTION] [--limit LIMIT] [--attribute ATTRIBUTES] [--stage STAGE] [--format FORMAT]
Named Arguments
--paramsspecify additional params. structured params in yson format
--userfilter queries by user
--enginefilter queries by engine
--statefilter queries by state
--filterfilter queries by some text factor. For example, part of the query can be passed to this option
--from-timelower limit for operations start time. Time is accepted as unix timestamp or time string in YTsaurus format
--to-timeupper limit for operations start time. Time is accepted as unix timestamp or time string in YTsaurus format
--cursor-timecursor time. Used in combination with –cursor-direction and –limit. Time is accepted as unix timestamp or time string in YTsaurus format
--cursor-directioncursor direction, can be one of («none», «past», «future»). Used in combination with –cursor-time and –limit
--limitmaximum number of operations in output
--attributedesired attributes in the response Accepted multiple times.
--stagequery tracker stage, defaults to «production»
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
read-query-result
read query result
usage: yt read-query-result [-h] [--params PARAMS] [--result-index RESULT_INDEX] [--stage STAGE] [--format FORMAT] query_id
Positional Arguments
query_idquery id
Named Arguments
--paramsspecify additional params. structured params in yson format
--result-indexindex of query result, defaults to 0
--stagequery tracker stage, defaults to «production»
--formatoutput format. (yson string), one of «yson», «json», «yamr», «dsv», «yamred_dsv», «schemaful_dsv» with modifications. See also: Formats
start-query
start query
usage: yt start-query [-h] [--params PARAMS] [--settings SETTINGS] [--files FILES] [--access-control-object ACCESS_CONTROL_OBJECT] [--access-control-objects ACCESS_CONTROL_OBJECTS] [--stage STAGE] engine query
Positional Arguments
engineengine of a query, one of «ql», «yql», «chyt», «spyt»
queryquery text
Named Arguments
--paramsspecify additional params. structured params in yson format
--settingsadditional settings of a query in structured form. structured settings in yson format
--filesquery files, a YSON list of files, each of which is represented by a map with keys «name», «content», «type». Field «type» is one of «raw_inline_data», «url». structured files in yson format
--access-control-objectoptional access control object name (deprecated)
--access-control-objectsaccess control objects, a YSON list of ACO names. structured access-control-objects in yson format
--stagequery tracker stage, defaults to «production»
Other commands
add-maintenance
adds maintenance request for a given node
usage: yt add-maintenance [-h] [--params PARAMS] [-c COMPONENT] [-a ADDRESS] [-t TYPE] [--comment COMMENT]
Named Arguments
--paramsspecify additional params. structured params in yson format
-c, --component
-a, --address
-t, --type
--comment
admin
Administer commands
usage: yt admin [-h] admin_command ...
Positional Arguments
admin_commandPossible choices: switch-leader
Sub-commands
switch-leader
Switch master cell leader
yt admin switch-leader [-h] [--cell-id CELL_ID] [--new-leader-address NEW_LEADER_ADDRESS]
Named Arguments
--cell-id
--new-leader-address
chyt
ClickHouse over YTsaurus commands
usage: yt chyt [-h] clickhouse_command ...
Positional Arguments
clickhouse_commandPossible choices: start-clique, execute, ctl
Sub-commands
start-clique
starts a CHYT clique consisting of a given number of instances
yt chyt start-clique [-h] --instance-count INSTANCE_COUNT [--alias ALIAS] [--cypress-ytserver-clickhouse-path CYPRESS_YTSERVER_CLICKHOUSE_PATH]
[--cypress-clickhouse-trampoline-path CYPRESS_CLICKHOUSE_TRAMPOLINE_PATH] [--cypress-ytserver-log-tailer-path CYPRESS_YTSERVER_LOG_TAILER_PATH]
[--cypress-base-config-path CYPRESS_BASE_CONFIG_PATH] [--cpu-limit CPU_LIMIT] [--cypress-geodata-path CYPRESS_GEODATA_PATH] [--abort-existing] [--artifact-path ARTIFACT_PATH]
[--skip-version-compatibility-validation] [--spec SPEC] [--clickhouse-config CLICKHOUSE_CONFIG] [--memory-config MEMORY_CONFIG]
Named Arguments
--instance-count(Required)
--alias, --operation-aliasAlias for clique; may be also specified via CHYT_PROXY env variable
--cypress-ytserver-clickhouse-path
--cypress-clickhouse-trampoline-path
--cypress-ytserver-log-tailer-path
--cypress-base-config-pathDefault:«//sys/clickhouse/config»
--cpu-limit
--cypress-geodata-path
--abort-existingAbort existing operation under same alias
--artifact-pathpath for artifact directory; by default equals to //sys/clickhouse/kolkhoz/<operation_alias>
--skip-version-compatibility-validation(For developer use only)
--specstructured spec in yson format
--clickhouse-configClickHouse configuration patch. structured clickhouse-config in yson format
--memory-configMemory configuration. structured memory-config in yson format
execute
executes ClickHouse query in given CHYT clique
yt chyt execute [-h] [--alias ALIAS] [--query QUERY] [--format FORMAT] [--setting SETTING] [query]
Positional Arguments
queryQuery to execute; do not specify FORMAT in query, use –format instead
Named Arguments
--alias, --operation-aliasAlias for clique; may be also specified via CHYT_PROXY env variable
--queryQuery to execute; do not specify FORMAT in query, use –format instead
--formatClickHouse data format; refer to https://clickhouse.tech/docs/en/interfaces/formats/; default is TabSeparated, default:«TabSeparated»
--settingAdd ClickHouse setting to query in format= . Accepted multiple times.
ctl
CHYT controller
yt chyt ctl [--address ADDRESS] [--stage STAGE] [--cluster-name CLUSTER_NAME] command ...
Positional Arguments
command
Named Arguments
--addresscontroller service address; may contain {stage}, {family} and {host_suffix} parameters; the default value is fetched from the remote client config
--stagecontroller stage, default:«production»
--cluster-namecluster name under which the cluster is configured in the strawberry controller; the default value is fetched from the remote client config
clickhouse
ClickHouse over YTsaurus commands
usage: yt clickhouse [-h] clickhouse_command ...
Positional Arguments
clickhouse_commandPossible choices: start-clique, execute, ctl
Sub-commands
start-clique
starts a CHYT clique consisting of a given number of instances
yt clickhouse start-clique [-h] --instance-count INSTANCE_COUNT [--alias ALIAS] [--cypress-ytserver-clickhouse-path CYPRESS_YTSERVER_CLICKHOUSE_PATH]
[--cypress-clickhouse-trampoline-path CYPRESS_CLICKHOUSE_TRAMPOLINE_PATH] [--cypress-ytserver-log-tailer-path CYPRESS_YTSERVER_LOG_TAILER_PATH]
[--cypress-base-config-path CYPRESS_BASE_CONFIG_PATH] [--cpu-limit CPU_LIMIT] [--cypress-geodata-path CYPRESS_GEODATA_PATH] [--abort-existing] [--artifact-path ARTIFACT_PATH]
[--skip-version-compatibility-validation] [--spec SPEC] [--clickhouse-config CLICKHOUSE_CONFIG] [--memory-config MEMORY_CONFIG]
Named Arguments
--instance-count(Required)
--alias, --operation-aliasAlias for clique; may be also specified via CHYT_PROXY env variable
--cypress-ytserver-clickhouse-path
--cypress-clickhouse-trampoline-path
--cypress-ytserver-log-tailer-path
--cypress-base-config-pathDefault:«//sys/clickhouse/config»
--cpu-limit
--cypress-geodata-path
--abort-existingAbort existing operation under same alias
--artifact-pathpath for artifact directory; by default equals to //sys/clickhouse/kolkhoz/<operation_alias>
--skip-version-compatibility-validation(For developer use only)
--specstructured spec in yson format
--clickhouse-configClickHouse configuration patch. structured clickhouse-config in yson format
--memory-configMemory configuration. structured memory-config in yson format
execute
executes ClickHouse query in given CHYT clique
yt clickhouse execute [-h] [--alias ALIAS] [--query QUERY] [--format FORMAT] [--setting SETTING] [query]
Positional Arguments
queryQuery to execute; do not specify FORMAT in query, use –format instead
Named Arguments
--alias, --operation-aliasAlias for clique; may be also specified via CHYT_PROXY env variable
--queryQuery to execute; do not specify FORMAT in query, use –format instead
--formatClickHouse data format; refer to https://clickhouse.tech/docs/en/interfaces/formats/; default is TabSeparated, default:«TabSeparated»
--settingAdd ClickHouse setting to query in format= . Accepted multiple times.
ctl
CHYT controller
yt clickhouse ctl [--address ADDRESS] [--stage STAGE] [--cluster-name CLUSTER_NAME] command ...
Positional Arguments
command
Named Arguments
--addresscontroller service address; may contain {stage}, {family} and {host_suffix} parameters; the default value is fetched from the remote client config
--stagecontroller stage, default:«production»
--cluster-namecluster name under which the cluster is configured in the strawberry controller; the default value is fetched from the remote client config
detect-porto-layer
usage: yt detect-porto-layer [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
execute
. execute your command
usage: yt execute [-h] [--params PARAMS] command_name execute_params
Positional Arguments
command_name
execute_paramsstructured execute_params in yson format
Named Arguments
--paramsspecify additional params. structured params in yson format
execute-batch
executes requests in parallel as one batch request
usage: yt execute-batch [-h] [--params PARAMS] requests [requests ...]
Positional Arguments
requestsRequest description
Named Arguments
--paramsspecify additional params. structured params in yson format
explain-id
usage: yt explain-id [-h] [--params PARAMS] [--local] id
Positional Arguments
idid (GUID like string)
Named Arguments
--paramsspecify additional params. structured params in yson format
--localDo not gather info from cluster
flow
YTsaurus Flow commands
usage: yt flow [-h] flow_command ...
Positional Arguments
flow_commandPossible choices: start-pipeline, stop-pipeline, pause-pipeline, get-pipeline-spec, set-pipeline-spec, remove-pipeline-spec, get-pipeline-dynamic-spec, set-pipeline-dynamic-spec, remove-pipeline-dynamic-spec, get-pipeline-state, get-flow-view, show-logs
Sub-commands
start-pipeline
start YTsaurus Flow pipeline. Start YTsaurus Flow pipeline
yt flow start-pipeline [-h] [--pipeline-path PIPELINE_PATH] [--sync] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--syncWait for the pipeline to start
stop-pipeline
stop YTsaurus Flow pipeline. Stop YTsaurus Flow pipeline
yt flow stop-pipeline [-h] [--pipeline-path PIPELINE_PATH] [--sync] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--syncWait for the pipeline to stop
pause-pipeline
pause YTsaurus Flow pipeline. Pause YTsaurus Flow pipeline
yt flow pause-pipeline [-h] [--pipeline-path PIPELINE_PATH] [--sync] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--syncWait for the pipeline to pause
get-pipeline-spec
get YTsaurus Flow pipeline spec. Get YTsaurus Flow pipeline spec
yt flow get-pipeline-spec [-h] [--pipeline-path PIPELINE_PATH] [--format FORMAT] [--spec-path SPEC_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«<format=pretty>yson»
--spec-pathPath to part of the spec
set-pipeline-spec
set YTsaurus Flow pipeline spec. Set YTsaurus Flow pipeline spec
yt flow set-pipeline-spec [-h] [--pipeline-path PIPELINE_PATH] [--format FORMAT] [--expected-version EXPECTED_VERSION] [--force] [--spec-path SPEC_PATH] [--value VALUE] [pipeline_path] [value]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
valuenew spec attribute value
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«yson»
--expected-versionPipeline spec expected version
--forceSet spec even if pipeline is paused
--spec-pathPath to part of the spec
--valuenew spec attribute value
remove-pipeline-spec
remove YTsaurus Flow pipeline spec. Remove YTsaurus Flow pipeline spec
yt flow remove-pipeline-spec [-h] [--pipeline-path PIPELINE_PATH] [--expected-version EXPECTED_VERSION] [--force] [--spec-path SPEC_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--expected-versionPipeline spec expected version
--forceRemove spec even if pipeline is paused
--spec-pathPath to part of the spec
get-pipeline-dynamic-spec
get YTsaurus Flow pipeline dynamic spec. Get YTsaurus Flow pipeline dynamic spec
yt flow get-pipeline-dynamic-spec [-h] [--pipeline-path PIPELINE_PATH] [--format FORMAT] [--spec-path SPEC_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«<format=pretty>yson»
--spec-pathPath to part of the spec
set-pipeline-dynamic-spec
set YTsaurus Flow pipeline dynamic spec. Set YTsaurus Flow pipeline dynamic spec
yt flow set-pipeline-dynamic-spec [-h] [--pipeline-path PIPELINE_PATH] [--format FORMAT] [--expected-version EXPECTED_VERSION] [--spec-path SPEC_PATH] [--value VALUE] [pipeline_path] [value]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
valuenew spec attribute value
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«yson»
--expected-versionPipeline spec expected version
--spec-pathPath to part of the spec
--valuenew spec attribute value
remove-pipeline-dynamic-spec
remove YTsaurus Flow pipeline dynamic spec. Remove YTsaurus Flow pipeline dynamic spec
yt flow remove-pipeline-dynamic-spec [-h] [--pipeline-path PIPELINE_PATH] [--expected-version EXPECTED_VERSION] [--spec-path SPEC_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--expected-versionPipeline spec expected version
--spec-pathPath to part of the spec
get-pipeline-state
get YTsaurus Flow pipeline state. Get YTsaurus Flow pipeline state
yt flow get-pipeline-state [-h] [--pipeline-path PIPELINE_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
get-flow-view
get YTsaurus Flow flow view. Get YTsaurus Flow flow view
yt flow get-flow-view [-h] [--pipeline-path PIPELINE_PATH] [--format FORMAT] [--view-path VIEW_PATH] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats, default:«<format=pretty>yson»
--view-pathPath to part of the view
show-logs
get YTsaurus Flow controller logs. Show YTsaurus FLow logs
yt flow show-logs [-h] [--pipeline-path PIPELINE_PATH] [--count COUNT] [--attach] [--rate RATE] [--print-host] [pipeline_path]
Positional Arguments
pipeline_pathaddress in Cypress. See also: YPATH
Named Arguments
--pipeline-pathaddress in Cypress. See also: YPATH
--countThe number of last logs, default:25
--attachAttach to the logs stream
--rateLogs reading period in seconds, default:1.0
--print-hostPrint controller’s hostname
generate-timestamp
generates timestamp
usage: yt generate-timestamp [-h] [--params PARAMS]
Named Arguments
--paramsspecify additional params. structured params in yson format
get-features
retrieves supported cluster features (data types, codecs etc.). Get cluster features (types, codecs etc.)
usage: yt get-features [-h] [--params PARAMS] [--format FORMAT]
Named Arguments
--paramsspecify additional params. structured params in yson format
--formatresponse or input format: yson or json, for example: «<format=binary>yson». See also: Formats
jupyt
Jupyter over YTsaurus commands
usage: yt jupyt [-h] jupyter_command ...
Positional Arguments
jupyter_commandPossible choices: ctl
Sub-commands
ctl
JUPYT controller
yt jupyt ctl [--address ADDRESS] [--stage STAGE] [--cluster-name CLUSTER_NAME] command ...
Positional Arguments
command
Named Arguments
--addresscontroller service address; may contain {stage}, {family} and {host_suffix} parameters; the default value is fetched from the remote client config
--stagecontroller stage, default:«production»
--cluster-namecluster name under which the cluster is configured in the strawberry controller; the default value is fetched from the remote client config
remove-maintenance
removes maintenance requests from given node by id or filter
usage: yt remove-maintenance [-h] [--params PARAMS] [-c COMPONENT] [-a ADDRESS] [--id ID] [--ids IDS] [-t TYPE] [-u USER] [--mine MINE] [--all ALL]
Named Arguments
--paramsspecify additional params. structured params in yson format
-c, --component
-a, --address
--id
--idsstructured ids in yson format
-t, --type
-u, --user
--mineDefault:False
--allDefault:False
run-command-with-lock
. Run command under lock
usage: yt run-command-with-lock [-h] [--params PARAMS] [--shell] [--poll-period POLL_PERIOD] [--conflict-exit-code CONFLICT_EXIT_CODE] [--set-address] [--address-path ADDRESS_PATH] [--recursive]
path command [command ...]
Positional Arguments
pathPath to the lock in Cypress
commandCommand to execute
Named Arguments
--paramsspecify additional params. structured params in yson format
--shellRun command in subshell
--poll-periodPoll period for command process in seconds, default:1.0
--conflict-exit-codeExit code in case of lock conflict, default:1
--set-addressSet address of current host (in lock attribute by default)
--address-pathPath to set host address
--recursiveCreate lock path recursively
run-compression-benchmarks
Gets input table and recompresses it in all available codecs.
For each codec prints compression ratio, cpu_write and cpu_read.
usage: yt run-compression-benchmarks [-h] [--params PARAMS] [--table TABLE] [--all-codecs] [--sample-size SAMPLE_SIZE] [--format {json,csv}] [--max-operations MAX_OPERATIONS] [--time-limit-sec TIME_LIMIT_SEC]
[table]
Positional Arguments
tableaddress in Cypress. See also: YPATH
Named Arguments
--paramsspecify additional params. structured params in yson format
--tableaddress in Cypress. See also: YPATH
--all-codecsbenchmark every level of codecs with levels
--sample-sizeapproximate table’s sample fragment size in bytes, default:1000000000
--formatPossible choices: json, csv
output format, default:
«json»
--max-operationsmax count of parallel operations, default:10
--time-limit-sectime limit for one operation in seconds, default:200
show-default-config
returns default configuration of python API
usage: yt show-default-config [-h] [--params PARAMS] [--with-remote-patch] [--only-remote-patch]
Named Arguments
--paramsspecify additional params. structured params in yson format
--with-remote-patchwith patch from cluster
--only-remote-patchshow only patch from cluster
show-spec
shows available spec options of the operation
usage: yt show-spec [-h] [--params PARAMS] operation
Positional Arguments
operationoperation type
Named Arguments
--paramsspecify additional params. structured params in yson format
spark
SPYT commands
usage: yt spark [-h] spark_command ...
Positional Arguments
spark_commandPossible choices: find-cluster, livy
Sub-commands
find-cluster
print Spark urls. Print URLs of running Spark cluster
yt spark find-cluster [-h] [--discovery-path DISCOVERY_PATH]
Named Arguments
--discovery-pathCypress path for discovery files and logs, the same path must be used in start-spark-cluster. SPARK_YT_DISCOVERY_PATH env variable is used by default
livy
SPYT Livy commands
yt spark livy [-h] livy_command ...
Positional Arguments
livy_commandPossible choices: ctl
Sub-commands
####### ctl
LIVY controller
yt spark livy ctl [--address ADDRESS] [--stage STAGE] [--cluster-name CLUSTER_NAME] command ...
######## Positional Arguments
command
######## Named Arguments
--addresscontroller service address; may contain {stage}, {family} and {host_suffix} parameters; the default value is fetched from the remote client config
--stagecontroller stage, default:«production»
--cluster-namecluster name under which the cluster is configured in the strawberry controller; the default value is fetched from the remote client config
spyt
SPYT commands
usage: yt spyt [-h] spark_command ...
Positional Arguments
spark_commandPossible choices: find-cluster, livy
Sub-commands
find-cluster
print Spark urls. Print URLs of running Spark cluster
yt spyt find-cluster [-h] [--discovery-path DISCOVERY_PATH]
Named Arguments
--discovery-pathCypress path for discovery files and logs, the same path must be used in start-spark-cluster. SPARK_YT_DISCOVERY_PATH env variable is used by default
livy
SPYT Livy commands
yt spyt livy [-h] livy_command ...
Positional Arguments
livy_commandPossible choices: ctl
Sub-commands
####### ctl
LIVY controller
yt spyt livy ctl [--address ADDRESS] [--stage STAGE] [--cluster-name CLUSTER_NAME] command ...
######## Positional Arguments
command
######## Named Arguments
--addresscontroller service address; may contain {stage}, {family} and {host_suffix} parameters; the default value is fetched from the remote client config
--stagecontroller stage, default:«production»
--cluster-namecluster name under which the cluster is configured in the strawberry controller; the default value is fetched from the remote client config
transfer-account-resources
transfers resources between accounts
usage: yt transfer-account-resources [-h] [--params PARAMS] [--source-account SOURCE_ACCOUNT] [--destination-account DESTINATION_ACCOUNT] [--resource-delta RESOURCE_DELTA] [source_account] [destination_account]
Positional Arguments
source_account
destination_account
Named Arguments
--paramsspecify additional params. structured params in yson format
--source-account, --src
--destination-account, --dst
--resource-deltastructured resource-delta in yson format
transfer-pool-resources
transfers resources between pools
usage: yt transfer-pool-resources [-h] [--params PARAMS] [--source-pool SOURCE_POOL] [--destination-pool DESTINATION_POOL] [--pool-tree POOL_TREE] [--resource-delta RESOURCE_DELTA]
[source_pool] [destination_pool] [pool_tree]
Positional Arguments
source_pool
destination_pool
pool_tree
Named Arguments
--paramsspecify additional params. structured params in yson format
--source-pool, --src
--destination-pool, --dst
--pool-tree
--resource-deltastructured resource-delta in yson format
transform
transforms source table to destination table writing data with given compression and erasure codecs
usage: yt transform [-h] [--params PARAMS] [--src SOURCE_TABLE] [--dst DESTINATION_TABLE] [--erasure-codec ERASURE_CODEC] [--compression-codec COMPRESSION_CODEC] [--optimize-for OPTIMIZE_FOR]
[--desired-chunk-size DESIRED_CHUNK_SIZE] [--check-codecs] [--spec SPEC]
[source_table] [destination_table]
Positional Arguments
source_tablesource table
destination_tabledestination table (if not specified source table will be overwritten)
Named Arguments
--paramsspecify additional params. structured params in yson format
--srcsource table
--dstdestination table (if not specified source table will be overwritten)
--erasure-codecdesired erasure codec for table
--compression-codecdesired compression codec for table
--optimize-fordesired chunk format for table. Possible values: [«scan», «lookup»]
--desired-chunk-sizedesired chunk size in bytes
--check-codecscheck if table already has proper codecs before transforming
--specstructured spec in yson format