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 989b52575bd6dd1850ef81e98de8321a6dbfbc3e Author: luoyuxia <[email protected]> AuthorDate: Mon Aug 29 15:22:09 2022 +0800 [FLINK-29025][docs] add table sample page for Hive dialect --- .../hiveDialect/Queries/table-sample.md | 49 ++++++++++++++++++++++ .../hiveDialect/Queries/table-sample.md | 49 ++++++++++++++++++++++ 2 files changed, 98 insertions(+) diff --git a/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md b/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md new file mode 100644 index 00000000000..35b0caa9b92 --- /dev/null +++ b/docs/content.zh/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md @@ -0,0 +1,49 @@ +--- +title: "Table Sample" +weight: 11 +type: docs +--- +<!-- +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. +--> + +# Table Sample + +## Description + +The `TABLESAMPLE` statement is used to sample rows from the table. + +### Syntax + +```sql +TABLESAMPLE ( num_rows ROWS ) +``` +{{< hint warning >}} +**Note:** +Currently, only sample specific number of rows is supported. +{{< /hint >}} + +### Parameters + +- num_rows `ROWS` + + num_rows is a constant positive to specify how many rows to sample. + +### Examples + +```sql +SELECT * FROM src TABLESAMPLE (5 ROWS) +``` diff --git a/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md b/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md new file mode 100644 index 00000000000..35b0caa9b92 --- /dev/null +++ b/docs/content/docs/dev/table/hiveCompatibility/hiveDialect/Queries/table-sample.md @@ -0,0 +1,49 @@ +--- +title: "Table Sample" +weight: 11 +type: docs +--- +<!-- +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. +--> + +# Table Sample + +## Description + +The `TABLESAMPLE` statement is used to sample rows from the table. + +### Syntax + +```sql +TABLESAMPLE ( num_rows ROWS ) +``` +{{< hint warning >}} +**Note:** +Currently, only sample specific number of rows is supported. +{{< /hint >}} + +### Parameters + +- num_rows `ROWS` + + num_rows is a constant positive to specify how many rows to sample. + +### Examples + +```sql +SELECT * FROM src TABLESAMPLE (5 ROWS) +```
