CODEWITHSUNDEEP
azureselectazure-data-lakeu-sql
peterko
peterko

Reputation: 533

Select from EXTERNAL via LOCATION statement

I would like to write query

@result =
  SELECT * //Id, Test
  FROM EXTERNAL MyAzureSQLDBDataSource LOCATION "dbo.test"
  WHERE Test NOT LIKE "_C";

But I got an error:

C# error CS0103: The name 'Test' does not exist in the current context.

If I'm running query without WHERE statements, everything works well. The same problem is in SELECT, I get an error if I use column names in query instead of *

Any idea why I cannot use location and where statement?

Upvotes: 0

Views: 79

Answers (1)

Michael Rys
Michael Rys

Reputation: 6684

What is the schema definition of the dbo.test table?

I assume that the dbo.test table in the Azure SQLDB either does not provide the column Test or it is spelled in a different case (note that U-SQL is - unlike T-SQL - case-sensitive).

Upvotes: 2

Related Questions