Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-15648

add TeradataDialect

    XMLWordPrintableJSON

    Details

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

      Teardata database

      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".

        Attachments

          Activity

            People

            • Assignee:
              kjlinvill@gmail.com Kirby Linvill
              Reporter:
              lihongli lihongli
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: