It's now possible to partition your Azure Stream Analytics output to Azure Blob storage based on any column in the query. The partition key can be a column from the input stream, or it can be a field in the query itself.
For more information, see the blog post.