<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="">Dear Michael,<div class=""><br class=""></div><div class="">I still have a question: can we use U-SQL to process JSON or XML?</div><div class=""><br class=""></div><div class="">I could’t see a way of doing this — as they are not flat rows…</div><div class=""><br class=""></div><div class="">So is it possible ?</div><div class=""><br class=""></div><div class="">Thanks, regards</div><div class="">Dana</div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Nov 3, 2015, at 10:23 PM, daniela florescu <<a href="mailto:dflorescu@me.com" class="">dflorescu@me.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Dear Michael, <div class=""><br class=""></div><div class="">Thanks for the pointers. </div><div class=""><br class=""></div><div class="">I was looking at <a href="https://azure.microsoft.com/en-us/documentation/articles/data-lake-analytics-u-sql-get-started/" class="">https://azure.microsoft.com/en-us/documentation/articles/data-lake-analytics-u-sql-get-started/</a></div><div class="">and trying to understand the big picture from examples.</div><div class=""><br class=""></div><div class="">So U-SQL is a dataflow scripting language, where the basic data model is a set of rows with C# types, and each</div><div class="">step in the data flow is an expression that can mix (at many levels) SQL’s Select-from-where constructs with C# code.</div><div class=""><br class=""></div><div class="">That’s what I understand at least. Let me know if I got it wrong.</div><div class=""><br class=""></div><div class="">Seems very useful for expressing complex data transformations of all kinds, and it is still optimizable.</div><div class=""><br class=""></div><div class="">Much more useful for “data science” (whatever this big word means..) then the series of SQL-wannabes languages</div><div class=""> from the NoSQL vendors.</div><div class=""><br class=""></div><div class="">Thanks, best regards</div><div class="">Dana</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Nov 2, 2015, at 4:56 PM, Michael Rys <<a href="mailto:mrys@microsoft.com" class="">mrys@microsoft.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">No formal specification. Just a language reference that is still under development :). See <a href="http://aka.ms/usql_reference" class="">http://aka.ms/usql_reference</a> (and pardon the format, I am writing it and our doc people "convert" it).<br class=""><br class="">Let me know if you want a personal demo :).<br class=""><br class="">Cheers<br class="">Michael<br class=""><br class="">-----Original Message-----<br class="">From: <a href="mailto:talk-bounces@x-query.com" class="">talk-bounces@x-query.com</a> [<a href="mailto:talk-bounces@x-query.com" class="">mailto:talk-bounces@x-query.com</a>] On Behalf Of daniela florescu<br class="">Sent: Saturday, October 31, 2015 2:05 PM<br class="">To: talk <<a href="mailto:talk@x-query.com" class="">talk@x-query.com</a>><br class="">Subject: [xquery-talk] specification for Microsoft's U-SQL ?<br class=""><br class="">Seems interesting in principle.<br class=""><a href="https://na01.safelinks.protection.outlook.com/?url=http%3a%2f%2fthenewstack.io%2fmeet-u-sql-microsofts-new-language-big-data%2f&data=01%7c01%7cmrys%40microsoft.com%7caef4ceeec92543784b5608d2e23771f1%7c72f988bf86f141af91ab2d7cd011db47%7c1&sdata=iZjmF47tPZ316GAyjeXegMSLOq%2bLFAbo3zvRYOwMPy0%3d" class="">https://na01.safelinks.protection.outlook.com/?url=http%3a%2f%2fthenewstack.io%2fmeet-u-sql-microsofts-new-language-big-data%2f&data=01%7c01%7cmrys%40microsoft.com%7caef4ceeec92543784b5608d2e23771f1%7c72f988bf86f141af91ab2d7cd011db47%7c1&sdata=iZjmF47tPZ316GAyjeXegMSLOq%2bLFAbo3zvRYOwMPy0%3d</a><br class=""><br class="">But anyone in a luck to see a specification for it ?<br class=""><br class="">Thanks for any pointer, best regards<br class="">Dana<br class="">_______________________________________________<br class=""><a href="mailto:talk@x-query.com" class="">talk@x-query.com</a><br class="">https://na01.safelinks.protection.outlook.com/?url=http%3a%2f%2fx-query.com%2fmailman%2flistinfo%2ftalk&data=01%7c01%7cmrys%40microsoft.com%7caef4ceeec92543784b5608d2e23771f1%7c72f988bf86f141af91ab2d7cd011db47%7c1&sdata=dJTn2RgYiSUgZH5GU3e3CsLqpCj9Gvd6uI%2fGS7JomP8%3d<br class=""></div></blockquote></div><br class=""></div></div>_______________________________________________<br class=""><a href="mailto:talk@x-query.com" class="">talk@x-query.com</a><br class="">http://x-query.com/mailman/listinfo/talk</div></blockquote></div><br class=""></div></body></html>