This is an automated email from the ASF dual-hosted git repository.

github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git


The following commit(s) were added to refs/heads/asf-site by this push:
     new be40b15f13 Publish built docs triggered by 
9ea67f538c06a4938a5e763bca05688e985071e0
be40b15f13 is described below

commit be40b15f13f7b35741b3ce0188f7cb3090473ec3
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Nov 3 20:44:32 2025 +0000

    Publish built docs triggered by 9ea67f538c06a4938a5e763bca05688e985071e0
---
 _sources/library-user-guide/upgrading.md.txt    | 14 ++++++++++++++
 _sources/user-guide/configs.md.txt              |  2 +-
 _sources/user-guide/sql/scalar_functions.md.txt |  2 +-
 library-user-guide/upgrading.html               | 13 +++++++++++++
 searchindex.js                                  |  2 +-
 user-guide/configs.html                         |  4 ++--
 user-guide/sql/scalar_functions.html            |  2 +-
 7 files changed, 33 insertions(+), 6 deletions(-)

diff --git a/_sources/library-user-guide/upgrading.md.txt 
b/_sources/library-user-guide/upgrading.md.txt
index af5c603404..0b227000f7 100644
--- a/_sources/library-user-guide/upgrading.md.txt
+++ b/_sources/library-user-guide/upgrading.md.txt
@@ -176,6 +176,20 @@ let indices = projection_exprs.column_indices();
 _execution plan_ of the query. With this release, `DESCRIBE query` now outputs
 the computed _schema_ of the query, consistent with the behavior of `DESCRIBE 
table_name`.
 
+### `datafusion.execution.time_zone` default configuration changed
+
+The default value for `datafusion.execution.time_zone` previously was a string 
value of `+00:00` (GMT/Zulu time).
+This was changed to be an `Option<String>` with a default of `None`. If you 
want to change the timezone back
+to the previous value you can execute the sql:
+
+```sql
+SET
+TIMEZONE = '+00:00';
+```
+
+This change was made to better support using the default timezone in scalar 
UDF functions such as
+`now`, `current_date`, `current_time`, and `to_timestamp` among others.
+
 ### Introduction of `TableSchema` and changes to `FileSource::with_schema()` 
method
 
 A new `TableSchema` struct has been introduced in the `datafusion-datasource` 
crate to better manage table schemas with partition columns. This struct helps 
distinguish between:
diff --git a/_sources/user-guide/configs.md.txt 
b/_sources/user-guide/configs.md.txt
index 7ca5eb8f7b..5950a4fa9a 100644
--- a/_sources/user-guide/configs.md.txt
+++ b/_sources/user-guide/configs.md.txt
@@ -77,7 +77,7 @@ The following configuration settings are available:
 | datafusion.execution.coalesce_batches                                   | 
true                      | When set to true, record batches will be examined 
between each operator and small batches will be coalesced into larger batches. 
This is helpful when there are highly selective filters or joins that could 
produce tiny output batches. The target batch size is determined by the 
configuration setting                                                           
                                [...]
 | datafusion.execution.collect_statistics                                 | 
true                      | Should DataFusion collect statistics when first 
creating a table. Has no effect after the table is created. Applies to the 
default `ListingTableProvider` in DataFusion. Defaults to true.                 
                                                                                
                                                                                
                          [...]
 | datafusion.execution.target_partitions                                  | 0  
                       | Number of partitions for query execution. Increasing 
partitions can increase concurrency. Defaults to the number of CPU cores on the 
system                                                                          
                                                                                
                                                                                
                [...]
-| datafusion.execution.time_zone                                          | 
+00:00                    | The default time zone Some functions, e.g. 
`EXTRACT(HOUR from SOME_TIME)`, shift the underlying datetime according to this 
time zone, and then extract the hour                                            
                                                                                
                                                                                
                          [...]
+| datafusion.execution.time_zone                                          | 
NULL                      | The default time zone Some functions, e.g. `now` 
return timestamps in this time zone                                             
                                                                                
                                                                                
                                                                                
                    [...]
 | datafusion.execution.parquet.enable_page_index                          | 
true                      | (reading) If true, reads the Parquet data page 
level metadata (the Page Index), if present, to reduce the I/O and number of 
rows decoded.                                                                   
                                                                                
                                                                                
                         [...]
 | datafusion.execution.parquet.pruning                                    | 
