CLI and Python API
You can use the CHYT CLI and the CHYT Python API to run your clique or send a query to CHYT from a program or the command line. They can be obtained as part of the ytsaurus-client
.
The command line utility accepts two environment variables: YT_PROXY
and CHYT_ALIAS
. You can use the former to specify the YTsaurus cluster, and the latter to specify the used clique.
For example, you can use the following command for Linux and macOS to set environment variables and no longer pass the --proxy <cluster_name>
and --alias ch_public
parameters to all subsequent calls:
export YT_PROXY=<cluster_name> CHYT_ALIAS=ch_public
Note
To ensure compatibility with older versions, a clique alias can be specified with an asterisk at the beginning. In this case, it is ignored.
The process that launches the clique can sometimes be informally called a launcher.
ytsaurus-client
The main way to get started with YTsaurus is to install the ytsaurus-client
package. For more information, see Python Wrapper.
The package includes yt
. In order to use the CHYT features, you can run any command as yt clickhouse [command]
.
For example, you can make a test query to the public clique ch_public
as follows:
yt clickhouse execute "select 'Hello world'" --alias ch_public
The package additionally contains the CHYT Python API available in the yt.clickhouse
module:
python3
Python 3.7.3 (default, Oct 7 2019, 12:56:13)
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import yt.clickhouse as chyt
>>> import yt.wrapper as yt
>>> client = yt.YtClient("<cluster_name>")
>>> list(chyt.execute("select * from `//home/user/sample_table`", alias="ch_public", client=client))
[{'a': 100}, {'a': 101}, {'a': 102}, {'a': 205}, {'a': 206}, {'a': 1100}]
The library is available for Python 3.
For more detailed specification of the Python API and CLI features, see Executing queries.