Softwr

Machine Learning & Data Science · head to head

Amazon Redshift ML vs Apache Spark MLlib

Amazon Redshift ML logo

Amazon Redshift ML

Machine Learning & Data Science

Create machine learning models using SQL

From
Free
Rated
-
Full reviewWebsite
Apache Spark MLlib logo

Apache Spark MLlib

Machine Learning & Data Science

Scalable machine learning on Apache Spark

From
Free
Rated
-
Full reviewWebsite

The short version

  • Each has a real cost: Amazon Redshift ML free tier covers only two CREATE MODEL requests per month for two months, capped at 100,000 cells per request; beyond that training is metered at $20 per million cells for the first 10 million, dropping in tiers to $7 per million cells over 100 million; Apache Spark MLlib apache Spark MLlib is Apache 2.0 licensed and free with no paid tier from the Apache project itself; SLA-backed support has to be sourced from a third party such as a managed Spark vendor rather than from Apache.
  • They diverge on capability: Amazon Redshift ML covers SQL-based ML, Apache Spark MLlib covers Classification.

Where they differ

Only the attributes on which Amazon Redshift ML and Apache Spark MLlib actually diverge.

Attributes where Amazon Redshift ML and Apache Spark MLlib differ
AttributeAmazon Redshift MLApache Spark MLlib
Pricing modelusage-basedopen-source
PlatformsWebLinux, macOS, Windows
Founded20061999

Identical on both: starting price (Free), free tier (Yes), user rating (Not yet rated), category (Machine Learning & Data Science).

What each one covers

Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.

Only in Amazon Redshift ML

  • SQL-based ML
  • AutoML
  • SageMaker integration
  • BYOM support
  • In-database predictions
  • Amazon Redshift
  • SageMaker
  • S3

Only in Apache Spark MLlib

  • Classification
  • Regression
  • Clustering
  • Collaborative filtering
  • Feature engineering
  • Apache Spark
  • Hadoop
  • Kafka

What people use each for

The jobs each tool is most often brought in to do.

Amazon Redshift ML

  • Training and running machine learning models directly from SQL inside Amazon Redshiftnot Apache Spark MLlib

Apache Spark MLlib

  • Large-scale distributed machine learning on Spark clustersnot Amazon Redshift ML
  • Classification and regression with decision trees, random forests, gradient-boosted treesnot Amazon Redshift ML
  • Clustering with K-means and Gaussian Mixture Modelsnot Amazon Redshift ML

Where each one falls short

Documented limitations, not opinions. Every one is a constraint you would hit in normal use.

Amazon Redshift ML

  • Free tier covers only two CREATE MODEL requests per month for two months, capped at 100,000 cells per request; beyond that training is metered at $20 per million cells for the first 10 million, dropping in tiers to $7 per million cells over 100 million

Apache Spark MLlib

  • Apache Spark MLlib is Apache 2.0 licensed and free with no paid tier from the Apache project itself; SLA-backed support has to be sourced from a third party such as a managed Spark vendor rather than from Apache.

Pricing, plan by plan

Amazon Redshift ML

Free
  • Free TrialFree
    • 2-month trial
    • 750 DC2.Large hours
  • On-Demand$0.25/hour
    • Per-node pricing
    • SageMaker training

Apache Spark MLlib

Free

No published plan breakdown. See the Apache Spark MLlib review.

Which should you pick?

Choose Amazon Redshift ML if

  • You need sql-based ml.
  • You want to start without paying.
  • You also want automl.
Amazon Redshift ML review

Choose Apache Spark MLlib if

  • You need classification.
  • You want to start without paying.
  • You work on Linux, macOS, Windows.
  • You also want regression.
Apache Spark MLlib review

Questions people ask

Is Amazon Redshift ML or Apache Spark MLlib better?
Neither clearly leads. Amazon Redshift ML starts at Free and Apache Spark MLlib at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
Which is cheaper, Amazon Redshift ML or Apache Spark MLlib?
Amazon Redshift ML starts at Free and Apache Spark MLlib at Free.
Does Amazon Redshift ML or Apache Spark MLlib run on more platforms?
Amazon Redshift ML runs on Web. Apache Spark MLlib runs on Linux, macOS, Windows.
Can I use Amazon Redshift ML for free?
Both have a free tier, so you can try either at no cost before committing.
What is Amazon Redshift ML best used for?
Amazon Redshift ML is most often used for training and running machine learning models directly from sql inside amazon redshift. Of those, training and running machine learning models directly from sql inside amazon redshift is not what Apache Spark MLlib is typically brought in for.
What can Amazon Redshift ML do that Apache Spark MLlib cannot?
Amazon Redshift ML covers SQL-based ML, AutoML, SageMaker integration, BYOM support. Apache Spark MLlib covers Classification, Regression, Clustering, Collaborative filtering.
ShareXLinkedInRedditWhatsAppEmail

Related pages

More on Amazon Redshift ML

More on Apache Spark MLlib

Keep looking

Other head to heads