[CALCITE-5565] Implement BigQuery LOG function

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 08/Mar/23 01:30
• Updated: 27/Jul/23 10:22
• Resolved: 11/Apr/23 01:54

Description

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

Issue Links

• links to: GitHub Pull Request #3099