No announcements
-
2 VotesProcessing a stream of historical data
Hi there, I'm having an issue getting my head around the processing of historical data streams. I have a case where I need to load some events on to an event hub which were ...Unanswered | 5 Replies | 88 Views | Created by Will Humphreys - Thursday, August 9, 2018 2:58 PM | Last reply by Will Humphreys - 10 hours 18 minutes ago
-
0 Votes
Process Events: Node shutdown due to high memory utilization
Stream analytics job taking two small <g class="gr_ gr_38 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="38" ...Unanswered | 6 Replies | 77 Views | Created by ecline2 - Friday, August 10, 2018 5:08 PM | Last reply by ecline2 - Tuesday, August 14, 2018 11:21 PM -
0 Votes
Different types of BLOB as Input
Hello All, My requirement is to connect to a BLOB storage, parse and ingest to SQL. Problem that i am facing is, in the BLOB storage, there could be multiple JSON types. How to ...Proposed | 1 Replies | 36 Views | Created by GuruSKNew - Tuesday, August 14, 2018 8:03 PM | Last reply by Siddarth Ramadoss - Tuesday, August 14, 2018 10:16 PM -
0 Votes
No Input Events - Stream Analytics job
Hi I have a Stream Analytics job that connects to my IoT Hub. I am able submit data to the hub from a rapsberry Pi running Node-RED. The messages apear to be arrving ...Unanswered | 2 Replies | 559 Views | Created by Maxmw99 - Tuesday, May 9, 2017 3:55 PM | Last reply by Akshay S. Deshmukh - Friday, August 10, 2018 8:27 PM -
0 Votes
Query with cast from string to float into sql table failing
I have a stream analytics query that works fine when tested in the console, but fails when I run the stream analytics job. It takes a JSON array input with a value formatted as string. The ...Proposed | 2 Replies | 80 Views | Created by ecline2 - Thursday, July 26, 2018 8:53 PM | Last reply by ecline2 - Friday, August 10, 2018 5:17 PM -
0 Votes
How can i check if the value is the same for 21 days for a particular column and if this is true then set a flag ?
a value (0.5) for 21 days , how can i achieve that. Something which i could think about a a s logic is : - get a window of 21 ...Proposed | 1 Replies | 36 Views | Created by sarath_sasidharan - Thursday, August 9, 2018 11:16 AM | Last reply by VairavanS (Azure) - Thursday, August 9, 2018 5:58 PM -
0 Votes
Programmatically creating a Stream Analytics Output to Data Lake
I am writing a powershell script that will automatically create and authorize a stream analytics output to data lake. I followed the JSON template from this ...Proposed | 6 Replies | 102 Views | Created by Harsh Ja - Thursday, August 2, 2018 3:10 PM | Last reply by VairavanS (Azure) - Wednesday, August 8, 2018 5:46 PM -
0 Votes
Help in Flatten output
I am new to SA and tryinig to build an Iot Application, but because of format of my telemetry i am not able to flatten the query output [{ ...Proposed | 2 Replies | 75 Views | Created by arvindsinghagra - Sunday, August 5, 2018 4:55 PM | Last reply by JS Azure - Wednesday, August 8, 2018 5:22 PM -
0 Votes
Stream Analytics JSON root has hyphen - can't parse
am doing a POC on ingesting a JSON though EventHub, processing it through Stream job and pushing it into a Azure SQL DW. I have worked with JSON ingestion ...Answered | 3 Replies | 53 Views | Created by Sumit.Bhatnagar - Tuesday, July 31, 2018 3:50 AM | Last reply by Sumit.Bhatnagar - Tuesday, July 31, 2018 5:59 AM -
0 Votes
Consecutively count how many times a certain condition has been met in stream analytics
I have a real time stream coming through in stream analytics at a 5 minute interval. For ...Unanswered | 1 Replies | 70 Views | Created by NghiaNguyen86 - Friday, July 27, 2018 5:24 AM | Last reply by VairavanS (Azure) - Friday, July 27, 2018 6:53 PM -
0 Votes
I literally need the latst value
Hi My stream data is pretty standard: [DateTime],[DeviceNo],[Value],[Longitude],[Latitude] 2018-07-25 ...Proposed | 2 Replies | 70 Views | Created by Etienne Oosthuysen - Wednesday, July 25, 2018 10:56 AM | Last reply by Siddarth Ramadoss - Thursday, July 26, 2018 5:07 PM -
0 Votes
Handle AES keys and decryption (Use Azure Key Vault Secrets in Stream Analytics?)
Event Hub -> Stream Analytics -> SQL Database -> Power BI. To achieve this, I have a UDF which decrypts the messages. At the moment, the UDF ...Answered | 2 Replies | 60 Views | Created by mjose - Wednesday, July 25, 2018 2:23 PM | Last reply by Siddarth Ramadoss - Thursday, July 26, 2018 5:02 PM -
0 Votes
Any way to easily convert a hex value to a bigint?
Hey everyone, Does anyone know an easy way in a streaming job to convert a hex value to an int value? I've tried to cast but obviously that doesn't ...Proposed | 1 Replies | 85 Views | Created by CRWW - Wednesday, July 18, 2018 6:52 AM | Last reply by VairavanS (Azure) - Wednesday, July 25, 2018 11:04 PM -
0 Votes
Downsampling
Hi I trying to create a downsampling ASA job, but I have a hard time getting it to work. Every 10 minute a package of 600 data points (1 pr. sec) are being stored in blobstore, I ...Unanswered | 1 Replies | 107 Views | Created by smolesen - Thursday, July 12, 2018 5:26 AM | Last reply by VairavanS (Azure) - Monday, July 23, 2018 11:29 PM -
1 Votes
Streaming Analytics job not receiving inputs from IOT hub
I followed the "IOT Getting Started Tutorial - Visual C#" and got it working. I then created a Stream Analytics job and used the above as an Input (which upon test connection ...Unanswered | 3 Replies | 965 Views | Created by BeesMS - Wednesday, January 25, 2017 12:53 PM | Last reply by Rena B - Monday, July 9, 2018 12:15 PM -
0 Votes
Errors occured while processing records from the following input(s):
Hi, I am new to using Azure Stream Analytics. I am pushing a sample event to Event Hub and then to Power BI using Azure Stream Analytics. I can see the events ...Unanswered | 3 Replies | 151 Views | Created by Mukeshgupta01 - Thursday, July 5, 2018 7:21 AM | Last reply by Mukeshg01 - Thursday, July 5, 2018 11:29 PM -
0 Votes
IN Clause?
Does this not exists in Azure Stream Analytics? If not, what recommendations would you have to provide a query to check if a value within a list...other than chaining AND/OR conditions?Proposed | 4 Replies | 181 Views | Created by JRiggenbach - Wednesday, June 27, 2018 10:22 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, July 3, 2018 5:06 AM -
0 Votes
Issue with Visual studio and ASA
hi i have installed ASA Tools for VS https://www.microsoft.com/en-us/download/details.aspx?id=54630 and when creating an input file with ...Proposed | 7 Replies | 218 Views | Created by Nik - Shahriar Nikkhah - Saturday, June 9, 2018 8:19 PM | Last reply by Nik - Shahriar Nikkhah - Wednesday, June 27, 2018 2:28 AM -
0 Votes
Dynamic Windowing from the same stream
I wanted to know if there is possibility of having dynamic / configurable (from reference data) window from the stream ...Proposed | 1 Replies | 168 Views | Created by ArvindSinghDev - Tuesday, June 19, 2018 1:31 PM | Last reply by Hyder SM - Tuesday, June 26, 2018 10:05 PM -
0 Votes
Blob storage file rollover based on Path Pattern containing Date and TIme
I have a Blob Storage output that uses a Path pattern "{date}T{time}:00:00Z/foldername". With {time} in the path I would expect Stream Analytics to rollover to a new file in the ...Proposed | 1 Replies | 125 Views | Created by Nik_SJ - Tuesday, June 26, 2018 5:31 PM | Last reply by JasonHowell - Tuesday, June 26, 2018 9:02 PM - Items 1 to 20 of 824 Next ›
No announcements
