[CALCITE-2623] Add specific translation for POSITION, MOD and set operators in BigQuery and Hive SQL dialects

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available
• Assignee: KrishnaKant Agrawal
• Reporter: KrishnaKant Agrawal
• Created: 12/Oct/18 08:32
• Updated: 27/Feb/24 22:23
• Resolved: 07/Jan/19 20:54

Description

Owing to the syntactical differences between Calcite SQL and certain other Dialects, emulation for SqlNode unparsing needs to be added based on the Dialect in RelToSqlConcverter.

Saw some code in PostgreSqlDialect which is already doing this.

Changes in other Dialects can follow suit.

Issue Links

• relates to: CALCITE-3475 BigQuery SQL dialect unparseCall override broken for UNION ALL
• relates to: CALCITE-5064 Dialect factory returns ANSI SQL dialect for BigQuery
• links to: PR#877