clwang24 edited a comment on issue #16209: [SPARK-10849][SQL] Adds option to the JDBC data source write for user to specify database column type for the create table URL: https://github.com/apache/spark/pull/16209#issuecomment-554906611 It's now can specify target database _CLOB_ or _BLOB_ data type? @sureshthalamati i use "_createTableColumnTypes_" option when write BLOB data in ORACLE DataBase but return error (ora-00902 invalid datatype), the scala code just as shown below: ` df.write.mode(SaveMode.Overwrite) .option("createTableColumnTypes", "id int, Name binary") .jdbc(url1, "TEST.USERDBTYPETEST", properties)` Then i try change column type as BLOB, but return error "DataType blob is not supported.(line 1, pos 437)", the scala code just as shown below: 'df.write.mode(SaveMode.Overwrite) .option("createTableColumnTypes", "id int, Name blob") .jdbc(url1, "TEST.USERDBTYPETEST", properties)' The last i try to no specify column type, but return another error "ora-12899 value too large for column (actual 581 maximum 255)" because StrignDataType default mappping varchar(255). Can you spare time to help me with this question? thx
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
