U-SQL is a query language designed for Azure Data Lake. It provides a way to mingle SQL keywords with syntactic C# expressions, so that within a single script, a programmer can schematize the data from an unstructured source, use SQL to aggregate the data into the desired form, and then write the output to a file or table.
Questions tagged [u-sql]
771 questions
-2
votes
1 answer
u-sql UDF debug in Local
I want to debug UDF code in local mode that is I am executing the u-sql script on local and not on azure portal.
Please let me know how to debug the UDF in local mode.
Rahul Wagh
- 281
- 6
- 20
-2
votes
1 answer
Azure Data lake analytics CI/CD - Build error
I'm trying to build CI/CD for Azure Data lake analytics - USQL code and when i build the code using Visual studio build option in VSTS getting the below error - Using the Private agent for taking the build…
Arunachalam
- 47
- 7
-2
votes
2 answers
u-sql script can not obtain scalar value from dataset
In u-sql script I must extract a variable from file to a dataset and then use it to form a name of output file. How can I get the variable from the dataset?
In details.
I have 2 input files: csv file with a set of fields and a dictionary file. The…
Oksana Mikolenko
- 1
- 1
-2
votes
2 answers
Custom JSON outputter using only one vertex for execution
We need to distribute the data using JSON and thus we wrote a custom outputter. We are also outputting same data as csv for another vendor.
On investigation I found that JSON outputter is using one vertices whereas csv is using 5 vertices to output…
Arnay
- 61
- 4
-2
votes
1 answer
Not able to create a new USQL Project in Visual Studio
I am trying to create a U-SQL Project from Visual Studio. I am not able to create one. Here is the link for error message I receive.
Note: I have already installed the .NET SDK
-4
votes
2 answers
How to use ORDER BY and GROUP BY together in u-sql
I am having a u-sql query which fetch some from 3 tables and this query already had the GROUP BY. I want to fetch only top 10 rows, so i have to use the FETCH.
@data= SELECT C.id,C.Name,C.Address,ph.phoneLabel,ph.phone
FROM person AS C
INNER…
Arron
- 1,134
- 2
- 13
- 32