[
https://issues.apache.org/jira/browse/SPARK-15648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lihongli updated SPARK-15648:
-----------------------------
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".
was:
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".
My Teradata mailbox is hongli...@teradata.com.I am appreciate if you aceept the
file.
> add TeradataDialect
> -------------------
>
> Key: SPARK-15648
> URL: https://issues.apache.org/jira/browse/SPARK-15648
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 1.6.1
> Environment: Teardata database
> Reporter: lihongli
> Labels: patch
> Fix For: 1.6.1
>
> Attachments: TeradataDialect.scala
>
>
> 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".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
