huaxingao commented on a change in pull request #29837: URL: https://github.com/apache/spark/pull/29837#discussion_r493965798
########## File path: docs/sql-ref-datatypes.md ########## @@ -314,3 +314,33 @@ SELECT COUNT(*), c2 FROM test GROUP BY c2; | 3| Infinity| +---------+---------+ ``` + +#### Data type compatibility + +The following is the hierarchy of data type compatibility. In an operation involving different and compatible data types, these will be promoted to the lowest common top type to perform the operation. + +For example, if you have an add operation between an integer and a float, the integer will be treated as a float, the least common compatible type, resulting the operation in a float. + +The most common operations where this hierarchy is applied are: Review comment: @gatorsmile WDYT? Do you want to have a table to list the most common rules like the one in https://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0008477.html? ---------------------------------------------------------------- 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org