Re:Why I wrote a SQL engine in (only) Python
by marsupialtail_2 on Friday December 30, 2022 @09:18PM
(#34192786)
None of the benchmarks involved any UDFs.
Re:Why I wrote a SQL engine in (only) Python
by Epa095 on Friday December 30, 2022 @09:45PM
(#34192959)
There is also pandas udfs, which uses arrow as the exchange format. I assume it still has to copy the data (?), but it makes the (de)serializarion fast, and allows for vectorized operations.
https://spark.apache.org/docs/3.0.0/sql-pyspark-pandas-with-...
~One suggestion, a Scala/Java Spark run of those benchmarks should be a valid baseline to compare against as well instead of PySpark.~ Ah it's SparkSQL so the execution probably wouldn't have much of py4j involvement, except for the collect.