0

Do I have to learn U-SQL to query data in ADLS? Or is there a way to query to using SQL.

megha aswath
  • 31
  • 5

1 Answers1

1

Yes,you have to learn U-SQL to work with Azure Data Lake Store or Azure Data Lake Analytics.

U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments. Introduced in this document, U-SQL is part of Microsoft's Azure Data Lake Analytics cloud service, but it lets users run queries against multiple data stores in the Azure cloud.

If you familiar with sql, u-sql will be easy for you to start with.Please follow this get-started document to refer to some basic samples.

Jay Gong
  • 23,163
  • 2
  • 27
  • 32
  • I get the impression that Data Lake Analytics is a dead product (last update is ages ago and it doesn't support Lake Gen2), and I'm guessing U-SQL is going that way as well. – Martin Wickman Apr 01 '21 at 09:08