[CALCITE-3072] Generate right SQL for FLOOR&SUBSTRING functions in SparkSqlDialect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.20.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Feng Zhu
• Created: 16/May/19 05:33
• Updated: 24/Jun/19 15:02
• Resolved: 20/May/19 01:45

Description

The FLOOR and SUBSTRING functions are currently broken when generating query for Spark SQL[1].

FLOOR ->  DATE_TRUNC
SUBSTRING('Hello World' FROM 5 FOR 1) -> SUBSTRING('Hello World', 5, 1)

[1] https://spark.apache.org/docs/latest/api/sql/index.html

Issue Links

• links to: GitHub Pull Request #1216