No announcements
-
0 Votessimple left join with two inputs return all rows...
I'm trying to create a simple left join between two inputs (event hubs), the source of inputs is an app function that process a rabbitmq queue and send to a event ...
-
0 Votes
Error : Timestamp property is not allowed on steps
Hi! I'm trying to develop a Stream Analytics Job in Visual Studio Code. When I try to test a query including two TIMESTAMP BY statements, the test fails with an error ...Proposed | 2 Replies | 123 Views | Created by awo-SYS - Thursday, December 19, 2019 3:46 PM | Last reply by awo-SYS - Friday, December 20, 2019 3:08 PM -
0 Votes
Reference Data Blob not finding data
I have set up a Reference Data blob but when I try to access it in the query I get the following error: "No data was found for preview from 'IoT-EasyNames'. Make sure the input ...Proposed | 1 Replies | 144 Views | Created by Marc Kinsman - Tuesday, December 17, 2019 7:44 AM | Last reply by HimanshuSinha-msft - Wednesday, December 18, 2019 9:40 PM -
0 Votes
C# UDF ,Http Post Call
I am using the C# UDF to perform custom logic and to perform this logic I am using the http Client Post Method and it returns the data,this httpresponse message is again returned to stream ...Proposed | 3 Replies | 542 Views | Created by Deepak-G - Thursday, October 24, 2019 3:54 PM | Last reply by Siddarth Ramadoss - Tuesday, December 17, 2019 12:20 AM -
0 Votes
How convert Epoch to Date with JavaScript UDF
I have IoT Hub sending sending timestamp in epoch format and column is named as "epoch". Please advice me how to make query and what is structure of JavaScript. I need to extract ...Proposed | 7 Replies | 379 Views | Created by Kenny_I - Thursday, November 14, 2019 8:18 AM | Last reply by ChiragMishra-MSFT - Friday, December 13, 2019 9:13 AM -
0 Votes
Could you give me more Infos about Stream Analytics and Event Grid?
SA->Event hub -> Azure Function) Both solutions work but I don't get why should I pick one instead of the other.Proposed | 1 Replies | 209 Views | Created by DoodlePain - Monday, December 9, 2019 3:53 PM | Last reply by krishmam - Tuesday, December 10, 2019 3:09 AM -
1 Votes
Why epoch timestamp could not be converted?
I have IoT Hub sending sending timestamp in epoch format and column is named as "epoch". Following query gives error, but do not send any data to data lake output. What could be ...Answered | 5 Replies | 353 Views | Created by Kenny_I - Tuesday, November 12, 2019 8:01 AM | Last reply by ChiragMishra-MSFT - Thursday, November 21, 2019 10:24 AM -
0 Votes
Join IoT Hub messages with static sql table
Hello, I am trying to insert the data from IoT Hub messages into a Azure SQL Database. The problem is that I have 2 tables setup: plcnext_nodes - ...Answered | 2 Replies | 307 Views | Created by Lexons - Monday, November 11, 2019 1:12 PM | Last reply by Lexons - Thursday, November 21, 2019 8:21 AM -
0 Votes
Azure Stream Analytic with reference data
Hey! I am new to azure. I am trying to join streaming data with a reference data. The reference data is static. This is the reference data I am ...Unanswered | 4 Replies | 421 Views | Created by Lokie_e - Wednesday, October 23, 2019 4:31 AM | Last reply by HimanshuSinha-msft - Monday, November 18, 2019 8:02 PM -
0 Votes
Cannot create an Event Hub as an output to a Stream Analytics Job
I created an IoT Hub with a device. I'm wanting to use Azure Stream Analytics to filter IoT Hub data and send it to Event Hub. It appears I can use the IoT Hub as an input to the Stream ...Unanswered | 2 Replies | 324 Views | Created by CardinalFlyer - Saturday, November 9, 2019 3:00 AM | Last reply by CHEEKATLAPRADEEP-MSFT - Tuesday, November 12, 2019 6:29 AM -
1 Votes
Converting epoch time to datetime and date
I have query like "SELECT EpochTimestamp, temperature FROM IoTHubInput" I would like to convert EpochTimestamp to A) "2019-10-31" and B) ...Answered | 1 Replies | 294 Views | Created by Kenny_I - Monday, November 11, 2019 7:37 AM | Last reply by ChiragMishra-MSFT - Monday, November 11, 2019 11:17 AM -
1 Votes
How to concatinate date and deviceId?
I have query like "SELECT Date, DeviceId FROM IoTHubInput". How to concatinate Date and DeviceId like ...Answered | 1 Replies | 283 Views | Created by Kenny_I - Monday, November 11, 2019 8:02 AM | Last reply by ChiragMishra-MSFT - Monday, November 11, 2019 11:09 AM -
0 Votes
SA suddenly stops processing with high utilization
Yesterday I got an alert message that our SA utilization went above 75%, normally it is around 30% max. I checked the metrics and output tables and it looked like our SA just stopped processing input ...Proposed | 2 Replies | 307 Views | Created by JorisAtBinkies - Tuesday, November 5, 2019 7:58 AM | Last reply by HimanshuSinha-msft - Thursday, November 7, 2019 9:07 PM -
0 Votes
Stream Analytics "Timestamp By ApplicationTime Over" is "over" partitioning
I recently changed a Stream Analytics job by adding a "Over" statement to a "Timestamp By" application time statement. A bit of background - our data contain a ...Proposed | 4 Replies | 394 Views | Created by Johan Berghmans (CGI) - Friday, October 25, 2019 11:34 AM | Last reply by Johan Berghmans (CGI) - Tuesday, November 5, 2019 7:09 AM -
0 Votes
Could not install npm tedious in function console
I am following the tutorial in "https://docs.microsoft.com/en-gb/learn/modules/build-ml-model-with-azure-stream-analytics/11-connect-db-and-function" but I was not able to install the ...Proposed | 3 Replies | 391 Views | Created by Vic2358 - Sunday, October 27, 2019 4:50 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, November 4, 2019 6:27 AM -
1 Votes
No events found - stream analytics
Hi, I've encountered the problem where I can see that they're messages on my Azure event hub, and when I try and stream them to blob storage using stream analytics - nothing ...Answered | 9 Replies | 4874 Views | Created by DamienRan - Monday, March 27, 2017 3:14 PM | Last reply by KranthiPakala-MSFT - Thursday, October 31, 2019 12:13 AM -
0 Votes
How to create a date time in your sensors sql query?
Hi Team I have this code in my azure sql query; SELECT illuminance as illuminance, temperature as ...Proposed | 3 Replies | 431 Views | Created by TaGcobs2010 - Thursday, October 17, 2019 5:26 AM | Last reply by HimanshuSinha-msft - Monday, October 21, 2019 4:55 PM -
0 Votes
How should it be with several alerts?
Hi. I have several alerts on muy stream anlytics job. should i have a job for each alert or all alerts on one stream analytics job? thank you ...Proposed | 7 Replies | 483 Views | Created by Hector1978 - Monday, October 14, 2019 9:18 AM | Last reply by Ismael Sánchez Chaves - Friday, October 18, 2019 10:20 AM -
0 Votes
Can I get to outputs on my Stream Analytics
Hi! How are you? Can I need two outputs on my stream analytics process. One output to powreBI that it is working ...Answered | 1 Replies | 388 Views | Created by Hector1978 - Monday, October 14, 2019 9:05 AM | Last reply by Pete Laker - Monday, October 14, 2019 9:46 AM -
1 Votes
Error OutputDataConversionError.RequiredColumnMissing with Cosmos DB output
Hello, Since a while, when I restart my Azure Stream Analytics job, I get the following error: [10:50:27 AM] Source 'devicedata' had 1 occurrences of kind ...Answered | 11 Replies | 745 Views | Created by NOA-Louis - Monday, September 23, 2019 6:20 AM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, October 7, 2019 5:19 AM - Items 1 to 20 of 959 Next ›
No announcements
