Github user rama-mullapudi commented on the pull request:
https://github.com/apache/spark/pull/8374#issuecomment-134608423
I was using Oracle and IBM Netezza databases to write to, I thought of
adding Jdbc dialect but in case of strings CLOB is the one without character
limit which can be added to jdbc dialect but most databases i.e Oracle, DB2,
Teradata have restrictions on usage of CLOB columns ex can not use CLOB columns
in group by or distinct. Since VARCHAR(n) is the most preferred option for
these databases and in most cases its VARCHAR(255) or less, what would be best
way to implement string to VARCHAR conversion.
My idea is to provide an optional jdbc connection parameter so developer
can decide to use VARCHAR(20) or VARCHAR(2000) or CLOB and can pass it as jdbc
connection options and all string columns for that table will use the data type
passed by developer.
---
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]
