Do I need to partition a LAG statement in a SELECT clause if the query is already being partitioned?

i have query pulling data directly input , using partition partitionkey on query:

select a

from inputstream partition partitionkey

if need add lag select:

select a, lag(a, 1) on (partition partitionkey limit duration(hour, 1)) preva

from inputstream partition partitionkey

so partition statement in lag necessary in scenario or can removed since source being partitioned?

hi,

it may redundant, should keep partition in lag statement, describes intent of query.

the partition @ query level (in statement) used performance optimization.

thanks,

Microsoft Azure > Azure Stream Analytics

Gain