You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Frank Oosterhuis (Jira)" <ji...@apache.org> on 2020/03/11 10:57:00 UTC
[jira] [Commented] (SPARK-31039) Unable to use vendor specific
datatypes with JDBC (MSSQL)
[ https://issues.apache.org/jira/browse/SPARK-31039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17056863#comment-17056863 ]
Frank Oosterhuis commented on SPARK-31039:
------------------------------------------
[~hyukjin.kwon]: I'm not sure I agree with the title change. I suppose this potentially is a problem for any database.
> Unable to use vendor specific datatypes with JDBC (MSSQL)
> ---------------------------------------------------------
>
> Key: SPARK-31039
> URL: https://issues.apache.org/jira/browse/SPARK-31039
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.4.5
> Reporter: Frank Oosterhuis
> Priority: Major
>
> I'm trying to create a table in MSSQL with a time(7) type.
> For this I'm using the createTableColumnTypes option like "CallStartTime time(7)", with driver "{color:#212121}com.microsoft.sqlserver.jdbc.SQLServerDriver"{color}
> I'm getting an error: {color:#212121}org.apache.spark.sql.catalyst.parser.ParseException: DataType time(7) is not supported.(line 1, pos 43){color}
> {color:#212121}What is then the point of using this option?{color}
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org