Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-43362

Special handling of JSON type for MySQL connector

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete CommentsDelete
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 3.4.0
    • 3.5.0
    • SQL

    Description

      MySQL JSON type is converted into JDBC VARCHAR type with precision of -1 on some MariaDB drivers.
      When receiving VARCHAR with negative precision, Spark will throw an error.

      This ticket purposes to special case this scenario by directly converting JSON type into StringType in MySQLDialect.

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            adrianhu96 Tianhan Hu Assign to me
            adrianhu96 Tianhan Hu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment