You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2023/03/08 01:31:00 UTC

[jira] [Created] (CALCITE-5565) Implement BigQuery LOG function

Tanner Clary created CALCITE-5565:
-------------------------------------

             Summary: Implement BigQuery LOG function
                 Key: CALCITE-5565
                 URL: https://issues.apache.org/jira/browse/CALCITE-5565
             Project: Calcite
          Issue Type: Task
            Reporter: Tanner Clary
            Assignee: Tanner Clary


Calcite currently supports the {{LN}} and {{LOG10}} function. BigQuery offers the {{LOG}} function which allows for the base of the logarithm to be specified as a second argument. If the second argument is not provided, the base is defaulted to e (making it identical to the {{LN}} function. 

Example: {{LOG(64, 10)}} would return {{2}}.
Example 2: {{LOG(10)}} would return the same as {{LN(10)}}.

[BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#log]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)