Topik ini menjelaskan cara melakukan analisis sentimen pada komentar online menggunakan model publik di MaxCompute.
Scenario
Pertumbuhan pesat media sosial dan platform e-commerce telah memicu lonjakan komentar pengguna yang memuat berbagai informasi mengenai sentimen dan opini publik. Analisis sentimen kini menjadi alat penting untuk pemantauan opini publik, manajemen merek, dan optimalisasi produk. Topik ini memberikan contoh praktis penggunaan SQL untuk memanggil AI Function di MaxCompute dengan model besar publik bawaan, seperti qwen3.7-max, guna langsung melakukan klasifikasi sentimen dan mengekstraksi informasi geografis dari komentar. Proses ini tidak memerlukan penerapan model, layanan eksternal, atau migrasi data. Anda dapat menjalankan analisis cerdas dalam lingkungan yang aman dan terkendali, sehingga secara signifikan meningkatkan efisiensi dan kemudahan analisis.
Benefits
Dengan memanfaatkan model publik dan AI Function di MaxCompute, Anda dapat menjalankan tugas analisis data kompleks—seperti analisis sentimen teks—tanpa perlu menerapkan model atau mengembangkan fungsi khusus.
Analisis sepenuhnya dilakukan di dalam platform tanpa migrasi data atau ketergantungan pada layanan eksternal, sehingga menjamin keamanan dan kepatuhan terhadap regulasi data.
Pendekatan ini menurunkan hambatan masuk dan meningkatkan efisiensi analisis. Dibandingkan metode tradisional seperti tabel pemetaan statis atau ekspresi reguler, pendekatan ini menawarkan skalabilitas dan fleksibilitas lebih tinggi serta kemampuan menangani hubungan kompleks. Selain itu, pendekatan ini lebih ramah pengguna dan mengurangi biaya pemeliharaan.
Prerequisites
Lewati langkah ini jika Anda telah mengaktifkan MaxCompute dan membuat proyek MaxCompute.
Prepare data
Contoh ini menggunakan client odpscmd untuk menjalankan perintah.
Create a table
Untuk informasi lebih lanjut tentang pembuatan tabel, lihat Create and drop tables:
CREATE TABLE IF NOT EXISTS emotional_comment
(
content_id STRING COMMENT 'ID komentar',
text STRING COMMENT 'Isi komentar',
publish_time STRING COMMENT 'Waktu komentar',
user_id STRING COMMENT 'ID pengguna',
user_followers STRING COMMENT 'Jumlah pengikut pengguna',
user_region STRING COMMENT 'Wilayah pengguna',
repost_count STRING COMMENT 'Jumlah repost',
comment_count STRING COMMENT 'Jumlah komentar',
quote_count STRING COMMENT 'Jumlah like'
);Import data
Unduh file data sampel: demo_comment.csv.
TUNNEL UPLOAD demo_comment.csv emotional_comment;
SELECT * FROM emotional_comment LIMIT 10;
+------------------+----------------------------------------------------+---------------+------------+----------------+-------------+--------------+---------------+-------------+
| content_id | text | publish_time | user_id | user_followers | user_region | repost_count | comment_count | quote_count |
+------------------+----------------------------------------------------+---------------+------------+----------------+-------------+--------------+---------------+-------------+
| 5087a5a3c22e3f4c | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. | 2025/5/27 12:49 | user_918561 | 132169 | Xi'an | 1015 | 3197 | 1300 |
| 299aa8f97b6fee2f | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. | 2025/5/31 07:46 | user_403208 | 669019 | Hohhot | 6616 | 4876 | 201 |
| e7ee00dec51b28f6 | Technology is advancing rapidly, and AI is changing our lives. | 2025/5/17 11:39 | user_291936 | 840757 | Nanning | 264 | 3668 | 174 |
| 0c0d61608cabbac3 | The prevention and control measures are very effective. Thumbs up to the healthcare workers! | 2025/5/18 03:29 | user_154572 | 925604 | Fuzhou | 2154 | 652 | 470 |
| 106b979787b580d1 | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. | 2025/5/28 14:45 | user_528807 | 656952 | Qingdao | 6617 | 3890 | 1275 |
| 05b0e2ef4636d5c9 | Environmental awareness needs to be further improved to protect our planet. | 2025/5/16 09:06 | user_693289 | 211093 | Foshan | 4283 | 1592 | 1792 |
| c9773c4a632a8839 | The service at this restaurant is excellent, and the food is delicious. Highly recommended. | 2025/5/21 19:19 | user_850376 | 817461 | Shenyang | 9552 | 3974 | 1740 |
| 089e0c5dddc53198 | Environmental awareness needs to be further improved to protect our planet. | 2025/5/17 10:58 | user_800324 | 716599 | Harbin | 5725 | 4437 | 939 |
| 04fd7323a957d978 | Education reform measures need more time to show results. | 2025/5/26 01:25 | user_544689 | 416372 | Hefei | 1440 | 4185 | 416 |
| 04cf4066c5c1e9c7 | The service at this restaurant is excellent, and the food is delicious. Highly recommended. | 2025/5/27 03:49 | user_373334 | 722353 | Changchun | 1134 | 3936 | 773 |
+------------------+----------------------------------------------------+---------------+------------+----------------+-------------+--------------+---------------+-------------+
View public model
Jalankan perintah SQL berikut untuk melihat detail model publik qwen3.7-max.
-- Setel flag.
SET odps.namespace.schema=false;
-- Lihat detail model publik.
DESC MODEL bigdata_public_modelset.`qwen3.7-max`;
+------------------------------------------------------------------------------------+
| Model Information |
+------------------------------------------------------------------------------------+
| Owner: RAM$odps@aliyun-inner.com:maxcompute_bigdata_public |
| Project: bigdata_public_modelset |
| Model Name: qwen3.7-max |
| Model Type: LLM |
| Source Type: REMOTE |
| Default Version: v1 |
| CreateTime: 2026-05-25 14:51:41 |
| LastModifiedTime: 2026-05-25 14:51:41 |
| Model ID: 724b2d7984f94f9a9e110969514e23e1 |
| Comment: MaxCompute Public LLM Model qwen3.7-max |
+------------------------------------------------------------------------------------+
| Version Information |
+------------------------------------------------------------------------------------+
| Owner: RAM$odps@aliyun-inner.com:maxcompute_bigdata_public |
| Project: bigdata_public_modelset |
| Model Name: qwen3.7-max |
| Model Type: LLM |
| Source Type: REMOTE |
| Version Name: v1 |
| Version ID: de37f6e4323346ebbcfbed0789194647 |
| Path: |
| CreateTime: 2026-05-25 14:51:41 |
| LastModifiedTime: 2026-05-25 14:51:41 |
| default_enable_thinking: TRUE |
| modelstudio_model_name: qwen3.7-max |
| price_tier: {
"tier1": [0,1024000]
} |
| reasoning_mode: TRUE |
+------------------------------------------------------------------------------------+
| Input | Type | Comment |
+------------------------------------------------------------------------------------+
+------------------------------------------------------------------------------------+
Analyze data
Contoh kode berikut menunjukkan cara menggunakan fungsi AI_GENERATE di MaxCompute dengan model besar publik (qwen3.7-max) untuk menjalankan dua tugas inferensi AI secara bersamaan dalam satu kueri SQL:
Parsing Informasi Geografis: Secara otomatis menentukan provinsi (misalnya, "Shaanxi Province") berdasarkan nama kota dalam komentar pengguna (misalnya, "Xi'an").
Klasifikasi Sentimen: Melakukan analisis sentimen pada teks komentar dan menghasilkan label standar ("positive", "negative", atau "neutral").
Untuk informasi lebih lanjut, lihat AI_GENERATE:
-- Gunakan fungsi AI_GENERATE untuk memanggil model bawaan qwen3.7-max dan menghasilkan nama provinsi serta label analisis sentimen.
SELECT
AI_GENERATE(
bigdata_public_modelset.`qwen3.7-max`,
default_version,
CONCAT(
'Provide the province where the following city is located. If the city is a municipality or special administrative region, return the city name itself. Output only the province name. City name:',user_region),
'{"max_tokens": 1000, "temperature": 0.7}'
) as province,
user_region,
AI_GENERATE(
bigdata_public_modelset.`qwen3.7-max`,
default_version,
CONCAT(
'Perform sentiment classification on the following comment. The output must be one of these three options: Positive, Negative, Neutral. Comment to analyze:', text),
'{"max_tokens": 1000, "temperature": 0.7}'
) as sentiment_label,
text
FROM emotional_comment limit 20
;
+--------------------+----------------+--------------------+----------------------------------------------------+
| province | user_region | sentiment_label | text |
+--------------------+----------------+--------------------+----------------------------------------------------+
| "Shaanxi Province" | Xi'an | "Positive" | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. |
| "Inner Mongolia Autonomous Region" | Hohhot | "Positive" | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. |
| "Guangxi" | Nanning | "Positive" | Technology is advancing rapidly, and AI is changing our lives. |
| "Fujian Province" | Fuzhou | "Positive" | The prevention and control measures are very effective. Thumbs up to the healthcare workers! |
| "Shandong Province" | Qingdao | "Positive" | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. |
| "Gansu Province" | Lanzhou | "Neutral" | Education reform measures need more time to show results. |
| "Fujian Province" | Fuzhou | "Positive" | Technology is advancing rapidly, and AI is changing our lives. |
| "Hunan Province" | Changsha | "Negative" | I strongly protest this measure, it's completely unreasonable! |
| "Chongqing" | Chongqing | "Positive" | The prevention and control measures are very effective. Thumbs up to the healthcare workers! |
| "Guangdong Province" | Guangzhou | "Positive" | Food safety cannot be ignored; regulation must be stricter. |
| "Shaanxi Province" | Xi'an | "Negative" | The stock market has been very volatile lately, so invest with caution. |
| "Shandong Province" | Jinan | "Positive" | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. |
| "Tianjin" | Tianjin | "Positive" | The new product launch was very successful, looking forward to future developments. |
| "Tianjin" | Tianjin | "Positive" | The weather is great today, and I'm in a good mood! The sun is shining, perfect for a walk. |
| "Xinjiang" | Urumqi | "Negative" | Housing prices have gone up again, and the pressure on young people to buy a home is increasing. |
| "Guangxi" | Nanning | "Positive" | The new product launch was very successful, looking forward to future developments. |
| "Qinghai Province" | Xining | "Positive" | The sporting events are spectacular. Let's cheer for the athletes! |
| "Heilongjiang Province" | Harbin | "Negative" | The stock market has been very volatile lately, so invest with caution. |
| "Heilongjiang Province" | Harbin | "Positive" | The sporting events are spectacular. Let's cheer for the athletes! |
| "Jiangsu Province" | Nanjing | "Negative" | The traffic congestion is terrible. I was half an hour late for work, so annoying. |
+--------------------+----------------+--------------------+----------------------------------------------------+