Stream Analytic Partition input

sakuraime 2,321 Reputation points
2021-01-24T10:24:30.72+00:00

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 Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
558 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-01-25T23:54:15.393+00:00

    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

    0 comments
  2. Serkant Karaca 21 Reputation points Microsoft Employee
    2021-01-26T04:45:48.707+00:00

    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.

    0 comments