Use string text from file in u-sql query where clause ( U-SQL )

Question

I need load some text from one file and choose specific records from another where one of second file columns is equalt to text loaded from first file.

I'm trying with something like that but actually it doesn't work.

@countryName =
    EXTRACT City string
    FROM "/TestCatalog/test.txt"
    USING Extractors.Text();

@result =
    SELECT CityName,
           Temperature,
           MeasurmentDate
    FROM @readEmployee
    WHERE CityName IN(@countryName);

What is the best way to pass some parameters to where expression ( readed from another file in azure data lake ) ?

wBob · Accepted Answer · 2016-12-16 16:08:21Z

2

Variables in U-SQL which are assigned to with EXTRACT or SEELCT are rowsets, rather than scalar variables. Therefore use SEMIJOIN to do this, for example:

@output =
    SELECT re.CityName,
           re.Temperature,
           re.MeasurmentDate
    FROM @readEmployee AS re
            SEMIJOIN @countryName AS c ON re.CityName == c.City;

answered Dec 16, 2016 at 16:08

wBob

14.4k3 gold badges26 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

dawcza94 Over a year ago

It's works perfect, but maybe you know what can I do if i want select for example Temperature that is bigger than first value from loaded row and lower than second value loaded row.

wBob Over a year ago

Can you provide some sample data and expected results? Probably as a separate question ...

dawcza94 Over a year ago

In my txt file i want put two variables ( maybe date or some int/double ). Then i want use this value to specific range of intresting parameter like temperature or measurmentdate.

dawcza94 Over a year ago

I want create something similiar to this: Select CityName,Temperature,MeasurmentDate where Temperature > par1 nad Temeprature <par2

wBob Over a year ago

Sorry, it's really not clear to me from those comments what you want. Please post a separate question with sample data and expected results. I am sure someone will be able to help you.

Alexandre Gattiker · Accepted Answer · 2016-12-16 15:56:33Z

0

EXTRACT this other file into another rowset, and JOIN both rowsets together.

answered Dec 16, 2016 at 15:56

Alexandre Gattiker

7493 silver badges5 bronze badges

Collectives™ on Stack Overflow

Use string text from file in u-sql query where clause ( U-SQL )

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related