スキップしてコンテンツを表示

Can Redshift ML generated function return the probability value for binary classification?

0

We tried the tutorial at https://docs.aws.amazon.com/redshift/latest/dg/tutorial_customer_churn.html for Redshift ML, and were able to get the results in the tutorial. However, we'd like get the prediction with the probability, or just the probability of "TRUE". For instance, the sample SQL statement

SELECT phone, ml_fn_customer_churn_auto( state, account_length, area_code, total_charge/account_length,  cust_serv_calls/account_length ) AS active FROM customer_activity WHERE record_date > '2020-01-01';

returns

phoneactive
329-9001False
335-4719True
330-8173False
351-7269True

What we'd like to have is

phoneactiveprobability of True
329-9001False0.235
335-4719True0.621
330-8173False0.442
351-7269True0.893

or the above table without the "active" column.

Can this be done with "CREATE MODEL" statement? Any other suggestion to get it?

Thanks in advance.

質問済み 5年前494ビュー

1回答
1
承認された回答

Thank you for posting the question and the detailed explanation on what you are expecting. This is currently not supported in Redshift ML with binary classification. I have raised a feature request with the service team on your behalf. While I am unable to comment on if/when this feature may get released, I request you to keep an eye on our What's New and Blog pages for any new feature announcements.

サポートエンジニア

回答済み 5年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

関連するコンテンツ