I'm beginner in Azure, I have created a Stream Analytics Job in Windows Azure. Here I'm using two Inputs in job, one is type of Event Hub and another is type of Blob Storage.
Below is the SQL Query for ASA Job (To store output in SQL Database) :
SELECT
IP.DeviceId
, IP.CaptureTime
, IP.Value
, [TEST-SAJ-DEMO-BLOB-Input].[DataType] AS TempVal -- Blob Storage Input
INTO
[Test-Output-Demo] -- SQL Table to store output
FROM
[TEST-SAJ-DEMO-Input] IP -- Event Hub Input
Below is JSON data in my Blob storage container (Blob Storage Input [TEST-SAJ-DEMO-BLOB-Input])
{"DataType":"DEMO"}
Everything is working fine except [TEST-SAJ-DEMO-BLOB-Input].[DataType] returns null instead of string 'DEMO'.
All data sent by Event Hub Input is storing into sql table and their is no error in process.
Any help is appreciated ...