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

Unable to use vendor specific datatypes with JDBC (MSSQL)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Incomplete
    • 2.4.5
    • None
    • SQL

    Description

      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 "com.microsoft.sqlserver.jdbc.SQLServerDriver"

      I'm getting an error:  org.apache.spark.sql.catalyst.parser.ParseException: DataType time(7) is not supported.(line 1, pos 43)

      What is then the point of using this option?

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            frankivo Frank Oosterhuis
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: