[CALCITE-3282] HiveSqlDialect should unparse INTEGER type as INT in order to be compatible with Hive1.x

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: feng huang
• Created: 22/Aug/19 10:53
• Updated: 06/Mar/20 04:34
• Resolved: 16/Sep/19 10:23

Description

Every database might have different type or same type but different type name, therefore making every SqlDialect unparse their own data type is a suitable way.

For example, there is a sql “select cast(col as int) from table” change to hive sql "select cast(col as integer) from table", but "integer" is not allowed in hive.

Issue Links

• links to: GitHub Pull Request #1443
• links to: https://github.com/apache/calcite/pull/1443