Redshift provides a set of JSON functions that allows performing JSON operations but did anyone have tested the performance of JSON compared to normal table columns? The main reason I want to use Redshift is the columnar nature of it because I want to perform complex aggregations on analytical data that I stored in Redshift.
Does Redshift store the JSON data still in columnar format? Are there any side effects of storing data in JSON format instead of normal way?
Aucun commentaire:
Enregistrer un commentaire