Ye Li created SPARK-37096: ----------------------------- Summary: Where clause and where operator will report error on varchar column type Key: SPARK-37096 URL: https://issues.apache.org/jira/browse/SPARK-37096 Project: Spark Issue Type: Bug Components: PySpark, SQL Affects Versions: 3.1.2, 3.1.1 Reporter: Ye Li
create table test1(col1 int, col2 varchar(120)) stored as orc; insert into test1 values(123, 'abc'); insert into test1 values(1234, 'abcd'); sparkSession.sql(‘select * from bdctemp.liye_test202110212’) is OK,but sparkSession.sql(‘select * from bdctemp.liye_test202110212 where col2 = “abc”’) or sparkSession.sql(‘select * from bdctemp.liye_test202110212’).where(‘col2 = “abc”’) report error: java.lang.UnsuppotedOperationException: DataType: varchar(120) -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org