true                      | (reading) If true, the parquet reader attempts to 
skip entire row groups based on the predicate in the query and the metadata 
(min/max values) stored in the parquet file                                     
                                                                                
                                                                                
                       [...]
 | datafusion.execution.parquet.skip_metadata                              | 
true                      | (reading) If true, the parquet reader skip the 
optional embedded metadata that may be in the file Schema. This setting can 
help avoid schema conflicts when querying multiple parquet files with schemas 
containing compatible types but different metadata                              
                                                                                
                            [...]
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index d090b5b70c..7c88d1fd9c 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2629,7 +2629,7 @@ Additional examples can be found 
[here](https://github.com/apache/datafusion/blo
 
 ### `now`
 
-Returns the current UTC timestamp.
+Returns the current timestamp in the system configured timezone (None by 
default).
 
 The `now()` return value is determined at query time and will return the same 
timestamp, no matter when in the query plan the function executes.
 
diff --git a/library-user-guide/upgrading.html 
b/library-user-guide/upgrading.html
index 38dbf67b2b..728cd37c07 100644
--- a/library-user-guide/upgrading.html
+++ b/library-user-guide/upgrading.html
@@ -529,6 +529,18 @@ Users may need to update their paths to account for these 
changes.</p>
 <em>execution plan</em> of the query. With this release, <code class="docutils 
literal notranslate"><span class="pre">DESCRIBE</span> <span 
class="pre">query</span></code> now outputs
 the computed <em>schema</em> of the query, consistent with the behavior of 
<code class="docutils literal notranslate"><span class="pre">DESCRIBE</span> 
<span class="pre">table_name</span></code>.</p>
 </section>
+<section id="datafusion-execution-time-zone-default-configuration-changed">
+<h3><code class="docutils literal notranslate"><span 
class="pre">datafusion.execution.time_zone</span></code> default configuration 
changed<a class="headerlink" 
href="#datafusion-execution-time-zone-default-configuration-changed" 
title="Link to this heading">#</a></h3>
+<p>The default value for <code class="docutils literal notranslate"><span 
class="pre">datafusion.execution.time_zone</span></code> previously was a 
string value of <code class="docutils literal notranslate"><span 
class="pre">+00:00</span></code> (GMT/Zulu time).
+This was changed to be an <code class="docutils literal notranslate"><span 
class="pre">Option&lt;String&gt;</span></code> with a default of <code 
class="docutils literal notranslate"><span class="pre">None</span></code>. If 
you want to change the timezone back
+to the previous value you can execute the sql:</p>
+<div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="k">SET</span>
+<span class="n">TIMEZONE</span><span class="w"> </span><span 
class="o">=</span><span class="w"> </span><span 
class="s1">&#39;+00:00&#39;</span><span class="p">;</span>
+</pre></div>
+</div>
+<p>This change was made to better support using the default timezone in scalar 
UDF functions such as
+<code class="docutils literal notranslate"><span 
class="pre">now</span></code>, <code class="docutils literal notranslate"><span 
class="pre">current_date</span></code>, <code class="docutils literal 
notranslate"><span class="pre">current_time</span></code>, and <code 
class="docutils literal notranslate"><span 
class="pre">to_timestamp</span></code> among others.</p>
+</section>
 <section 
id="introduction-of-tableschema-and-changes-to-filesource-with-schema-method">
 <h3>Introduction of <code class="docutils literal notranslate"><span 
class="pre">TableSchema</span></code> and changes to <code class="docutils 
literal notranslate"><span class="pre">FileSource::with_schema()</span></code> 
method<a class="headerlink" 
href="#introduction-of-tableschema-and-changes-to-filesource-with-schema-method"
 title="Link to this heading">#</a></h3>
 <p>A new <code class="docutils literal notranslate"><span 
class="pre">TableSchema</span></code> struct has been introduced in the <code 
class="docutils literal notranslate"><span 
class="pre">datafusion-datasource</span></code> crate to better manage table 
schemas with partition columns. This struct helps distinguish between:</p>
@@ -1562,6 +1574,7 @@ take care of constructing the <code class="docutils 
literal notranslate"><span c
 <li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#reorganization-of-arrowsource-into-datafusion-datasource-arrow-crate">Reorganization
 of <code class="docutils literal notranslate"><span 
class="pre">ArrowSource</span></code> into <code class="docutils literal 
notranslate"><span class="pre">datafusion-datasource-arrow</span></code> 
crate</a></li>
 <li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#filescanconfig-projection-renamed-to-filescanconfig-projection-exprs"><code
 class="docutils literal notranslate"><span 
class="pre">FileScanConfig::projection</span></code> renamed to <code 
class="docutils literal notranslate"><span 
class="pre">FileScanConfig::projection_exprs</span></code></a></li>
 <li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#describe-query-support"><code class="docutils literal notranslate"><span 
class="pre">DESCRIBE</span> <span class="pre">query</span></code> 
support</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#datafusion-execution-time-zone-default-configuration-changed"><code 
class="docutils literal notranslate"><span 
class="pre">datafusion.execution.time_zone</span></code> default configuration 
changed</a></li>
 <li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#introduction-of-tableschema-and-changes-to-filesource-with-schema-method">Introduction
 of <code class="docutils literal notranslate"><span 
class="pre">TableSchema</span></code> and changes to <code class="docutils 
literal notranslate"><span class="pre">FileSource::with_schema()</span></code> 
method</a></li>
 <li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" 
href="#aggregateudfimpl-is-ordered-set-aggregate-has-been-renamed-to-aggregateudfimpl-supports-within-group-clause"><code
 class="docutils literal notranslate"><span 
class="pre">AggregateUDFImpl::is_ordered_set_aggregate</span></code> has been 
renamed to <code class="docutils literal notranslate"><span 
class="pre">AggregateUDFImpl::supports_within_group_clause</span></code></a></li>
 </ul>
diff --git a/searchindex.js b/searchindex.js
index 555fa0be5d..806ddfb557 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[60,"op-neq"]],"!~":[[60,"op-re-not-match"]],"!~*":[[60,"op-re-not-match-i"]],"!~~":[[60,"id19"]],"!~~*":[[60,"id20"]],"#":[[60,"op-bit-xor"]],"%":[[60,"op-modulo"]],"&":[[60,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[60,"op-multiply"]],"+":[[60,"op-plus"]],"-":[[60,"op-minus"]],"/":[[60,"op-divide"]],"<":[[60,"op-lt"]],"<
 [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[60,"op-neq"]],"!~":[[60,"op-re-not-match"]],"!~*":[[60,"op-re-not-match-i"]],"!~~":[[60,"id19"]],"!~~*":[[60,"id20"]],"#":[[60,"op-bit-xor"]],"%":[[60,"op-modulo"]],"&":[[60,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[60,"op-multiply"]],"+":[[60,"op-plus"]],"-":[[60,"op-minus"]],"/":[[60,"op-divide"]],"<":[[60,"op-lt"]],"<
 [...]
\ No newline at end of file
diff --git a/user-guide/configs.html b/user-guide/configs.html
index ac1feb43a1..0e36b86d2f 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -494,8 +494,8 @@ example, to configure <code class="docutils literal 
notranslate"><span class="pr
 <td><p>Number of partitions for query execution. Increasing partitions can 
increase concurrency. Defaults to the number of CPU cores on the system</p></td>
 </tr>
 <tr class="row-even"><td><p>datafusion.execution.time_zone</p></td>
-<td><p>+00:00</p></td>
-<td><p>The default time zone Some functions, e.g. <code class="docutils 
literal notranslate"><span class="pre">EXTRACT(HOUR</span> <span 
class="pre">from</span> <span class="pre">SOME_TIME)</span></code>, shift the 
underlying datetime according to this time zone, and then extract the 
hour</p></td>
+<td><p>NULL</p></td>
+<td><p>The default time zone Some functions, e.g. <code class="docutils 
literal notranslate"><span class="pre">now</span></code> return timestamps in 
this time zone</p></td>
 </tr>
 <tr 
class="row-odd"><td><p>datafusion.execution.parquet.enable_page_index</p></td>
 <td><p>true</p></td>
diff --git a/user-guide/sql/scalar_functions.html 
b/user-guide/sql/scalar_functions.html
index d92c75d150..f65c847864 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3133,7 +3133,7 @@ Can be a constant, column, or function.</p></li>
 </section>
 <section id="now">
 <h3><code class="docutils literal notranslate"><span 
class="pre">now</span></code><a class="headerlink" href="#now" title="Link to 
this heading">#</a></h3>
-<p>Returns the current UTC timestamp.</p>
+<p>Returns the current timestamp in the system configured timezone (None by 
default).</p>
 <p>The <code class="docutils literal notranslate"><span 
class="pre">now()</span></code> return value is determined at query time and 
will return the same timestamp, no matter when in the query plan the function 
executes.</p>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">now</span><span 
class="p">()</span>
 </pre></div>


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to