This is an automated email from the ASF dual-hosted git repository. jark pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git
commit caefdc74153928091c9225dfe63c870f418f82f5 Author: luoyuxia <[email protected]> AuthorDate: Mon Aug 29 15:42:36 2022 +0800 [FLINK-29025][docs] add set page for Hive dialect --- .../dev/table/hiveCompatibility/hiveDialect/set.md | 72 ++++++++++++++++++++++ .../dev/table/hiveCompatibility/hiveDialect/set.md | 72 ++++++++++++++++++++++ 2 files changed, 144 insertions(+) diff --git a/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/set.md b/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/set.md new file mode 100644 index 00000000000..17008d7464b --- /dev/null +++ b/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/set.md @@ -0,0 +1,72 @@ +--- +title: "SET Statements" +weight: 8 +type: docs +aliases: +- /dev/table/hiveCompatibility/hiveDialect/create.html +--- +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + http://www.apache.org/licenses/LICENSE-2.0 +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +# SET Statements + +## Description + +The `SET` statement sets a property which provide a ways to set variables for a session and +configuration property including system variable and Hive configuration. +But environment variable can't be set via `SET` statement. The behavior of `SET` with Hive dialect is compatible to Hive's. + +## Syntax + +```sql +SET key=value; +``` + +## EXAMPLES + +```sql +-- set Flink's configuration +SET 'table.sql-dialect'='default'; + +-- set Hive's configuration +SET hiveconf:k1=v1; + +-- set system property +SET system:k2=v2; + +-- set vairable for current session +SET hivevar:k3=v3; + +-- get value for configuration +SET hiveconf:k1; +SET system:k2; +SET hivevar:k3; + +-- print options +SET -v; +SET; +``` + +{{< hint warning >}} +**Note:** + +In Hive, the `SET` command `SET xx=yy` whose key has no prefix is equivalent to `SET hiveconf:xx=yy`, which means it'll set it to Hive Conf. + +But in Flink, with Hive dialect, such `SET` command `set xx=yy` will set `xx` with value `yy` to Flink's configuration. + +So, if you want to set configuration to Hive's Conf, please add the prefix `hiveconf:`, using the `SET` command like `SET hiveconf:xx=yy`. +{{< /hint >}} diff --git a/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/set.md b/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/set.md new file mode 100644 index 00000000000..17008d7464b --- /dev/null +++ b/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/set.md @@ -0,0 +1,72 @@ +--- +title: "SET Statements" +weight: 8 +type: docs +aliases: +- /dev/table/hiveCompatibility/hiveDialect/create.html +--- +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + http://www.apache.org/licenses/LICENSE-2.0 +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +# SET Statements + +## Description + +The `SET` statement sets a property which provide a ways to set variables for a session and +configuration property including system variable and Hive configuration. +But environment variable can't be set via `SET` statement. The behavior of `SET` with Hive dialect is compatible to Hive's. + +## Syntax + +```sql +SET key=value; +``` + +## EXAMPLES + +```sql +-- set Flink's configuration +SET 'table.sql-dialect'='default'; + +-- set Hive's configuration +SET hiveconf:k1=v1; + +-- set system property +SET system:k2=v2; + +-- set vairable for current session +SET hivevar:k3=v3; + +-- get value for configuration +SET hiveconf:k1; +SET system:k2; +SET hivevar:k3; + +-- print options +SET -v; +SET; +``` + +{{< hint warning >}} +**Note:** + +In Hive, the `SET` command `SET xx=yy` whose key has no prefix is equivalent to `SET hiveconf:xx=yy`, which means it'll set it to Hive Conf. + +But in Flink, with Hive dialect, such `SET` command `set xx=yy` will set `xx` with value `yy` to Flink's configuration. + +So, if you want to set configuration to Hive's Conf, please add the prefix `hiveconf:`, using the `SET` command like `SET hiveconf:xx=yy`. +{{< /hint >}}
