No announcements
-
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 | 5 Replies | 215 Views | Created by Kenny_I - Thursday, November 14, 2019 8:18 AM | Last reply by ChiragMishra-MSFT - Friday, November 29, 2019 6:00 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 | 234 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 | 199 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 | 286 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 | 201 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 | 172 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 | 169 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 | 193 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 | 377 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 | 262 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 | 266 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 | 4707 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 | 311 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 | 349 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 | 270 Views | Created by Hector1978 - Monday, October 14, 2019 9:05 AM | Last reply by Pete Laker - Monday, October 14, 2019 9:46 AM -
0 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 | 575 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 | 367 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 | 875 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 | 423 Views | Created by LeorN - Thursday, September 5, 2019 3:55 PM | Last reply by HimanshuSinha-msft - Thursday, September 19, 2019 7:42 PM -
0 Votes
Enable a dynamic conversion from UTC to the local time
Hi, We are hoping that you might be able to help us with our problem, We are working with streaming data generated by a sensor. We used IoT Hub as the ...Answered | 5 Replies | 581 Views | Created by imenmaiza - Monday, September 16, 2019 1:32 PM | Last reply by imenmaiza - Wednesday, September 18, 2019 8:53 AM - Items 1 to 20 of 955 Next ›
No announcements