gengliangwang commented on issue #26208: [WIP][SPARK-29540][SQL]Support cast StringType to DateType follow ansi URL: https://github.com/apache/spark/pull/26208#issuecomment-544975450 I think PostgreSQL is making exception for type conversion with constant values. If you tried the following SQL in PostgreSQL, ``` create table a(t timestamp); create table b(s varchar(20)); insert into a select * from b; ``` You will get following error: ``` ERROR: column "t" is of type timestamp without time zone but expression is of type character varying Hint: You will need to rewrite or cast the expression. ``` In the PR https://github.com/apache/spark/pull/26107, I disallow such conversion and update test cases intentionally.
---------------------------------------------------------------- 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]
