GitHub user lihongliustc opened a pull request:
https://github.com/apache/spark/pull/13359
add TeradataDialect.scala
## What changes were proposed in this pull request?
add TeradataDialect.scala
## How was this patch tested?
(Please explain how this patch was tested. E.g. unit tests, integration
tests, manual tests)
we test the patch using Teradata database .
1.Without the patch,we can not create table bacause Teradata database does
not support "TEXT" type.After patched,we can create table on Teradata database.
2.Teradata database does not support keyword "LIMIT 1",so we can not excute
sql like "SELECT 1 FROM $TABLE LIMIT 1".We can excute sql like "SELECT TOP 1 1
FROM $TABLE".
Hi,
My name is LiHongli.I am working in Teradata.I want to add the
TeradataDialect.scala 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 [email protected] am appreciate if you aceept
the file.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/lihongliustc/spark master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/13359.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #13359
----
commit e97ebc1e4a07853f7c700d3aed95f3ed50b5bc78
Author: lihongliustc <[email protected]>
Date: 2016-05-27T12:39:17Z
add TeradataDialect.scala
Hi,
My name is LiHongli.I am working in Teradata.I want to add the
TeradataDialect.scala 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 [email protected] am appreciate if you aceept
the file.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
