Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
343 questions
Azure Stream Analytics - SQL - Showing 0 rows joining with reference input with SQL Server Reference input
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 46%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Akila Ariyarathne
1
Reputation point
Even reference data available in joining SQL Server reference input tables, no result and no errors
FROM table, Event hub input
JOIN tables, SQL Server reference input
INTO, SQL Server table
SELECT a.Id
,SUM(r.FYQ1__c) AS FYQ1__c
,SUM(r.FYQ2__c) AS FYQ2__c
,SUM(r.FYQ3__c) AS FYQ3__c
,SUM(r.FYQ4__c) AS FYQ4__c
INTO
[OutRevenueSplitVsAccount]
FROM
[RevenueSplitEvHuBIn] AS r TIMESTAMP BY LastModifiedDate
INNER JOIN [OpportunityInputTbl] AS o ON r.Opportunity__c = o.Id
INNER JOIN [AccountInputTbl] AS a ON o.AccountId = a.Id
GROUP BY a.Id, TumblingWindow(day,2)
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,061 Reputation points2021-02-16T05:43:11.297+00:00 Hello @Akila Ariyarathne and welcome to Microsoft Q&A.
While I begin my attempt to reproduce your issue, could you please manually check your data as to whether the join -- when working correctly -- produces results?
-
Akila Ariyarathne 1 Reputation point
2021-02-16T07:11:04.743+00:00 Yes, I checked manually and it worked, Also I tried to upload sample data and again it failed.
-
MartinJaffer-MSFT 26,061 Reputation points
2021-02-17T01:34:42.227+00:00 @Akila Ariyarathne there is one thing about your query that stands out.
The query you shared starts with FROM. Is this intentional or did you miss a line? To my understanding, the query should start with SELECT or WITH.
-
Akila Ariyarathne 1 Reputation point
2021-02-17T05:01:45.743+00:00 SELECT a.Id
,SUM(r.FYQ1_c) AS FYQ1c
,SUM(r.FYQ2c) AS FYQ2c
,SUM(r.FYQ3c) AS FYQ3c
,SUM(r.FYQ4c) AS FYQ4c
INTO
[OutRevenueSplitVsAccount]
FROM
[RevenueSplitEvHuBIn] AS r TIMESTAMP BY LastModifiedDate
INNER JOIN [OpportunityInputTbl] AS o ON r.Opportunity_c = o.Id
INNER JOIN [AccountInputTbl] AS a ON o.AccountId = a.Id
GROUP BY a.Id, TumblingWindow(day,2)Query starts from SELECT as above, its just an explanation about reference
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 33%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Akila Ariyarathne 1 Reputation point2021-03-02T11:14:57.62+00:00 Hi @MartinJaffer-MSFT , I still unable to fix the issue, Highly apricate if u help on this.
Sign in to comment