Azure stream analytics - Joining on a csv file returns 0 rows -

i have following query:

select [vanlist].deviceid ,[vanlist].[vanname] events.[timestamp] ,events.externaltemp ,events.internaltemp ,events.humidity ,events.latitude     ,events.longitude      [iot-powerbi]     [iot-eventhub] events timestamp [timestamp]     join [vanlist] on events.deviceid = [vanlist].deviceid 

where iot-eventhub event hub , vanlist reference list (csv file) has been uploaded azure storage.

i have tried uploading sample data test query, returns 0 rows.

below sample of json captured event hub input

    [    {       "deviceid":1,       "timestamp":"2015-06-29t12:15:18.0000000",       "externaltemp":9,       "internaltemp":8,       "humidity":43,       "latitude":51.3854942,       "longitude":-1.12774682,       "eventprocessedutctime":"2015-06-29t12:25:46.0932317z",       "partitionid":1,       "eventenqueuedutctime":"2015-06-29t12:15:18.5990000z"    } ] 

below sample of csv reference data.

deviceid,vanname 1,van 1 2,van 2 3,standby van 

both lists contain device id of 1, expecting query able join 2 together.

i have tried using both "inner join" , "join" in query syntax, neither result in successful join. wrong stream analytics query?

try adding cast function in join. i'm not sure why works , adding create table clause vanlist reference data input doesn't accomplish same thing. think works.

select [vanlist].deviceid ,[vanlist].[vanname] ,events.[timestamp] ,events.externaltemp ,events.internaltemp ,events.humidity ,events.latitude     ,events.longitude      [iot-powerbi]     [iot-eventhub] events timestamp [timestamp]     join [vanlist] on events.deviceid = cast([vanlist].deviceid bigint)