3 ms·

I'm working on moving some analytics from pig + hadoop streaming over to Redshift. The debug cycles are so much faster with sql queries.

• blumkvist 12y ago
  You can use sql on hadoop...
• threeseed 12y ago
  I am assuming you tried Hive, Impala, Spark SQL ? Redshift seems like a great fit for Adhoc analytics. Just a shame you can't run it in your own data centre (some of us can't use the cloud).
  • ddorian43 12y ago
    You can use citusdb (postgresql, columnar). Not the same, but close.
• alecco 12y ago
  If you are using SQL... why didn't you try a columnar engine?
  • saosebastiao 12y ago
    Redshift is a columnar engine
• bagels 11y ago
  To all those who have asked, yes, hive is also in use.