问题描述
我们可以在Azure Data Lake Analytics中使用R/Python代码扩展U-SQL脚本，但是如何在本地进行呢?
We can extend U-SQL scripts with R/Python code in Azure Data Lake Analytics, but how can we do it locally?
推荐答案
-
在您的Data Lake Analytics帐户中安装U-SQL Advanced Analytics扩展
1.1启动您的Azure门户
1.2导航到您的Data Lake Analytics帐户
1.3单击示例脚本
1.4单击更多"，然后选择安装U-SQL扩展"
1.5等到扩展程序完成安装(2GB)
1.6你等了吗?然后转到您的Data Lake Analytics帐户
1.7导航到默认的Data Lake Store帐户
1.8单击Data Explorer并确认/usqlext文件夹存在
Install U-SQL Advanced Analytics extensions in your Data Lake Analytics Account
1.1 Launch your Azure Portal
1.2 Navigate to your Data Lake Analytics Account
1.3 Click Sample Scripts
1.4 Click More and select Install U-SQL Extensions
1.5 Wait until the extensions have finished installing (2GB)
1.6 Have you waited? Then go to your Data Lake Analytics Account
1.7 Navigate to your default Data Lake Store Account
1.8 Click on Data Explorer and verify that a folder /usqlext exists
获取您的USQL本地运行路径
2.1启动Visual Studio
2.2选择工具>选项> Azure Data Lake>常规
2.3在"U-SQL本地运行"下，找到并复制DataRoot的值
2.4该值将如下所示:C:\ Users \ username \ AppData \ Local \ USQLDataRoot
Get your USQL Local Run path
2.1 Launch your Visual Studio
2.2 Select Tools > Options > Azure Data Lake > General
2.3 Under U-SQL Local Run, find and copy the value for DataRoot
2.4 The value will look like this: C:\Users\username\AppData\Local\USQLDataRoot
将U-SQL Advanced Analytics扩展从Azure复制到您的本地主机
3.1使用Powershell脚本或...转到下一行
3.2启动Microsoft Azure存储资源管理器(很好的工具，安装它)
3.3找到默认的Data Lake Store，这是您的Data Lake Analytics帐户之一
3.4打开数据浏览器，并将文件夹/usqlext下载到USQL Local Run的路径
3.5完整路径应如下所示:C:\ Users \ username \ AppData \ Local \ USQLDataRoot \ usqlext
Copy U-SQL Advanced Analytics extensions from Azure to your localhost
3.1 Use a powershell script or ... go to the next line
3.2 Launch Microsoft Azure Storage Explorer (great tool, install it)
3.3 Locate your default Data Lake Store, the one of your Data Lake Analytics Account
3.4 Open data explorer and Download the folder /usqlext to your USQL Local Run's path
3.5 The full path should look like this: C:\Users\username\AppData\Local\USQLDataRoot\usqlext
最后一步，在U-SQL本地运行下注册所有Azure U-SQL扩展
4.1启动Visual Studio
4.2开始一个新的U-SQL项目
4.3打开文件C:\ Users \ username \ AppData \ Local \ USQLDataRoot \ usqlext \ RegisterAll.usql
4.4将文本复制到您自己的U-SQL脚本中
4.5在本地执行模式下运行
4.6脚本完成后...
Final step, register all Azure U-SQL Extensions under U-SQL Local Run
4.1 Launch your Visual Studio
4.2 Start a new U-SQL project
4.3 Open the file C:\Users\username\AppData\Local\USQLDataRoot\usqlext\RegisterAll.usql
4.4 Copy the text into your own U-SQL script
4.5 Run it in Local Execution mode
4.6 Once the script finishes...
您将能够在自己的计算机上使用所有U-SQL Advanced Analytics功能(Python，R，Cognitive)，并浏览\ usqlext \ samples中的所有示例！
You will be able to use all the U-SQL Advanced Analytics features (Python, R, Cognitive) on your own machine and explore all the samples in \usqlext\samples!
度过美好的一天！
这篇关于安装Azure U-SQL扩展以在本地运行R/Python脚本吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！