How can I Retrieve the data from azure data lake using c# ? RRS feed

  • Question

  • I have upload the csv,txt,json,excel file in Azure Data Lake. In that again i need see what file they have. So I am using c# i can see the what file having. Like SQL Query "Select * from Employee" , this Query Retrieve the Employee Records same as ADL how can i retrieve the data. Please guide me to retrieve the data like as SQL.
    Thursday, October 5, 2017 2:17 PM

All replies

  • Hi,

    Currently Azure Data Lake does not provide interactive query over data the Data Lake, however you have some alternatives here. If you would simply like to see the content of a file similar to the SELECT * example above, then Visual Studio Data Lake Store Explorer enables you to open any file of any size to view the contents.

    For more complex queries, you could consider either HDInsight or Azure SQL DW as mechanisms for querying data stored in Data Lake Store. HDInsight HIVE and SQL DW both have a concept of External Table to support this requirements.

    Friday, October 20, 2017 2:21 PM