zheniantoushipashi commented on a change in pull request #33201:
URL: https://github.com/apache/spark/pull/33201#discussion_r683234940



##########
File path: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/Cast.scala
##########
@@ -54,38 +54,38 @@ object Cast {
 
     case (NullType, _) => true
 
-    case (_, StringType) => true
+    case (_, StringType | CharType(_) | VarcharType(_)) => true

Review comment:
       
   
   the method cast will change the type char/varchar to StringType,  so   cast 
method allows conversion from other types to CHAR/VARCHAR, although a warn 
message is printed.
   
   
   
![image](https://user-images.githubusercontent.com/3105102/128316157-26022c5e-5ac2-471a-aeff-42b0888986e5.png)
   
   
   
![image](https://user-images.githubusercontent.com/3105102/128316118-9dc15053-6a4e-48d0-aeeb-f0f3edf7c42b.png)
   
   
   in my application code,  I first use the canCast method to determine whether 
the type conversion can be performed before calling the cast method for 
conversion。
   
   
   
   **i  think the canCast method muse be consistent with Cast method**
   
   
   @cloud-fan  
   
   
   

##########
File path: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/Cast.scala
##########
@@ -54,38 +54,38 @@ object Cast {
 
     case (NullType, _) => true
 
-    case (_, StringType) => true
+    case (_, StringType | CharType(_) | VarcharType(_)) => true

Review comment:
       in my application code, I bring this commit, and rebuid and test, all ut 
and end-to-end test is passed, I'm working on upgrading spark from 2.4.1 to 
3.1.1, which Kylin Enterprise Edition depends on   
   
   @cloud-fan 

##########
File path: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/Cast.scala
##########
@@ -54,38 +54,38 @@ object Cast {
 
     case (NullType, _) => true
 
-    case (_, StringType) => true
+    case (_, StringType | CharType(_) | VarcharType(_)) => true

Review comment:
       I think people call the Cast.canCast method to use cast for the next 
step. Since the cast method internally converts from CHAR/VARCHAR type to 
StringType by default, then I think the canCast method should also convert 
CHAR/VARCHAR like StringType 
   
   @cloud-fan 
   
   




-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to