INTO (Azure Stream Analytics)

 

Updated: May 3, 2016

Applies To: Azure

INTO explicitly specifies an output stream, and is always associated with an SELECT expression. If not specified, the default output stream is “output”.

Syntax

Copy 
[ INTO <output_stream> ]

ouput_stream

Specifies the name of an output stream.

You cannot use SELECT … INTO in a WITH clause. For example, INTO clause can only be used in the out-most subquery.

Copy 
WITH WAVehicle AS (  
    SELECT TollId, EntryTime AS VehicleEntryTime, LicensePlate, State, Make, Model, VehicleType,    VehicleWeight, Toll, Tag  
    FROM TollTagEntry TIMESTAMP BY EntryTime  
    WHERE State = “WA”  
)  
  
SELECT * INTO WAVehicleArchive FROM WAVehicle;  
  
SELECT DateAdd(minute,-3,System.TimeStamp) AS WinStartTime, System.TimeStamp AS WinEndTime, COUNT(*) INTO WAVehicleCount FROM WAVehicle GROUP BY TumblingWindow(minute, 3)
Show: