Jacky Woo created CALCITE-3247: ---------------------------------- Summary: wrong sql format when transforming ANSI sql to hive sql Key: CALCITE-3247 URL: https://issues.apache.org/jira/browse/CALCITE-3247 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.19.0 Reporter: Jacky Woo
When we use HiveSqlDialect and transform "sql", we expect SUBSTRING(' abc', 2),but get SUBSTRING(' abc', 2) which is incorrect sql format in hive. So maybe HiveSqlDialect behavior should be changed when transform function SUBSTRING: # {{SELECT SUBSTRING('ABC', 2) => SELECT SUBSTRING('ABC', 2)}} # {{SELECT SUBSTRING('ABC', 2, 3) => SELECT SUBSTRING('ABC', 2, 3) }} # {{SELECT SUBSTRING('ABC' FROM 2) => SELECT SUBSTRING('ABC', 2) }} # {{SELECT SUBSTRING('ABC' FROM 2 FOR 3) => SELECT SUBSTRING('ABC', 2, 3) }} -- This message was sent by Atlassian JIRA (v7.6.14#76016)