Re: Inner join with the table itself

2018-01-15 Thread Jacek Laskowski
Hi Michael, -dev +user What's the query? How do you "fool spark"? Pozdrawiam, Jacek Laskowski https://about.me/JacekLaskowski Mastering Spark SQL https://bit.ly/mastering-spark-sql Spark Structured Streaming https://bit.ly/spark-structured-streaming Mastering Kafka Streams https://bit.ly/ma

Inner join with the table itself

2018-01-15 Thread Michael Shtelma
Hi all, If I try joining the table with itself using join columns, I am getting the following error: "Join condition is missing or trivial. Use the CROSS JOIN syntax to allow cartesian products between these relations.;" This is not true, and my join is not trivial and is not a real cross join. I