You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "王俊博 (Jira)" <ji...@apache.org> on 2024/04/03 08:09:00 UTC
[jira] [Updated] (SPARK-47707) Special handling of JSON type for MySQL connector
[ https://issues.apache.org/jira/browse/SPARK-47707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
王俊博 updated SPARK-47707:
------------------------
Description:
MySQL JDBC drivers `mysql-connector-java-5.1.49.jar` converts JSON type into Types.CHAR with a precision of Int.Max.
When receiving CHAR with Int.Max precision, Spark executor will throw an error of `java.lang.OutOfMemoryError: Requested array size exceeds VM limit `.
For {{mysql-connector-java-5.1.49.jar}} json sqlType is {{Char}} and precision is {{{}Int.Max{}}}.
For {{mysql-connector-java-8.0.16.jar}} json sqlType is {{LONGVARCHAR}} and precision is {{{}Int.Max{}}}.
Spark use {{mysql-connector-java-8.0.16.jar}} is right.
```
{{ private def getCatalystType(
sqlType: Int,
typeName: String,
precision: Int,
scale: Int,
signed: Boolean,
isTimestampNTZ: Boolean): DataType = sqlType match \{
...
case java.sql.Types.LONGNVARCHAR => StringType
...
}}}
{{}}
```
If compatibility with 5.1.49 is not required, the current code is sufficient.
was:
MySQL JDBC drivers `mysql-connector-java-5.1.49.jar` converts JSON type into Types.CHAR with a precision of Int.Max.
When receiving CHAR with Int.Max precision, Spark executor will throw an error of {{java.lang.OutOfMemoryError: Requested array size exceeds VM limit }}.
> Special handling of JSON type for MySQL connector
> -------------------------------------------------
>
> Key: SPARK-47707
> URL: https://issues.apache.org/jira/browse/SPARK-47707
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.4.0
> Environment: mysql-connector-java-5.1.49.jar
> spark-3.5.0
> Reporter: 王俊博
> Priority: Minor
>
> MySQL JDBC drivers `mysql-connector-java-5.1.49.jar` converts JSON type into Types.CHAR with a precision of Int.Max.
> When receiving CHAR with Int.Max precision, Spark executor will throw an error of `java.lang.OutOfMemoryError: Requested array size exceeds VM limit `.
> For {{mysql-connector-java-5.1.49.jar}} json sqlType is {{Char}} and precision is {{{}Int.Max{}}}.
> For {{mysql-connector-java-8.0.16.jar}} json sqlType is {{LONGVARCHAR}} and precision is {{{}Int.Max{}}}.
> Spark use {{mysql-connector-java-8.0.16.jar}} is right.
> ```
> {{ private def getCatalystType(
> sqlType: Int,
> typeName: String,
> precision: Int,
> scale: Int,
> signed: Boolean,
> isTimestampNTZ: Boolean): DataType = sqlType match \{
> ...
> case java.sql.Types.LONGNVARCHAR => StringType
> ...
> }}}
> {{}}
> ```
> If compatibility with 5.1.49 is not required, the current code is sufficient.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org