No announcements
-
0 VotesHow 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 | 309 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.Unanswered | 1 Replies | 140 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 | 298 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 | 260 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 | 360 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 | 272 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 | 231 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 | 227 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 | 253 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
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 ...Unanswered | 2 Replies | 443 Views | Created by Deepak-G - Thursday, October 24, 2019 3:54 PM | Last reply by MartinJaffer-MSFT - Thursday, November 7, 2019 7:20 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 | 339 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 | 332 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 | 4796 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 | 376 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 | 423 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 | 334 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 | 661 Views | Created by NOA-Louis - Monday, September 23, 2019 6:20 AM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, October 7, 2019 5:19 AM -
0 Votes
Metric Alerts not getting triggered until the previous alert is deactivated/resolved
Hi, We had set up a metric alert for Stream Analytics Jobs with the criterion that if there are no input messages for last 15 minutes, it should trigger an ...Answered | 4 Replies | 427 Views | Created by AnanyoBAzDOps - Monday, September 16, 2019 9:15 AM | Last reply by AnanyoBAzDOps - Thursday, September 26, 2019 12:21 PM -
0 Votes
How to access device twin JSON in stream job ?
Is it possible to access device twin data in stream jobs ? Is there a way I can access device (tags, desired properties, reported properties) in stream job ...Proposed | 7 Replies | 933 Views | Created by Paulo Ilhéu - Monday, March 18, 2019 6:23 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, September 23, 2019 3:51 AM -
0 Votes
insights asked about massive record handling
Hi, I am working on a project where we are trying to retrieve the state of about 400 variables by an event handler. I check the state every second and send only the changed stated ...Proposed | 3 Replies | 483 Views | Created by LeorN - Thursday, September 5, 2019 3:55 PM | Last reply by HimanshuSinha-msft - Thursday, September 19, 2019 7:42 PM - Items 1 to 20 of 956 Next ›
No announcements
