This is an automated email from the ASF dual-hosted git repository. gurwls223 pushed a commit to branch branch-3.0 in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.0 by this push: new 43fedb8 [SPARK-31434][SQL][DOCS] Drop builtin function pages from SQL references 43fedb8 is described below commit 43fedb861733bddea32936a7cbc1d4e3d7a2c9e4 Author: Takeshi Yamamuro <yamam...@apache.org> AuthorDate: Tue Apr 14 10:22:46 2020 +0900 [SPARK-31434][SQL][DOCS] Drop builtin function pages from SQL references ### What changes were proposed in this pull request? This PR intends to drop the built-in function pages from SQL references. We've already had a complete list of built-in functions in the API documents. See related discussions for more details: https://github.com/apache/spark/pull/28170#issuecomment-611917191 ### Why are the changes needed? For better SQL documents. ### Does this PR introduce any user-facing change? ![functions](https://user-images.githubusercontent.com/692303/79109009-793e5400-7db2-11ea-8cb7-4c3cf31ccb77.png) ### How was this patch tested? Manually checked. Closes #28203 from maropu/DropBuiltinFunctionDocs. Authored-by: Takeshi Yamamuro <yamam...@apache.org> Signed-off-by: HyukjinKwon <gurwls...@apache.org> (cherry picked from commit 853c6c990999ecb35e4a2b3222d47be3e209eb81) Signed-off-by: HyukjinKwon <gurwls...@apache.org> --- docs/_data/menu-sql.yaml | 24 ++++++------------------ docs/sql-ref-functions-builtin-aggregate.md | 22 ---------------------- docs/sql-ref-functions-builtin-array.md | 22 ---------------------- docs/sql-ref-functions-builtin-date-time.md | 22 ---------------------- docs/sql-ref-functions-builtin-scalar.md | 22 ---------------------- docs/sql-ref-functions-builtin.md | 26 -------------------------- docs/sql-ref-functions-udf.md | 26 -------------------------- docs/sql-ref-functions.md | 11 ++++++++++- 8 files changed, 16 insertions(+), 159 deletions(-) diff --git a/docs/_data/menu-sql.yaml b/docs/_data/menu-sql.yaml index b8c6e50..badb98d 100644 --- a/docs/_data/menu-sql.yaml +++ b/docs/_data/menu-sql.yaml @@ -242,23 +242,11 @@ - text: Functions url: sql-ref-functions.html subitems: - - text: Build-in Functions - url: sql-ref-functions-builtin.html - subitems: - - text: Build-in Aggregate Functions - url: sql-ref-functions-builtin-aggregate.html - - text: Build-in Array Functions - url: sql-ref-functions-builtin-array.html - - text: Build-in Date Time Functions - url: sql-ref-functions-builtin-date-time.html - - text: UDFs (User-Defined Functions) - url: sql-ref-functions-udf.html - subitems: - - text: Scalar UDFs (User-Defined Functions) - url: sql-ref-functions-udf-scalar.html - - text: UDAFs (User-Defined Aggregate Functions) - url: sql-ref-functions-udf-aggregate.html - - text: Integration with Hive UDFs/UDAFs/UDTFs - url: sql-ref-functions-udf-hive.html + - text: Scalar UDFs (User-Defined Functions) + url: sql-ref-functions-udf-scalar.html + - text: UDAFs (User-Defined Aggregate Functions) + url: sql-ref-functions-udf-aggregate.html + - text: Integration with Hive UDFs/UDAFs/UDTFs + url: sql-ref-functions-udf-hive.html - text: Datetime Pattern url: sql-ref-datetime-pattern.html diff --git a/docs/sql-ref-functions-builtin-aggregate.md b/docs/sql-ref-functions-builtin-aggregate.md deleted file mode 100644 index d595436..0000000 --- a/docs/sql-ref-functions-builtin-aggregate.md +++ /dev/null @@ -1,22 +0,0 @@ ---- -layout: global -title: Built-in Aggregate Functions -displayTitle: Built-in Aggregate Functions -license: | - 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. ---- - -Aggregate functions \ No newline at end of file diff --git a/docs/sql-ref-functions-builtin-array.md b/docs/sql-ref-functions-builtin-array.md deleted file mode 100644 index 599d10c..0000000 --- a/docs/sql-ref-functions-builtin-array.md +++ /dev/null @@ -1,22 +0,0 @@ ---- -layout: global -title: Built-in Array Functions -displayTitle: Built-in Array Functions -license: | - 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. ---- - -Array Functions diff --git a/docs/sql-ref-functions-builtin-date-time.md b/docs/sql-ref-functions-builtin-date-time.md deleted file mode 100644 index 1042132..0000000 --- a/docs/sql-ref-functions-builtin-date-time.md +++ /dev/null @@ -1,22 +0,0 @@ ---- -layout: global -title: Built-in Date and Time Functions -displayTitle: Built-in Date and Time Functions -license: | - 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. ---- - -Date-Time Functions diff --git a/docs/sql-ref-functions-builtin-scalar.md b/docs/sql-ref-functions-builtin-scalar.md deleted file mode 100644 index 1d818a2..0000000 --- a/docs/sql-ref-functions-builtin-scalar.md +++ /dev/null @@ -1,22 +0,0 @@ ---- -layout: global -title: Builtin Scalar Functions -displayTitle: Builtin Scalar Functions -license: | - 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. ---- - -**This page is under construction** diff --git a/docs/sql-ref-functions-builtin.md b/docs/sql-ref-functions-builtin.md deleted file mode 100644 index 917c081..0000000 --- a/docs/sql-ref-functions-builtin.md +++ /dev/null @@ -1,26 +0,0 @@ ---- -layout: global -title: Built-in Functions -displayTitle: Built-in Functions -license: | - 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. ---- - -Spark SQL defines built-in functions to use, a complete list of which can be found [here](api/sql/). Among them, Spark SQL has several special categories of built-in functions: [Aggregate Functions](sql-ref-functions-builtin-aggregate.html) to operate on a group of rows, [Array Functions](sql-ref-functions-builtin-array.html) to operate on Array columns, and [Date and Time Functions](sql-ref-functions-builtin-date-time.html) to operate on Date and Time. - - * [Aggregate Functions](sql-ref-functions-builtin-aggregate.html) - * [Array Functions](sql-ref-functions-builtin-array.html) - * [Date and Time Functions](sql-ref-functions-builtin-date-time.html) diff --git a/docs/sql-ref-functions-udf.md b/docs/sql-ref-functions-udf.md deleted file mode 100644 index 2c5f204..0000000 --- a/docs/sql-ref-functions-udf.md +++ /dev/null @@ -1,26 +0,0 @@ ---- -layout: global -title: UDFs (User-Defined Functions) -displayTitle: UDFs (User-Defined Functions) -license: | - 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. ---- - -User-Defined Functions (UDFs) are a feature of Spark SQL that allows users to define their own functions when the system's built-in functions are not enough to perform the desired task. To use UDFs in Spark SQL, users must first define the function, then register the function with Spark, and finally call the registered function. The User-Defined Functions can act on a single row or act on multiple rows at once. Spark SQL also supports integration of existing Hive implementations of UDFs, [...] - - * [Scalar User-Defined Functions (UDFs)](sql-ref-functions-udf-scalar.html) - * [User-Defined Aggregate Functions (UDAFs)](sql-ref-functions-udf-aggregate.html) - * [Integration with Hive UDFs/UDAFs/UDTFs](sql-ref-functions-udf-hive.html) diff --git a/docs/sql-ref-functions.md b/docs/sql-ref-functions.md index dabf90b..e8a0353 100644 --- a/docs/sql-ref-functions.md +++ b/docs/sql-ref-functions.md @@ -19,4 +19,13 @@ license: | limitations under the License. --- -Spark SQL defines commonly used functions as built-in functions. It also provides User-Defined Functions (UDFs) to allow users to define their own functions when the system’s built-in functions are not enough to perform the desired task. +Spark SQL provides two function features to meet a wide range of user needs: built-in functions and user-defined functions (UDFs). +Built-in functions are commonly used routines that Spark SQL predefines and a complete list of the functions can be found in the [Built-in Functions](api/sql/) API document. UDFs allow users to define their own functions when the system’s built-in functions are not enough to perform the desired task. + +### UDFs (User-Defined Functions) + +User-Defined Functions (UDFs) are a feature of Spark SQL that allows users to define their own functions when the system's built-in functions are not enough to perform the desired task. To use UDFs in Spark SQL, users must first define the function, then register the function with Spark, and finally call the registered function. The User-Defined Functions can act on a single row or act on multiple rows at once. Spark SQL also supports integration of existing Hive implementations of UDFs, [...] + + * [Scalar User-Defined Functions (UDFs)](sql-ref-functions-udf-scalar.html) + * [User-Defined Aggregate Functions (UDAFs)](sql-ref-functions-udf-aggregate.html) + * [Integration with Hive UDFs/UDAFs/UDTFs](sql-ref-functions-udf-hive.html) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org