CODEWITHSUNDEEP
azureazure-data-lakeu-sql
gxclarke
gxclarke

Reputation: 1973

U-SQL (Azure Data Lake language) script error

Using sample script from a Data Lake Analytics tutorial, the following error occurs when building the script:

E_CSC_USER_SYNTAXERROR: syntax error. Expected one of: RETURN '[' ALTER COMBINE CREATE DECLARE DEPLOY DROP END EXTRACT IF INSERT OUTPUT PROCESS REDUCE REFERENCE RESOURCE SELECT SET TABLE TRUNCATE UPDATE USE USING VIEW identifier quoted-identifier variable ';' '('

The error line is the last line of the script. The script in the tutorial does end with an OUTPUT statement, which the syntax error is saying is expected.

Any thoughts?

Upvotes: 1

Views: 1974

Answers (2)

saveenr
saveenr

Reputation: 8629

Looks like we may have an error in the example. We are investigating. Will update as soon as we learn more.

Upvotes: 4

Michael Rys
Michael Rys

Reputation: 6684

(Azure DL Team here as well): We identified the issues and are going to fix it. In the mean time:

  1. Please split the script that does the create and load and then query into two scripts: one that does the create and load, and one that does the query.

  2. The end of the definition of the TVF (before DROP TABLE IF EXISTS ) needs an END;

I hope this helps. Michael

Upvotes: 4

Related Questions