Live data from Hacker News

Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

news.ycombinator.com

41–50 of 85 posts

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#41

this is super cool stuff, and would've been really interesting to apply to spark stuff I had to do for Amazon's search system! How is this different than something like using spark-rapids on AWS EMR with GPU-enabled EC2 instances? Are you building on top of that spark-rapids, or is this a more custom solution?

> I started working on actually deploying a cloud-based data platform powered by GPUs (i.e. Spark-RAPIDS)

Based on this, the platform is using Spark-RAPIDS.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#42

this is super cool stuff, and would've been really interesting to apply to spark stuff I had to do for Amazon's search system! How is this different than something like using spark-rapids on AWS EMR with GPU-enabled EC2 instances? Are you building on top of that spark-rapids, or is this a more custom solution?

Good question -- it depends. For certain workloads, it might look exactly the same! For others, I found that the memory and VM constraints were creating large inefficiencies. Also, many teams simply don't want to manage that level of data infra: managing EMR, instance type optimization, spark optimization (now with GPU configs!), custom images, upgrades, etc.

We take care of that and make it as easy as pie... or so we hope! On top of that, we also deploy an external shuffle service, and deal with other plugins, connectors, etc.

I suppose it's similar to using Databricks Serverless SQL!

Another thing: we ran into an incompatible (i.e. non-accelerated) operation in one of our first real workloads, so we worked with our customer to speed up that workload even more with a small query optimization.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#44
post #39

Great, let me know if you want a 1x AMD MI300x VM to build/test on. Free. https://x.com/HotAisle/status/1921983426972025023

Nice! I attended a hackathon by Modular last weekend where we got to play with MI300X (sponsored by AMD and Crusoe). My team made a GPU-"accelerated" BM25 in Mojo, but mostly kind of failed at it, haha. The software stack for AMD is still a bit too nascent for ParaQuery's Spark engine, but certain realtime/online workloads can definitely be programmed pretty fast. They also happen to benefit greatly from the staggeri…

Great feedback and thanks for the follow on twitter.

Agreed, their software stack needs work, but thankfully that's why they are sponsoring developer events like you attended. The progress is happening fast and this is something that wasn't happening at all 6-12 months ago. It is a real shift in focus.

If you have specific areas you'd like me to pass up the chain for them in order for you to build support for your engine, please let me know and I'm happy to try to help however I can. It took a while for us to get there, but they are now extremely responsive to us.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#46

> they're saving over 60% off of their BigQuery bill how big is their data? A lot of BigQuery users would be surprised to find they don't need BigQuery. This[0] post (written by founding engineer of BigQuery) has a bit of hyperbole, but this part is inline with my experience: > A couple of years ago I did an analysis of BigQuery queries, looking at customers spending more than $1000 / year. 90% of queries processed l…

> A lot of BigQuery users would be surprised to find they don't need BigQuery.

No they wouldn't.

a) BigQuery is the only managed, supported solution on GCP for SQL based analytical workloads. And they are using it because they started with GCP and then chose BigQuery.

b) I have supported hundreds of Data Scientists over the years using Spark and it is nothing like BigQuery. You need to have much more awareness of how it all fits together because it is sitting on a JVM that when exposed to memory pressure will do a full GC and kill the executor. When this happens at best your workload gets significantly slower and at worst your job fails.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#47

This could be incredibly useful for me. Currently struggling to complete jobs with massive amounts of shuffle with Spark on EMR (large joins yielding 150+ billion rows). We use Glue currently, but it has become cost prohibitive.

You should try using an S3 based shuffle plugin: https://github.com/IBM/spark-s3-shuffle

Then mount FSX for Lustre on all of your EMR nodes and have it write shuffle data there. It will massively improve performance and shuffle issues will disappear.

Is expensive though. But you can offset the cost now because you can run entirely Spot instances for your workers as if you lose a node there's no recomputation of the shuffle data.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#48

> they're saving over 60% off of their BigQuery bill how big is their data? A lot of BigQuery users would be surprised to find they don't need BigQuery. This[0] post (written by founding engineer of BigQuery) has a bit of hyperbole, but this part is inline with my experience: > A couple of years ago I did an analysis of BigQuery queries, looking at customers spending more than $1000 / year. 90% of queries processed l…

> A lot of BigQuery users would be surprised to find they don't need BigQuery. No they wouldn't. a) BigQuery is the only managed, supported solution on GCP for SQL based analytical workloads. And they are using it because they started with GCP and then chose BigQuery. b) I have supported hundreds of Data Scientists over the years using Spark and it is nothing like BigQuery. You need to have much more awareness of how…

Hopefully, we can be another managed solution for those on GCP.

And as for your second point, yep, Spark tuning is definitely annoying! BigQuery is a lot more than jusr the engine, and building a simple interface for a complicated, high-performance process is hard. That's a big reason why I made ParaQuery.

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#49

nobody so far mentioned Apache Gluten yet. are you familiar? how do you compare?

Apache DataFusion Comet also exists which is similar:

https://datafusion.apache.org/comet/

Both are stop gaps though since optimised SIMD accelerated Vector support is coming to the JVM albeit extremely slowly: https://openjdk.org/jeps/508

Re: Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL

#50

Many of us have been using GPU accelerated Spark for years: https://developer.nvidia.com/rapids/ https://github.com/NVIDIA/spark-rapids And it's supported on AWS: https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spar...

Indeed, Spark-RAPIDS has been around for a while! And it's quite simple to have a setup that works. Most of the issues come after the initial PoC, especially for teams not wanting to manage infra, not to mention GPU infra.
Post reply on HN