Not able to use ML model to post and retrieve data

Rafay Hassan Niazi 6

I am using ml library model that results into below output on test page.

False Alarm Prediction using Two Class Decision Forest [Predictive Exp.]' test returned ["8/10/2023 6:15:00 AM","User C","Administrator","Element 1","Select","False","0"]

I am writing below SQL query in Azure Stream Analytics as

With mlm1 AS (SELECT Timestamp, Requestor, Role, [Component Accessed], [Request type], udf.mlm(Timestamp, Requestor, Role, [Component Accessed], [Request type]) as result 
FROM EHInput)

SELECT result  
INTO mlop
FROM mlm1

but getting out put in csv file as below:

result

Record

Could anyone pls help me write the correct query so that i get same output in csv as I am getting on ML studio Webservice test page...

QuantumCache 20,031

Hello @Rafay Hassan Niazi,

Could you please add the screenshot of the output?
You may give try the below query...

WITH mlm1 AS (
    SELECT Timestamp, Requestor, Role, [Component Accessed], [Request type], udf.mlm(Timestamp, Requestor, Role, [Component Accessed], [Request type]) as result 
    FROM EHInput
)

SELECT 
    result[0] AS Timestamp,
    result[1] AS Requestor,
    result[2] AS Role,
    result[3] AS [Component Accessed],
    result[4] AS [Request type],
    result[5] AS Prediction,
    result[6] AS Confidence
INTO mlop
FROM mlm1

QuantumCache 20,031 Reputation points

2023-09-06T00:07:46.8066667+00:00

Hello @Rafay Hassan Niazi, Just checking if we are still connected on this discussion? Please click "Accept Answer" . So that we can close this thread.