USE

Specifying the "database". As a rule, one of the YTsaurus clusters is used as a database. This database will be used by default to search for tables whenever the database hasn't been specified explicitly.

If the query doesn't include USE, then the cluster must be specified at the beginning of the table path in the format cluster.`path/to/table```` , for example cluster.`home/yql/test````. Backticks are used to automatically escape special characters (in this case, slashes).

Usually the cluster name is specified explicitly, but you can use an expression for it. In this case, USE must have the notation USE yt:$cluster_name, where $cluster_name is the named expression of the String type.

Alternatively, you can specify the cluster right at the beginning of the table path in the format ```yt:$cluster_name.`path/to/table````.

In this case, USE itself can be used inside actions or subquery templates. The current cluster value is inherited in the declarations of nested actions or subqueries. The influence area of USE stops after the end of the action or subquery template in which it was declared.

Examples

USE cluster_name;