Slide 15
Slide 15 text
[4-5] Aurora Machine Larning
● 試してみた(MySQL 5.7 互換版+Comprehend)
MySQL [mltest]> SELECT lyrics,
-> aws_comprehend_detect_sentiment(lyrics, 'en') AS sentiment,
-> aws_comprehend_detect_sentiment_confidence(lyrics, 'en') AS confidence
-> FROM lyrics
-> ORDER BY id;
+------------------------------------------------------------------------------------------------------+-----------+--------------------+
| lyrics | sentiment | confidence |
+------------------------------------------------------------------------------------------------------+-----------+--------------------+
| Jingle bells, jingle bells Jingle all the way, Oh, what fun it is to ride In a one-horse open sleigh | POSITIVE | 0.8357130289077759 |
| Silent night, holy night All is calm, all is bright | POSITIVE | 0.9700412154197693 |
+------------------------------------------------------------------------------------------------------+-----------+--------------------+
2 rows in set (0.11 sec)
15