question

sakuraime avatar image
0 Votes"
sakuraime asked ·

Stream Analytic Partition input

I have set the partition ID for the into with a name "deviceID"

59850-capture2.jpg


And in the query , I find that the build in column partitionID is different from my desired partition column (deviceID). why is that ? IS is normal ? And my table in DB was correctly partition by deviceID

59895-capture.jpg


azure-event-hubsazure-stream-analytics
capture2.jpg (11.0 KiB)
capture.jpg (83.3 KiB)
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @sakuraime ,
We have not heard back from you this . Let us know if you have any further questions.
Thanks
Himanshu

0 Votes 0 ·

Hello @sakuraime ,
We have not heard back from you this yet . Let us know if you have any further questions.
Thanks
Himanshu

0 Votes 0 ·
HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

Hello @sakuraime ,

The paritionid is for the input partions . In your case its EH , please navigate to Azure port => EventHubs -> your EH name -> properties

60366-2021-01-25-15-52-57-calculator.png

Thanks
Himanshu



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SerkantKaraca-MSFT avatar image
0 Votes"
SerkantKaraca-MSFT answered ·

Device-id doesn't map to partition IDs in 1:1 cardinality. For instance, you may have millions of different device IDs where all sending to 32 partitions.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.