Re: Left Join at SQL query gets planned as inner join

2020-04-30 Thread Ryan C. Kleck
He’s saying you need to move the filters for the ‘p’ table in order to do what you want. They need to be before your WHERE. The order of operations in sql applies your join clause filters before the WHERE. The filters on your ‘s’ table need to stay in the WHERE. It’s the only time the ordering m

Re: What does Blockchain technology mean for Big Data? And how Hadoop/Spark will play role with it?

2017-12-19 Thread Ryan C. Kleck
IMO blockchain won’t be doing anything for big data anytime soon. It is not distributed (it’s “decntralized”). All blockchain data is replicated to ALL nodes in the network. At the moment there is a game involving breeding cats that is already clogging up ethereum blockchain. Blockchain might