<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">If I need more proof of the lack of understanding of the problem from the general user population, here is a quote form </div><div class="">today’s Linkedin:</div><div class=""><br class=""></div><div class="">"<span style="color: rgb(51, 51, 51); font-family: Helvetica, Arial, sans-serif; line-height: 14px; background-color: rgb(241, 243, 245);" class="">The problem is that without structure (schema) one needs to program in a procedural language.</span><font color="#333333" face="Helvetica, Arial, sans-serif" class=""><span style="line-height: 14px;" class="">”</span></font></div><div class=""><span style="color: rgb(51, 51, 51); font-family: Helvetica, Arial, sans-serif; line-height: 14px; background-color: rgb(241, 243, 245);" class=""><br class=""></span></div><div class=""><span style="background-color: rgb(241, 243, 245);" class=""><font color="#333333" face="Helvetica, Arial, sans-serif" class=""><span style="line-height: 14px;" class="">Author will remain unknown….</span></font></span></div><div class=""><span style="background-color: rgb(241, 243, 245);" class=""><font color="#333333" face="Helvetica, Arial, sans-serif" class=""><span style="line-height: 14px;" class=""><br class=""></span></font></span></div><div class=""><span style="background-color: rgb(241, 243, 245);" class=""><font color="#333333" face="Helvetica, Arial, sans-serif" class=""><span style="line-height: 14px;" class="">Dana</span></font></span></div><div class=""><br class=""></div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On Jun 1, 2015, at 11:40 AM, daniela florescu <<a href="mailto:dflorescu@me.com" class="">dflorescu@me.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><br class=""><blockquote type="cite" class="">On Jun 1, 2015, at 10:51 AM, Michael Kay <<a href="mailto:mike@saxonica.com" class="">mike@saxonica.com</a>> wrote:<br class=""><br class=""><blockquote type="cite" class=""><br class="">Using SQL to process JSON is simply NOT POSSIBLE.<br class=""><br class=""></blockquote><br class="">Proof?<br class=""><br class="">My Ph.D. thesis in 1975 showed that you can use SQL to query hierarchic data. With the emphasis on “query”. The problems start with update. So long as you restrict yourself to query, you can map almost any data model onto any other.<br class=""></blockquote><br class="">Michael,<br class=""><br class="">you did not read my email properly.<br class=""><br class="">I did NOT say that if you map JSON to relations (one way or another), you cannot use SQL on the result of the mapping.<br class=""><br class="">I said: you cannot apply SQL DIRECTLY on the JSON structures, because it’s semantics is not designed for that.<br class=""><br class="">Com’on Michael. You worked with me for 16 years now. Do I look like I’m so naive and I don’t get things ?<br class=""><br class="">So, please. I understand that EVERYTHING (C++ objects, XML elements, COBOL structures,<br class="">assembly processing instructions, anything) can be mapped with enough brute force into relations, and that, without<br class="">loss of any information.<br class=""><br class="">So thank you for this notice, but it does not relate to my email. <br class=""><br class="">(BTW, I proved the same thing as you 2O years later…and this was 20 years ago…didn’t know about your PhD sorry….<br class=""><a href="http://homes.cs.washington.edu/~suciu/PAPERS/florescu-kossman.pdf" class="">http://homes.cs.washington.edu/~suciu/PAPERS/florescu-kossman.pdf</a><br class="">Apparently this is something that CS has to get it out of their system every 20 years …the time is up again, I guess…...)<br class=""><br class=""><br class="">The problem is that Drill (like everybody else in that bunch) apply SQL DIRECTLY on JSON structures, in the absence of any intermediary mapping<br class="">into relations, which is again, I repeat: A NON-SENSE.<br class=""><br class=""><br class="">And BTW Michael, if SQL would be good for querying hierarchical data, why in the world did we waste 16 years building XQuery !???<br class=""><br class=""><br class="">Just curious<br class="">Dana<br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class=""><br class="">Though the fact that you can do it doesn’t mean that it’s a good idea, of course. In those days the reason for doing it was that SQL was the only declarative query language in town, and that’s no longer the case.<br class=""><br class="">Michael Kay<br class="">Saxonica<br class=""><br class=""></blockquote><br class=""></div></blockquote></div><br class=""></body></html>