[SPARK-15648] add TeradataDialect

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.6.1
• Fix Version/s: 2.3.0
• Component/s: SQL

Environment

Teardata database

• Assignee: Kirby Linvill
• Reporter: lihongli
• Created: 29/May/16 07:32
• Updated: 23/May/17 19:04
• Resolved: 23/May/17 19:04

Description

I found that Teradata does not have the Dialect in spark.So I want to add the TeradataDialect.scala in package org.apache.spark.sql.jdbc to support Teradata database better.
I override three functions in TeradataDialect.scala:
1.The url: jdbc:teradata
2.The JDBCType:Teradata database does not support "TEXT",so we replace it with "VARCHAR(255)".Also we replace "BLOB" with "VARBYTE(4)".
3.Teradata database does not support sql like "LIMIT 1",so we replace it with "TOP 1".

Issue Links

• links to: [Github] Pull Request #13359 (lihongliustc)
• links to: [Github] Pull Request #16746 (klinvill)