Stream Analytic Partition input

Question

question

sakuraime asked · Jan 24 at 10:24 AM

Stream Analytic Partition input

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

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

azure-event-hubs azure-stream-analytics

capture2.jpg (11.0 KiB)

capture.jpg (83.3 KiB)

· 2

10 |1000 characters needed characters left characters exceeded

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

HimanshuSinha-MSFT · Feb 02 at 05:26 PM

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

0 ·

HimanshuSinha-MSFT HimanshuSinha-MSFT · Feb 03 at 06:22 PM

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

0 ·

Answer 1 · 2021-01-25T23:54:15.393Z

HimanshuSinha-MSFT answered · Jan 25 at 11:54 PM

Hello @sakuraime ,

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

Thanks
Himanshu

2021-01-25-15-52-57-calculator.png (10.8 KiB)

·

10 |1000 characters needed characters left characters exceeded

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

Answer 2 · 2021-01-26T04:45:48.707Z

SerkantKaraca-MSFT answered · Jan 26 at 04:45 AM

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

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

question