[ https://issues.apache.org/jira/browse/SPARK-37895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-37895. --------------------------------- Fix Version/s: 3.3.0 Resolution: Fixed Issue resolved by pull request 35726 [https://github.com/apache/spark/pull/35726] > Error while joining two tables with non-english field names > ----------------------------------------------------------- > > Key: SPARK-37895 > URL: https://issues.apache.org/jira/browse/SPARK-37895 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.2.0, 3.3.0 > Reporter: Marina Krasilnikova > Assignee: Pablo Langa Blanco > Priority: Minor > Fix For: 3.3.0 > > > While trying to join two tables with non-english field names in postgresql > with query like > "select view1.`Имя1` , view1.`Имя2`, view2.`Имя3` from view1 left join view2 > on view1.`Имя2`=view2.`Имя4`" > we get an error which says that there is no field "`Имя4`" (field name is > surrounded by backticks). > It appears that to get the data from the second table it constructs query like > SELECT "Имя3","Имя4" FROM "public"."tab2" WHERE ("`Имя4`" IS NOT NULL) > and these backticks are redundant in WHERE clause. -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org