lipzhu commented on issue #24004: [SPARK-27084][SQL] Add function alias for bitand/bitnot/bitor/bitxor URL: https://github.com/apache/spark/pull/24004#issuecomment-471262269 > I think we would generally not copy non-standard language features from other DBs. I am not sure this is worth it. Could be convinced if there is a common need for these bitwise operations, but UDFs are so easy in Spark that it takes away most need for these functions as builtins The existing Spark bit functions use symbols (~,&,|,^) are not ANSI SQL standard functions. Seems PostgreSQL,MySQL use symbols like that and Teradata/Oracle use bitand/bitor... For Spark, some bit functions are using worlds to name the bit function(shiftright, shiftleft) and the others use symbols(~,&,|,^). Can we unify all the bit related functions by using symbols like (>>, << , ~,&,|,^) or just like Teradata using(shiftright, shiftleft,bitand,bitor,bitnot,bitxor) or support both styles? Correct me if I am wrong. Unification of function naming would reduce our SQL analyzer's effort to switch from Teradata to SparkSQL.
---------------------------------------------------------------- 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]
