Error Log:
Caused by: java.sql.SQLException: The isolation level ‘READ-UNCOMMITTED’ is not supported. Set tidb_skip_isolation_level_check=1 to skip this error
Solution:
val tidb_url = ""//Fill in your own tidb url
val table_name = "aa"//the tidb table to insert
val properties = new Properties()
properties.setProperty("user","username") properties.setProperty("password","123456")
sparkSession.sql("select * from table").write.mode(SaveMode.Append).option("isolationLevel","NONE").jdbc(tidb_url,table_name,properties)
Read More:
- pyspark : NameError: name ‘spark’ is not defined
- After switching the tidb database, an error could not commit JDBC transaction appears from time to time
- org.apache.hadoop.hive.ql.exec.spark.SparkTask. Failed to create Spark client for Spark session 0354
- Spark shell startup error, error: not found: value spark (low level solved)
- Class ‘PHPWord_Writer_Word2003‘ not found
- An error is reported when executing MVN. The diamond operator is not supported in source-1.5
- fatal: protocol ‘https‘ is not supported
- The Excel connection manager is not supported in the 64-bit version of SSIS [Switch]
- The key “target densitydpi” is not supported
- The docker copies the win10 host file into the docker container. An error is reported: copying between containers is not supported
- Assignment under multiple single edges is not supported for synthesis
- Authentication error occurred on remote connection, the required function is not supported
- ERROR: pygame-1.9.2-cp35-cp35m-win32.whl is not a supported wheel on this platform.
- tf.gradients is not supported when eager execution is enabled. Use tf.GradientTape instead.
- Error starting day: SELinux is not supported with the overlay 2
- Springcloud Feign Upload MultipartFile Error: Current req is not a multipart request Content type not supported
- (-2:Unspecified error) could not find a writer for the specified extension in function‘cv::imwrite_
- When feign is called, the solution of request method ‘post’ not supported appears
- Idea update failure problem: couldn’t save uncommitted changes solution
- Refused to apply style from ＜URL＞ because its MIME type (‘text/html‘) is not a supported stylesheet