Yuanjian Li created SPARK-30125: ----------------------------------- Summary: Remove PostgreSQL dialect to reduce codebase maintenance cost Key: SPARK-30125 URL: https://issues.apache.org/jira/browse/SPARK-30125 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.0.0 Reporter: Yuanjian Li
As the discussion in [http://apache-spark-developers-list.1001551.n3.nabble.com/DISCUSS-PostgreSQL-dialect-td28417.html], we need to remove PostgreSQL dialect form code base for several reasons: 1. The current approach makes the codebase complicated and hard to maintain. 2. Fully migrating PostgreSQL workloads to Spark SQL is not our focus for now. Curently we have 3 features under PostgreSQL dialect: 1. SPARK-27931: when casting string to boolean, `t`, `tr`, `tru`, `yes`, .. are also allowed as true string. 2. SPARK-29364: `date - date` returns interval in Spark (SQL standard behavior), but return int in PostgreSQL 3. SPARK-28395: `int / int` returns double in Spark, but returns int in PostgreSQL. (there is no standard) -- 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