usql

usql copied to clipboard

script hangs when mistakingly using Extractors.CSV instead of Extractors.TSV

3

USQL script on ADLA were hanging indefinitely, until we realized that we had setup the wrong extractor (CSV instead of TSV) on a `.tsv` file. Sure it is our fault,...

renaud

How to describe/Show table in U-SQL?

5

I have a requirement to pull the table schema information using U-SQL. Like the columns in table and datatype. How can I achieve this?

HermeetB

Dynamically passing Table name as parameter in Stored Procedure in U-SQL

1

I want to pass the Table name as in-parameter in a stored procedure in U-SQL and then want to have a SELECT * FROM the table. Something like below ::...

HermeetB

AvroExample not working(always errors)

1

Hi, I tried to run the AvroExample many times and always I get the following error: Vertex SV1_Extract[0] failed 6 times. I have followed the all instructions and I am...

almusawi

Cannot extract json containing an array as start element

2

JsonExtractor cannot handle if json contains an array as top most object. Following does not work input json: [{'groupId':'g1'},{'groupId':'g2'}] extractor with path: new Microsoft.Analytics.Samples.Formats.Json.JsonExtractor("$[*]")

kurtng

Avro Extractor Not Working

1

After doing all the steps described in your repository for reading the Avro file from Data Lake Store using U-SQL. Below is the script I am using which is replication...

SushantVarshney

Guys I'm having a hard time trying to figure out how to do the next subquery ```sql declare @ventas as table( semana int, existencia int ); declare @semanas as table(...

ivpadim

How to extract nested properties using JSONTuple Function.

2

Below is the sample extract json, { "AReference": "XXXXXXXXXXXX", "Id": 111111111, "items": [ { "vId": 22222222, "rReason": { "AB": 1, "XY": "ABC XYZ" } } ], "time": "2017-12-28T13:51:18.6679191Z" }

GauravSagne

Create DB?

1

Hi All, checking out this file: https://github.com/Azure/usql/blob/master/Examples/AvroExamples/AvroExamples/1-CreateDB.usql It seems to create a database, but then checking out these files: https://github.com/Azure/usql/blob/master/Examples/AvroExamples/AvroExamples/2-RegisterAssemblies.usql https://github.com/Azure/usql/blob/master/Examples/AvroExamples/AvroExamples/3-SimpleAvro.usql It doesn't seem to be used. Or is it...

Mike-E-angelo

JSONPath conditionnal selection issue while using JSON Extractor

1

I have the following JSON file `{ "Person": { "PersonType": "BC", "PersonIdentification": { "IdentificationIdType": "INFOWARE_ID", "IdentificationId": "1009" }, "MatriculeRH": { "MatriculeIdType": null, "MatriculeId": null }, "Affectation": { "POSIdentification": { "POSIdType":...

saadsodki