PolarDB:Tongyi Qianwenモデルを使用したデータの推論と対話

制限事項

• 既定では、オンライン推論は1つのエントリのみを処理して、高いクエリパフォーマンスを確保できます。 複数のエントリが提出された場合、最初のエントリのみが予測されます。 オフライン推論は複数のエントリを処理できます。

• Tongyi Qianwenモデルは8,000トークンをサポートしています。 ただし、10秒以内に結果を生成できない場合、モデルのコンピューティングリソースが限られているため、結果は返されません。 この場合、AIノードを追加してモデルのパフォーマンスを向上させることができます。

例

データ準備

1. 次のSQL文を実行して、textinfoという名前のテーブルを作成します。

   CREATE TABLE IF NOT EXISTS textinfo (
       id INT NOT NULL,
       content TEXT NOT NULL
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. 次のSQL文を実行して、次のデータをtextinfoテーブルに追加します。

   INSERT INTO textinfo (id,content) VALUES (1. "This product has a good appearance. However, it does not deliver satisfactory experience. We recommend that you do not buy it.")
   INSERT INTO textinfo (id,content) VALUES (2. "The latest version of the mobile phone Mate 60 Pro developed by Huawei has experienced a surge in sales after its market launch and is out of stock. Guo Mingji, a well-known analyst, said on Monday that the influence of Huawei on the industry and the stock market cannot be ignored, and this influence is returning. This influence is shown in the significant increase of the shipment expectations of Mate 60 Pro.")
   INSERT INTO textinfo (id,content) VALUES (3. "The biggest change this summer is the failure of Hollywood blockbusters and the popularity of domestic films that have a realistic theme. 
   In the past, Hollywood blockbusters focused on dazzling visual effects, action, fantasy and adventure theme, and mainly relied on visual bombardment. In the post-epidemic era, audiences are more interested in realistic and personal content. 
   The top 10 movies this year have realistic themes. 
   "Lost in the stars" combines hot topics such as anti-love brain and the wife killing of Thailand. "Never Say Never" deeply digs into the life experience of Wang Baoqiang and focuses on grassroots counter-attack. "No More Bets" focuses on curiosity about social hot spots such as telecom fraud, Myanmar's fraud park, and the setting up of lotus officials. "One and Only" also focuses on the growth of ordinary people. 
   Looking back on the Chinese film market in recent years, we can conclude that the realistic theme has already begun to rise in popularity. 
   In 2018, "Dying to Survive" won the summer championship with 3.1 billion box office. The following films are of the realistic theme: "The White Storm 2: Drug Lords" in 2019, "Raging Fire" in 2021, "Chinese Doctor" in 2021, "Lighting Up The Stars" in 2022, and "Nice View" and "Sister" played on other schedules.
   INSERT INTO textinfo (id,content) VALUES (4. "Tell me who you are within 30 words")

Tongyi Qianwenモデルに基づく推論

シナリオ1: センチメント分析

文の感情的な傾向を分析します。 たとえば、eコマースのコメント、ニュースレポート、世論の感情的な傾向を分析できます。

/*polar4ai*/ SELECT * FROM PREDICT (MODEL _polar4ai_tongyi_sa, SELECT content FROM textinfo WHERE id=1) WITH ();

次の応答が返されます。

Negative sentiment

シナリオ2: 肯定的または否定的なコメントの生成

コンテンツに基づいて肯定的または否定的なコメントを生成します。

• 肯定的なコメントを生成する:

  /*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi_p_comment, SELECT content FROM textinfo WHERE id=2) with ()

  次の応答が返されます。

  Mate 60 Pro developed by Huawei has witnessed a significant increase in sales volume and popularity immediately after its market launch. This suggests that consumers have shown a positive response to the Huawei brand and have expressed their support by purchasing the product. As a well-known technology company in China, the behavior of Huawei in the mobile phone market has attracted much attention. The post of Guo Mingjī further confirms the influence of Huawei in the industry and the stock market, which indicates that Huawei is gradually returning to its rightful place. The influence of Huawei is reflected not only in its product sales, but also in its role in promoting the entire technology industry and the stock market. We should encourage and support excellent enterprises like Huawei to promote the sustained development of the science and technology industry in China.

• 否定的なコメントを生成する:

  /*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi_n_comment, SELECT content FROM textinfo WHERE id=2) with ();

  次の応答が返されます。

  The significant increase in the sales volume of Mate 60 Pro developed by Huawei is surprising. This shows that consumers have a strong level of recognition and support for the Huawei brand. However, this may also be related to the current instability in the global technology market. As a Chinese company, Huawei has been under political and economic pressure in the international market, which may affect its sales performance. In addition, the comments of Guo Mingjī, a well-known analyst, may be overly optimistic and ignores the challenges and difficulties that Huawei faces. In summary, although the influence of Huawei is returning, the future market performance of the brand still needs to be treated with caution.

シナリオ3: 概要

コンテンツに基づいてトピックの概要を生成します。

/*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi_summarize, SELECT content FROM textinfo WHERE id=3) with ();

次の応答が返されます。

The biggest change this summer is that films of the realistic theme have higher popularity than Hollywood blockbusters. In the Chinese film market, films of the realistic theme have become mainstream. Many films of this theme such as "The White Storm 2: Drug Lords" and "Raging Fire" gain high box office.

シナリオ4: 翻訳

コンテンツを中国語から英語に翻訳するか、他の言語 (英語を含む) から中国語に翻訳します。

/*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi_tran_2_en, SELECT content FROM textinfo WHERE id=1) with ();

次の応答が返されます。

The item looks okay, but the actual experience is very poor. I don't recommend buying it.

シナリオ5: 対話

コンテンツへの回答を生成します。 コンテンツは、いくつかの明示的なプロンプトを含み得る。 コンテンツに対する回答は、プロンプトに基づいて生成される。

/*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi, SELECT content FROM textinfo WHERE id=4) with ();

次の応答が返されます。

I am an ultra-large-scale language model developed by Alibaba DAMO Academy. My name is Tongyi Qianwen.

テキストを直接入力して結果を取得することもできます。 たとえば、「シナリオ5: 対話」で説明されている例では、次のステートメントを実行することもできます。

/*polar4ai*/SELECT * FROM PREDICT (MODEL _polar4ai_tongyi, SELECT 'Tell me who you are within 30 words') with ();

次の応答が返されます。

I am an ultra-large-scale language model developed by Alibaba DAMO Academy. My name is Tongyi Qianwen.