{"id":86091,"date":"2024-11-30T05:08:48","date_gmt":"2024-11-30T01:38:48","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/"},"modified":"2024-11-30T05:08:48","modified_gmt":"2024-11-30T01:38:48","slug":"resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/","title":{"rendered":"\u062d\u0644 \u0633\u0648\u0627\u0644\u0627\u062a \u0642\u0637\u0639\u06cc \u0628\u0627 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u0648\u0644\u062f: \u06cc\u06a9 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0639\u0645\u0644\u06cc"},"content":{"rendered":"<p>Summarize this content to 400 words in Persian Lang <\/p>\n<p>  \u0645\u0642\u062f\u0645\u0647<\/p>\n<p>\u062f\u0631 \u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u067e\u0648\u06cc\u0627 \u0645\u0648\u0644\u062f \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0627\u0645\u0631\u0648\u0632\u06cc\u060c \u0645\u062f\u0644 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0632\u0631\u06af (LLM) \u062a\u0639\u0627\u0645\u0644 \u0645\u0627 \u0628\u0627 \u0641\u0646\u0627\u0648\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0634\u062f\u062a \u0645\u062a\u062d\u0648\u0644 \u06a9\u0631\u062f\u0647 \u0627\u0646\u062f. \u0627\u06cc\u0646 \u0645\u062f\u0644\u200c\u0647\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u062b\u0646\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u062a\u0648\u0644\u06cc\u062f \u0645\u062a\u0646\u060c \u062a\u062d\u0644\u06cc\u0644 \u0627\u062d\u0633\u0627\u0633\u0627\u062a \u0648 \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647\u200c\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0627\u0646\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u0627 \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627\u06cc\u06cc \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645 \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0645\u0646\u062f \u062f\u0642\u062a \u0645\u0637\u0644\u0642 \u0648 \u0646\u062a\u0627\u06cc\u062c \u0642\u0637\u0639\u06cc \u0647\u0633\u062a\u0646\u062f\u060c \u0628\u0627 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u0630\u0627\u062a\u06cc \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0646\u0648\u0622\u0648\u0631\u0627\u0646\u0647 \u0645\u0648\u0631\u062f \u062a\u0648\u062c\u0647 \u0642\u0631\u0627\u0631 \u06af\u06cc\u0631\u062f.<\/p>\n<p>  \u0686\u0627\u0644\u0634 \u0645\u062f\u0644 \u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/p>\n<p>  \u0645\u0628\u0627\u0646\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a LLM<\/p>\n<p>\u0645\u062f\u0644\u200c\u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0632\u0631\u06af \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0627\u062d\u062a\u0645\u0627\u0644\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u062f\u0631 \u0647\u0633\u062a\u0647 \u062e\u0648\u062f\u060c \u0627\u06cc\u0646 \u0645\u062f\u0644 \u0647\u0627:<\/p>\n<p>\u067e\u06cc\u0634\u200c\u0628\u06cc\u0646\u06cc \u0645\u062a\u0646\u06cc: \u0622\u0646\u0647\u0627 \u0632\u0645\u06cc\u0646\u0647 \u0642\u0628\u0644\u06cc \u0631\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u0646\u062f \u062a\u0627 \u0645\u062d\u062a\u0645\u0644 \u062a\u0631\u06cc\u0646 \u06a9\u0644\u0645\u0647 \u06cc\u0627 \u062f\u0646\u0628\u0627\u0644\u0647 \u0628\u0639\u062f\u06cc \u0631\u0627 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u062a\u0648\u0632\u06cc\u0639 \u0627\u062d\u062a\u0645\u0627\u0644: \u0622\u0646\u0647\u0627 \u06cc\u06a9 \u062a\u0648\u0632\u06cc\u0639 \u0627\u062d\u062a\u0645\u0627\u0644 \u0628\u0631\u0627\u06cc \u06af\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u067e\u0627\u0633\u062e \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u062f\u0645\u0627 \u0648 \u062a\u0635\u0627\u062f\u0641\u06cc \u0628\u0648\u062f\u0646: \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u062f\u0645\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0646\u062a\u0631\u0644 \u062e\u0644\u0627\u0642\u06cc\u062a \u062f\u0631 \u0645\u0642\u0627\u0628\u0644. \u062c\u0628\u0631 \u062f\u0631 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0622\u0646\u0647\u0627<\/p>\n<p>\u0627\u06cc\u0646 \u0645\u0627\u0647\u06cc\u062a \u0627\u062d\u062a\u0645\u0627\u0644\u06cc \u062f\u0642\u06cc\u0642\u0627\u064b \u0647\u0645\u0627\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 LLM \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0647\u0627\u06cc \u062e\u0644\u0627\u0642\u0627\u0646\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0645\u062a\u0646\u0648\u0639 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0642\u062a \u0639\u062f\u062f\u06cc \u06cc\u0627 \u062f\u0642\u062a \u0645\u0637\u0644\u0642 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f \u06a9\u0645\u062a\u0631 \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  \u0632\u0645\u06cc\u0646\u0647: \u0627\u0632 \u06cc\u06a9 POC \u0634\u06a9\u0633\u062a \u062e\u0648\u0631\u062f\u0647 \u062a\u0627 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0646\u0648\u0622\u0648\u0631\u0627\u0646\u0647<\/p>\n<p>\u0637\u06cc \u0686\u0646\u062f \u0645\u0627\u0647 \u06af\u0630\u0634\u062a\u0647\u060c \u062f\u0631 \u062d\u06cc\u0646 \u0627\u0646\u062c\u0627\u0645 \u0686\u0646\u062f\u06cc\u0646 \u06af\u0641\u062a\u06af\u0648 \u062f\u0631 \u0645\u0648\u0631\u062f \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc Generative\u060c \u06cc\u06a9 \u0645\u06a9\u0627\u0644\u0645\u0647 \u062e\u0627\u0635 \u062a\u0648\u062c\u0647 \u0645\u0646 \u0631\u0627 \u0628\u0647 \u062e\u0648\u062f \u062c\u0644\u0628 \u06a9\u0631\u062f. \u06cc\u06a9 \u062a\u06cc\u0645 \u062a\u0648\u0633\u0639\u0647 \u0646\u0627\u0631\u0636\u0627\u06cc\u062a\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0627\u062b\u0628\u0627\u062a \u0645\u0641\u0647\u0648\u0645\u06cc (POC) \u06a9\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0622\u0646\u0647\u0627 \u0646\u0627\u0645\u0648\u0641\u0642 \u0628\u0648\u062f\u060c \u0628\u0627 \u0645\u0646 \u062f\u0631 \u0645\u06cc\u0627\u0646 \u06af\u0630\u0627\u0634\u062a\u0646\u062f. \u0645\u0634\u06a9\u0644: \u0627\u062c\u0631\u0627\u06cc \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u0648\u0644\u062f \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u06cc\u0637 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u062a\u0627\u06cc\u062c \u0645\u062a\u0646\u0627\u0642\u0636\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f.<\/p>\n<p>\u0628\u0627 \u062d\u0641\u0627\u0631\u06cc \u0639\u0645\u06cc\u0642 \u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f\u060c \u06cc\u06a9 \u0627\u0644\u06af\u0648\u06cc \u062c\u0627\u0644\u0628 \u0638\u0627\u0647\u0631 \u0634\u062f:<\/p>\n<p>  \u0686\u0647 \u0686\u06cc\u0632\u06cc \u062e\u0648\u0628 \u06a9\u0627\u0631 \u06a9\u0631\u062f:<\/p>\n<p>&#8220;\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u06cc\u06a9\u062a \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc X&#8221;<br \/>\n&#8220;\u062e\u0644\u0627\u0635\u0647 \u0645\u0648\u0631\u062f Y \u0686\u06cc\u0633\u062a\u061f&#8221;<br \/>\n&#8220;\u0627\u06cc\u0646 \u06af\u0632\u0627\u0631\u0634 \u062d\u0627\u062f\u062b\u0647 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f\u061f&#8221;<\/p>\n<p>\u0627\u06cc\u0646 \u0633\u0648\u0627\u0644\u0627\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0645\u0646\u062f \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647 \u0627\u06cc \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u06cc\u0641\u06cc \u0628\u0648\u062f\u0646\u062f\u060c \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0648 \u0645\u0641\u06cc\u062f\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f\u0646\u062f.<\/p>\n<p>  \u0622\u0646\u0686\u0647 \u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062e\u0648\u0631\u062f:<\/p>\n<p>&#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221;<br \/>\n\u0645\u0627\u0647 \u06af\u0630\u0634\u062a\u0647 \u0628\u0647 \u0686\u0646\u062f \u0628\u0644\u06cc\u0637 \u067e\u0627\u0633\u062e \u062f\u0627\u062f\u0647 \u0634\u062f\u061f<br \/>\n&#8220;\u0645\u062a\u0648\u0633\u0637 \u200b\u200b\u0632\u0645\u0627\u0646 \u062a\u0641\u06a9\u06cc\u06a9 \u0686\u0642\u062f\u0631 \u0627\u0633\u062a\u061f&#8221;<\/p>\n<p>\u0633\u0648\u0627\u0644\u0627\u062a\u06cc \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0642\u062a \u0639\u062f\u062f\u06cc \u0648 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u062f\u0627\u0634\u062a\u0646\u062f\u060c \u0647\u0631\u06af\u0632 \u0646\u062a\u0627\u06cc\u062c \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f\u06cc \u0627\u0631\u0627\u0626\u0647 \u0646\u06a9\u0631\u062f\u0646\u062f.<\/p>\n<p>  \u0645\u06a9\u0627\u0634\u0641\u0647 \u06a9\u0644\u06cc\u062f\u06cc<\/p>\n<p>\u062f\u0644\u06cc\u0644 \u0634\u06a9\u0633\u062a \u0632\u0645\u0627\u0646\u06cc \u0622\u0634\u06a9\u0627\u0631 \u0634\u062f \u06a9\u0647 \u0645\u0627\u0647\u06cc\u062a \u0627\u0633\u0627\u0633\u06cc LLM \u0647\u0627 \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0631\u062f\u06cc\u0645: \u0622\u0646\u0647\u0627 \u0630\u0627\u062a\u0627 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u0647\u0633\u062a\u0646\u062f. \u0646\u0642\u0637\u0647 \u0642\u0648\u062a \u0622\u0646 \u062f\u0631 \u067e\u0631\u062f\u0627\u0632\u0634 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc \u0648 \u062a\u0648\u0644\u06cc\u062f \u0645\u062d\u062a\u0648\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0627\u062d\u062a\u0645\u0627\u0644 \u0627\u0633\u062a\u060c \u0646\u0647 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u06cc\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647.<\/p>\n<p>\u0627\u06cc\u0646 \u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u0645\u0646 \u0631\u0627 \u0628\u0631 \u0622\u0646 \u062f\u0627\u0634\u062a \u062a\u0627 \u067e\u0631\u0633\u0634 \u06a9\u0644\u06cc\u062f\u06cc \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0641\u0631\u0645\u0648\u0644\u0647 \u06a9\u0646\u0645:<\/p>\n<p>\u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u0633\u0624\u0627\u0644\u0627\u062a \u0642\u0637\u0639\u06cc \u067e\u0627\u0633\u062e \u062f\u0647\u06cc\u0645 \u0648\u0642\u062a\u06cc \u06a9\u0647 \u06cc\u06a9 LLM\u060c \u0628\u0646\u0627 \u0628\u0647 \u0645\u0627\u0647\u06cc\u062a \u062e\u0648\u062f\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0637\u0631\u0627\u062d\u06cc \u0646\u0634\u062f\u0647 \u0627\u0633\u062a\u061f<\/p>\n<p>\u067e\u0627\u0633\u062e \u0627\u0632 \u062f\u0631\u06a9 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0628\u0648\u062f \u06a9\u0647 \u0645\u0627 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0648\u0627\u062f\u0627\u0631 \u06a9\u0631\u062f\u0646 LLM \u0628\u0647 \u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0637\u0631\u0627\u062d\u06cc \u0646\u0634\u062f\u0647 \u0628\u0648\u062f\u060c \u0628\u0647 \u062f\u0633\u062a \u0622\u0645\u062f. \u062f\u0631 \u0639\u0648\u0636\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645:<\/p>\n<p>\u0627\u0632 LLM \u0628\u0631\u0627\u06cc \u0628\u0647\u062a\u0631\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f: \u0647\u062f\u0641 \u0633\u0648\u0627\u0644 \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0646\u06cc\u062f.<br \/>\n\u062f\u0631 \u0635\u0648\u0631\u062a \u0644\u0632\u0648\u0645 \u0622\u0646 \u0647\u062f\u0641 \u0631\u0627 \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u062a\u0631\u062c\u0645\u0647 \u06a9\u0646\u06cc\u062f.<br \/>\n\u0627\u0632 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062e\u0635\u0635\u06cc \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<br \/>\n\u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0646\u0633\u062c\u0645 \u0648 \u0637\u0628\u06cc\u0639\u06cc \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u062f.<\/p>\n<p>  \u0634\u06a9\u0627\u0641 \u0628\u06cc\u0646 \u062f\u0642\u062a \u0648 \u0627\u062d\u062a\u0645\u0627\u0644: \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0631\u0627\u0647 \u062d\u0644<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0647\u0633\u062a\u0647 \u0627\u0635\u0644\u06cc \u0645\u0634\u06a9\u0644 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0634\u062f\u060c \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0645 \u06a9\u0647 \u0627\u0628\u062a\u062f\u0627 \u0645\u0627\u0647\u06cc\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0633\u067e\u0633 \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc:<\/p>\n<p>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627:<\/p>\n<p>\u0622\u0646\u0647\u0627 \u0628\u0647 \u0634\u0645\u0627\u0631\u0634 \u062f\u0642\u06cc\u0642 \u0648 \u0642\u0627\u0628\u0644 \u062a\u06a9\u0631\u0627\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u0634\u0627\u0645\u0644 \u062a\u062c\u0645\u06cc\u0639 \u062f\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0628\u0644\u06cc\u0637 \u062e\u0627\u0635 \u0647\u0633\u062a\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0637\u0631\u062d \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062f\u0631 \u0622\u062a\u0646\u0627 \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u0645\u062b\u0627\u0644 \u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc:<\/p>\n<p>&#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221; SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647:<\/p>\n<p>   SELECT departamento, COUNT(*) as total<br \/>\n   FROM tickets<br \/>\n   WHERE estado != &#8216;CLOSED&#8217;<br \/>\n   GROUP BY departamento<br \/>\n   ORDER BY total DESC<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>&#8220;\u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u0644\u062a \u062d\u0648\u0627\u062f\u062b \u062b\u0628\u062a \u0634\u062f\u0647 \u0686\u06cc\u0633\u062a\u061f&#8221; SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647:<\/p>\n<p>   SELECT causante, COUNT(*) as total_incidentes<br \/>\n   FROM tickets<br \/>\n   WHERE solicitudes = &#8216;Incidentes&#8217;<br \/>\n   GROUP BY causante<br \/>\n   ORDER BY total_incidentes DESC<br \/>\n   LIMIT 1<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc:<\/p>\n<p>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627:<\/p>\n<p>\u0622\u0646\u0647\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062a\u0646\u06cc \u0645\u062d\u062a\u0648\u0627\u06cc \u0628\u0644\u06cc\u0637 \u062f\u0627\u0631\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc \u0628\u0647\u0631\u0647 \u0645\u06cc \u0628\u0631\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u062a\u0648\u0633\u0637 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u0646\u0634 \u0628\u0633\u062a\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0645\u062b\u0627\u0644 \u0647\u0627:<\/p>\n<p>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062d\u062a\u0648\u0627\u06cc \u062e\u0627\u0635 \u0628\u0644\u06cc\u0637<br \/>\n\u062e\u0644\u0627\u0635\u0647 \u0645\u0648\u0627\u0631\u062f<br \/>\n\u062a\u0641\u0633\u06cc\u0631 \u0627\u0644\u06af\u0648\u0647\u0627 \u062f\u0631 \u06af\u0632\u0627\u0631\u0634 \u0647\u0627<\/p>\n<p>  \u062c\u0631\u06cc\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634<\/p>\n<p>\u062c\u0631\u06cc\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a\u0645 \u0628\u0631\u0627\u06cc \u0645\u0642\u0627\u0628\u0644\u0647 \u0628\u0627 \u0686\u0627\u0644\u0634 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0645 \u0628\u0647 \u0633\u0647 \u0645\u0631\u062d\u0644\u0647 \u0633\u0627\u062f\u0647 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0627\u0648\u0644\u06cc\u0647<\/p>\n<p>\u0627\u0632 \u0627\u0639\u0644\u0627\u0646 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u06cc\u06cc\u0646 \u0642\u0637\u0639\u06cc \u0628\u0648\u062f\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0648 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0628\u0639\u062f\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u06cc\u062f\u060c \u0645\u0646 \u0627\u0632 \u06cc\u06a9 LLM \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645 \u062a\u0627 \u0628\u062f\u0627\u0646\u0645 \u0622\u06cc\u0627 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u067e\u0631\u0633\u062f \u0645\u0627\u0647\u06cc\u062a \u0642\u0637\u0639\u06cc \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<br \/>\n\u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0642\u0637\u0639\u06cc \u0628\u0627\u0634\u062f\u060c LLM SQL \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u062f\u0631\u0648\u0646 \u062a\u06af \u0647\u0627 \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f . \u0627\u06cc\u0646 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062c\u062f\u0648\u0644 \u0622\u062a\u0646\u0627 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<p>\u062a\u0639\u0642\u06cc\u0628 \u0642\u0636\u0627\u06cc\u06cc<\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc: \u0627\u0632 \u0637\u0631\u06cc\u0642 Athena \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u060c \u0645\u0627 \u06cc\u06a9 SQL \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06cc\u06a9 LLM \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc: \u0622\u0646\u0647\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 Amazon Bedrock &#8211; Knowledge Base \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u0634\u0648\u0646\u062f. \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u0646\u0634 \u062d\u0627\u0648\u06cc \u0647\u0645\u0627\u0646 \u0641\u0627\u06cc\u0644 CSV \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u062f\u0631 \u0622\u062a\u0646\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u067e\u0627\u0633\u062e<\/p>\n<p>\u0646\u062a\u0627\u06cc\u062c \u0622\u062a\u0646\u0627 \u0628\u0647 25 \u0631\u06a9\u0648\u0631\u062f \u0645\u062d\u062f\u0648\u062f \u0634\u062f\u0647 \u0627\u0633\u062a (\u0627\u06cc\u0646 \u0628\u0647 \u0627\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u0646\u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0633\u0624\u0627\u0644\u06cc \u0628\u062a\u0648\u0627\u0646\u062f \u06a9\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f).<br \/>\nLLM \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0646\u062a\u0627\u06cc\u062c \u0628\u0647 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0637\u0628\u06cc\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<br \/>\n\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0632\u0628\u0627\u0646 \u0633\u0624\u0627\u0644 \u0627\u0635\u0644\u06cc \u062d\u0641\u0638 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>  \u0645\u0639\u0645\u0627\u0631\u06cc \u0631\u0627\u0647 \u062d\u0644<\/p>\n<p>\u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u062f\u0647 \u0686\u0627\u0644\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0631\u06a9\u06cc\u0628 \u0627\u0633\u062a\u0631\u0627\u062a\u0698\u06cc\u06a9 \u062e\u062f\u0645\u0627\u062a AWS \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 LLM \u062d\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0631 \u0645\u0648\u0631\u062f \u0647\u0631 \u062c\u0632\u0621 \u0648 \u0627\u062c\u0631\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0622\u0646 \u0628\u062d\u062b \u06a9\u0646\u06cc\u0645.<\/p>\n<p>  1. \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0644\u0627\u06cc\u0647 \u0622\u0645\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc<\/p>\n<p>  1.1 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u0647<\/p>\n<p>\u0627\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0631 \u0631\u0648\u06cc \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 S3 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0633\u0648\u0627\u0628\u0642 \u0628\u0644\u06cc\u0637 \u0627\u0633\u062a. \u062a\u0647\u06cc\u0647 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647:<\/p>\n<p>CREATE EXTERNAL TABLE IF NOT EXISTS `default`.`tickets` (<br \/>\n `fechaResolucion` string,<br \/>\n `asignado` string,<br \/>\n `solicitudes` string,<br \/>\n `producto` string,<br \/>\n `departamento` string,<br \/>\n &#8212; [resto de campos]\n)<br \/>\nCOMMENT &#8220;Tabla de tiquetes de Ejemplo&#8221;<br \/>\nROW FORMAT SERDE &#8216;org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe&#8217;<br \/>\nWITH SERDEPROPERTIES (&#8216;field.delim&#8217; = &#8216;;&#8217;)<br \/>\nSTORED AS INPUTFORMAT &#8216;org.apache.hadoop.mapred.TextInputFormat&#8217;<br \/>\nOUTPUTFORMAT &#8216;org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat&#8217;<br \/>\nLOCATION &#8216;s3:\/\/MiBucket\/&#8217;<br \/>\nTBLPROPERTIES (&#8216;classification&#8217; = &#8216;csv&#8217;);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0627\u06cc\u0646 DDL \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u0632\u06cc\u0631\u0627:<\/p>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0642\u06cc\u0642\u06cc \u0631\u0627 \u06a9\u0647 \u0622\u062a\u0646\u0627 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f\u060c \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u062c\u062f\u0627 \u06a9\u0646\u0646\u062f\u0647 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f ; \u0628\u0631\u0627\u06cc \u062a\u0641\u0633\u06cc\u0631 \u0635\u062d\u06cc\u062d CSV.<br \/>\n\u0645\u062d\u0644 \u0642\u0631\u0627\u0631\u06af\u06cc\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 S3 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u0641\u0631\u0645\u062a \u0648\u0631\u0648\u062f\u06cc\/\u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<p>  1.2 \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/p>\n<p>\u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u0633\u0627\u062e\u062a\u0627\u0631\u060c \u0645\u0627 \u06cc\u06a9 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u062f\u0642\u06cc\u0642 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 LLM \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<p>fechaResolucion: Campo que indica la fecha y hora de resoluci\u00f3n del ticket.<br \/>\n                Formato: mes\/dia\/anno hora:minuto<br \/>\ncausante: Campo categ\u00f3rico que indica si el ticket fue levantado por A o B<br \/>\ndepartamento: Campo calculado descriptivo del departamento que atendi\u00f3<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  2. \u0633\u06cc\u0633\u062a\u0645 \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<\/p>\n<p>  2.1 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc<\/p>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0645\u0647\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u0645 \u0622\u06cc\u0627 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631. \u0645\u0627 \u0627\u06cc\u0646 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 \u062e\u0627\u0635 \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<p>StringBuilder prompt = new StringBuilder(<br \/>\n   &#8220;Eres un experto en an\u00e1lisis de tiquetes, necesito que analices &#8221; +<br \/>\n   &#8220;la pregunta que te indico y si esa pregunta no puede ser respondida &#8221; +<br \/>\n   &#8220;por un LLM (ya que es determin\u00edstica) respondas solamente la frase &#8221; +<br \/>\n   &#8220;&#8216;DETERMINISTICA&#8217; seguido de un SQL dentro de un tag  que cumpla &#8221; +<br \/>\n   &#8220;con la definici\u00f3n de la siguiente tabla de Athena y su glosario&#8230;&#8221;<br \/>\n);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0627\u06cc\u0646 \u0627\u0639\u0644\u0627\u0646 \u062d\u06cc\u0627\u062a\u06cc \u0627\u0633\u062a \u0632\u06cc\u0631\u0627:<\/p>\n<p>\u0646\u0642\u0634 \u062e\u0627\u0635 \u0645\u062f\u0644 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u0642\u0627\u0644\u0628 \u067e\u0627\u0633\u062e \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631 \u062f\u0642\u06cc\u0642 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u0634\u0627\u0645\u0644 \u0632\u0645\u06cc\u0646\u0647 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.<br \/>\n\u06cc\u06a9 \u067e\u0627\u0633\u062e \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0648 \u0639\u0645\u0644\u06cc \u0631\u0627 \u0648\u0627\u062f\u0627\u0631 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>  2.2 \u062a\u0648\u0644\u06cc\u062f SQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 LLM<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u062a\u0634\u062e\u06cc\u0635 \u062f\u0627\u062f \u06a9\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0627\u0633\u062a\u060c SQL \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u0633\u0627\u0644 \u0628\u0647 Athena \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u06cc\u0646 \u0628\u0647 \u0644\u0637\u0641 \u0627\u06cc\u0646 \u0648\u0627\u0642\u0639\u06cc\u062a \u062d\u0627\u0635\u0644 \u0645\u06cc \u0634\u0648\u062f \u06a9\u0647 \u0645\u0627 \u062f\u0631 \u0627\u0639\u0644\u0627\u0646 \u0642\u0628\u0644\u06cc \u062a\u0639\u0631\u06cc\u0641 \u062c\u062f\u0648\u0644 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/p>\n<p>\u062f\u0631 \u0645\u0642\u0627\u0644\u0647 \u0642\u0628\u0644\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Bedrock \u0628\u0627 RDS{:target=&#8221;_blank&#8221;} \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 LLM \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0648 \u062a\u062c\u0631\u0628\u0647 \u0642\u0628\u0644\u06cc \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u0627\u0633\u062a.<\/p>\n<p>  2.2.1 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0648 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u062f\u0644<\/p>\n<p>var message = Message.builder()<br \/>\n      .content(ContentBlock.fromText(prompt.toString()))<br \/>\n      .role(ConversationRole.USER)<br \/>\n      .build();<\/p>\n<p>try {<br \/>\n  var client = BedrockRuntimeClient.builder()<br \/>\n      .credentialsProvider(DefaultCredentialsProvider.create())<br \/>\n      .region(Region.US_EAST_1)<br \/>\n      .build();<\/p>\n<p>  \/\/ Send the message with a basic inference configuration.<br \/>\n  ConverseResponse response = client.converse(request -&gt; request<br \/>\n          .modelId(FOUNDATIONAL_MODEL)<br \/>\n          .messages(message)<br \/>\n          .inferenceConfig(config -&gt; config<br \/>\n                  .maxTokens(512)    \/\/ Suficiente para consultas SQL complejas<br \/>\n                  .temperature(0.5F) \/\/ Bajo para mayor precisi\u00f3n<br \/>\n                  .topP(0.9F)));     \/\/ Alta coherencia en la estructura<\/p>\n<p>  \/\/ Retrieve the generated text from Bedrock&#8217;s response object.<br \/>\n  var responseText = response.output().message().content().get(0).text();<br \/>\n  client.close();<\/p>\n<p>  return responseText;<\/p>\n<p>} catch (SdkClientException e) {<br \/>\n  System.err.printf(&#8220;ERROR: Can&#8217;t invoke &#8216;%s&#8217;. Reason: %s&#8221;, FOUNDATIONAL_MODEL, e.getMessage());<br \/>\n  return &#8220;No se puede responder esa pregunta&#8221;;<br \/>\n}<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  2.2.2 \u0645\u062b\u0627\u0644 \u062c\u0631\u06cc\u0627\u0646 \u06a9\u0627\u0645\u0644<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0646 \u0627\u06cc\u0646 \u0631\u0648\u0646\u062f\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0633\u0648\u0627\u0644 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u0645: &#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221;<\/p>\n<p>\u0648\u0631\u0648\u062f\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0645\u062f\u0644:<\/p>\n[Todo el contexto anterior + schema + diccionario]\nPregunta: \u00bfCu\u00e1l departamento tiene m\u00e1s tickets abiertos?<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<p>SELECT<br \/>\n   departamento,<br \/>\n   COUNT(*) as total_tickets<br \/>\nFROM tickets<br \/>\nWHERE fechaResolucion IS NULL<br \/>\nGROUP BY departamento<br \/>\nORDER BY total_tickets DESC<br \/>\nLIMIT 25<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627 \u0628\u0647 \u0622\u062a\u0646\u0627 \u0641\u0631\u0633\u062a\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0648\u0627\u0642\u0639\u06cc\u062a \u06a9\u0647 \u0645\u062f\u0644 \u0627\u0632 \u0642\u0628\u0644 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0642\u06cc\u0642 \u062c\u062f\u0648\u0644 \u0648 \u0645\u0639\u0646\u0627\u06cc \u0647\u0631 \u0641\u06cc\u0644\u062f \u0631\u0627 \u0628\u0647 \u0644\u0637\u0641 \u0632\u0645\u06cc\u0646\u0647 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0645\u06cc \u062f\u0627\u0646\u062f.<\/p>\n<p>\u06a9\u0644\u06cc\u062f \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062f\u0631 \u062f\u0642\u062a \u0632\u0645\u06cc\u0646\u0647 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0628\u0647 \u0645\u062f\u0644 \u0648 \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0631 \u0642\u0627\u0644\u0628 \u067e\u0627\u0633\u062e \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u06cc \u0646\u0647\u0641\u062a\u0647 \u0627\u0633\u062a\u060c \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u062a\u0648\u0644\u06cc\u062f \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u062f\u0642\u06cc\u0642\u0627\u064b \u0628\u0627 \u0637\u0631\u062d \u0645\u0627 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f.<\/p>\n<p>  3. \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc<\/p>\n<p>  3.1 \u0627\u062c\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627\u06cc \u0622\u062a\u0646\u0627<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0634\u062f\u060c \u0633\u06cc\u0633\u062a\u0645 SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<p>public String executeAthenaQuery(String query, String database) {<br \/>\n try (AthenaClient athenaClient = AthenaClient.builder()<br \/>\n   .region(Region.US_EAST_1) \/\/ Ajusta la regi\u00f3n seg\u00fan tu configuraci\u00f3n<br \/>\n   .credentialsProvider(DefaultCredentialsProvider.create())<br \/>\n   .build()) {<\/p>\n<p>   \/\/ Configurar la solicitud de consulta<br \/>\n   StartQueryExecutionRequest startQueryExecutionRequest = StartQueryExecutionRequest.builder()<br \/>\n     .queryString(query)<br \/>\n     .queryExecutionContext(QueryExecutionContext.builder()<br \/>\n       .database(database)<br \/>\n       .build())<br \/>\n     .resultConfiguration(ResultConfiguration.builder()<br \/>\n       .build())<br \/>\n     .build();<\/p>\n<p>   \/\/ Iniciar la consulta<br \/>\n   StartQueryExecutionResponse startQueryExecutionResponse = athenaClient.startQueryExecution(startQueryExecutionRequest);<br \/>\n   String queryExecutionId = startQueryExecutionResponse.queryExecutionId();<\/p>\n<p>   \/\/ Esperar a que la consulta termine<br \/>\n   waitForQueryToComplete(athenaClient, queryExecutionId);<\/p>\n<p>   \/\/ Obtener los resultados de la consulta<br \/>\n   return getQueryResults(athenaClient, queryExecutionId);<\/p>\n<p> } catch (Exception e) {<br \/>\n   e.printStackTrace();<br \/>\n   throw new RuntimeException(&#8220;Error executing Athena query&#8221;, e);<br \/>\n }<br \/>\n}<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0627\u06cc\u0646 \u06a9\u062f:<\/p>\n<p>\u0627\u0631\u062a\u0628\u0627\u0637 \u0627\u06cc\u0645\u0646 \u0628\u0627 \u0622\u062a\u0646\u0627 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.<br \/>\n\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0646\u0627\u0647\u0645\u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u0634\u0646\u0627\u0633\u0647 \u0627\u062c\u0631\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u06a9\u0646\u062a\u0631\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  4. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u067e\u0627\u0633\u062e<\/p>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0634\u0627\u0645\u0644 \u062a\u0628\u062f\u06cc\u0644 \u0646\u062a\u0627\u06cc\u062c \u0641\u0646\u06cc \u0628\u0647 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0642\u0627\u0628\u0644 \u062f\u0631\u06a9 \u0627\u0633\u062a:<\/p>\n<p>StringBuilder prompt = new StringBuilder(<br \/>\n   &#8220;Eres un experto en atenci\u00f3n a consultas, debes responder &#8221; +<br \/>\n   &#8220;de manera profesional, concisa y clara. La pregunta realizada fue &#8221; +<br \/>\n   preguntaUsuario + &#8221; y la respuesta de la base de datos es: &#8221; +<br \/>\n   respuestaBD);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0627\u06cc\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc:<\/p>\n<p>\u0632\u0645\u06cc\u0646\u0647 \u0633\u0648\u0627\u0644 \u0627\u0635\u0644\u06cc \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u067e\u0627\u0633\u062e \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0637\u0628\u06cc\u0639\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0647\u06cc\u062f.<br \/>\n\u062f\u0642\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0645\u062f\u0647 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  5. \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u062a\u0634\u062e\u06cc\u0635 \u0645\u06cc \u062f\u0647\u062f\u060c \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062a\u0646\u06cc \u06cc\u0627 \u062a\u0641\u0633\u06cc\u0631\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0633\u062a\u0642\u06cc\u0645 SQL \u0642\u0627\u0628\u0644 \u062d\u0644 \u0646\u06cc\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a\u060c \u0633\u06cc\u0633\u062a\u0645 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u0645\u062f\u0644 Anthropic \u0628\u0631\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  5.1 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u067e\u0631\u062f\u0627\u0632\u0634<\/p>\n<p>\u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f\u060c \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u062f\u0644 \u06a9\u0644\u0645\u0647 &#8220;DETERMINISTIC&#8221; \u0648 \u0633\u067e\u0633 \u06cc\u06a9 SQL \u0631\u0627 \u0628\u0631 \u0646\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a\u060c \u0633\u06cc\u0633\u062a\u0645 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062f\u0644 Bedrock \u0628\u0647 \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc\u200c\u067e\u0631\u062f\u0627\u0632\u062f.<\/p>\n<p>  5.2 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0645\u062f\u0644<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u067e\u0631\u0633\u0634\u200c\u0647\u0627\u060c \u0627\u0632 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u067e\u0627\u06cc\u0647 \u0645\u062f\u0644 Anthropic Sonnet 3.5 v2 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/p>\n<p>RetrieveAndGenerateInput input = RetrieveAndGenerateInput.builder()<br \/>\n        .text(prompt)<br \/>\n        .build();<\/p>\n<p>KnowledgeBaseRetrieveAndGenerateConfiguration knowledgeConfig = KnowledgeBaseRetrieveAndGenerateConfiguration<br \/>\n        .builder()<br \/>\n        .knowledgeBaseId(KNOWLEDGE_BASE_ID)<br \/>\n        .modelArn(MODEL_ARN)<br \/>\n        .build();<\/p>\n<p>RetrieveAndGenerateConfiguration retrieveConfig = RetrieveAndGenerateConfiguration.builder()<br \/>\n        .knowledgeBaseConfiguration(knowledgeConfig)<br \/>\n        .type(&#8220;KNOWLEDGE_BASE&#8221;)<br \/>\n        .build();<\/p>\n<p>RetrieveAndGenerateRequest request1 = RetrieveAndGenerateRequest.builder()<br \/>\n        .retrieveAndGenerateConfiguration(retrieveConfig)<br \/>\n        .input(input)<br \/>\n        .build();<\/p>\n<p>RetrieveAndGenerateResponse response1 = bedrockAgentRuntimeClient.retrieveAndGenerate(request1);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  5.3 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0647 \u0635\u0648\u0631\u062a \u062a\u0641\u0633\u06cc\u0631\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<p>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062d\u062a\u0648\u0627:<\/p>\n<p>  Pregunta: &#8220;\u00bfCu\u00e1les son los patrones comunes en los tickets de error de conexi\u00f3n?&#8221;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u062a\u0641\u0633\u06cc\u0631 \u067e\u0631\u0648\u0646\u062f\u0647:<\/p>\n<p>  Pregunta: &#8220;\u00bfC\u00f3mo se resolvi\u00f3 un caso similar la \u00faltima vez?&#8221;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u062e\u0644\u0627\u0635\u0647 \u0647\u0627\u06cc \u0645\u062a\u0646\u06cc:<\/p>\n<p>  Pregunta: &#8220;Resume el problema principal del ticket #12345&#8221;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0627\u0631\u062f \u0633\u06cc\u0633\u062a\u0645:<\/p>\n<p>\u062a\u0644\u0627\u0634\u06cc \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0646\u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u062f\u0644 \u067e\u0631\u062f\u0627\u0632\u0634 \u06a9\u0646\u06cc\u062f.<br \/>\n\u067e\u0627\u0633\u062e\u06cc \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0632\u0645\u06cc\u0646\u0647 \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u062c\u0648\u062f \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<br \/>\n\u0642\u0627\u0644\u0628 \u0648 \u0644\u062d\u0646 \u0631\u0627 \u0628\u0627 \u0633\u0648\u0627\u0644 \u0627\u0635\u0644\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0647\u06cc\u062f.<\/p>\n<p>\u067e\u0627\u0633\u062e \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u062a\u062d\u0648\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0627\u0647\u06cc\u062a \u0645\u06a9\u0627\u0644\u0645\u0647 \u0648 \u0632\u0645\u06cc\u0646\u0647 \u0633\u0624\u0627\u0644 \u0627\u0635\u0644\u06cc \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>  \u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc \u0648 \u0645\u0631\u0627\u062d\u0644 \u0628\u0639\u062f\u06cc<\/p>\n<p>\u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0627\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645 \u062a\u0631\u06a9\u06cc\u0628\u06cc\u060c \u06a9\u0647 \u062f\u0642\u062a \u067e\u0631\u0633\u0634\u200c\u0647\u0627\u06cc SQL \u0631\u0627 \u0628\u0627 \u0638\u0631\u0641\u06cc\u062a \u062a\u0641\u0633\u06cc\u0631\u06cc \u0645\u062f\u0644\u200c\u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0646\u0634\u0627\u0646\u200c\u062f\u0647\u0646\u062f\u0647 \u0634\u0631\u0648\u0639\u06cc \u0627\u0633\u062a \u0627\u0632 \u0622\u0646\u0686\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u0648\u0644\u062f \u062f\u0631 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f.<\/p>\n<p>  \u0628\u0627\u0632\u062a\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc<\/p>\n<p>\u062a\u0645\u0627\u06cc\u0632 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u06cc\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc \u0648 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0647\u0631 \u062f\u0648 \u062c\u0647\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645: \u062f\u0631\u0633\u062a\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0648 \u062f\u0631\u06a9 \u0645\u062a\u0646\u06cc LLM.<br \/>\n\u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u062f\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u062f\u0642\u062a \u0644\u0627\u0632\u0645 \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u062d\u0641\u0638 \u06a9\u0631\u062f \u0648 \u062f\u0631 \u0639\u06cc\u0646 \u062d\u0627\u0644 \u062a\u062c\u0631\u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0642\u0627\u0628\u0644\u200c\u062a\u0648\u062c\u0647\u06cc \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u06cc\u062f.<br \/>\n\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062e\u062f\u0645\u0627\u062a \u0645\u062f\u0631\u0646 \u0645\u0627\u0646\u0646\u062f Amazon Bedrock \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0631\u0627 \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0632\u06cc\u0631\u0633\u0627\u062e\u062a \u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0648 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062a\u0631\u06cc\u0646 LLM \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0645\u0646 \u0627\u0632 \u0634\u0645\u0627 \u062f\u0639\u0648\u062a \u0645\u06cc \u06a9\u0646\u0645 \u06a9\u0647 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0648\u0634 \u0647\u0627\u06cc \u062e\u0648\u062f \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0686\u0647 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0628\u0647\u0628\u0648\u062f \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u06cc\u0637 \u062e\u0648\u062f \u0628\u0627\u0634\u06cc\u062f\u060c \u0686\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0645\u0641\u0627\u0647\u06cc\u0645 \u0631\u0627 \u062f\u0631 \u062d\u0648\u0632\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0647 \u06a9\u0627\u0631 \u0628\u0628\u0631\u06cc\u062f\u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u062a \u0628\u0633\u06cc\u0627\u0631 \u0632\u06cc\u0627\u062f \u0627\u0633\u062a.<\/p>\n<p>GenAI \u0646\u062d\u0648\u0647 \u062a\u0639\u0627\u0645\u0644 \u0645\u0627 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u062f \u0648 \u0645\u0646 \u0647\u06cc\u062c\u0627\u0646 \u0632\u062f\u0647 \u0647\u0633\u062a\u0645 \u06a9\u0647 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u062a\u062d\u0648\u0644 \u0628\u0627\u0634\u0645. \u0622\u06cc\u0627 \u0634\u0645\u0627 \u0647\u0645 \u062c\u0631\u0627\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0628\u062e\u0634\u06cc \u0627\u0632 \u0622\u0646 \u0628\u0627\u0634\u06cc\u062f\u061f<\/p>\n<div data-article-id=\"2127494\" id=\"article-body\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D9%85%D9%82%D8%AF%D9%85%D9%87\" >\u0645\u0642\u062f\u0645\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%DA%86%D8%A7%D9%84%D8%B4_%D9%85%D8%AF%D9%84_%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\" >\u0686\u0627\u0644\u0634 \u0645\u062f\u0644 \u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D9%85%D8%A8%D8%A7%D9%86%DB%8C_%D8%B9%D9%85%D9%84%DB%8C%D8%A7%D8%AA_LLM\" >\u0645\u0628\u0627\u0646\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a LLM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%B2%D9%85%DB%8C%D9%86%D9%87_%D8%A7%D8%B2_%DB%8C%DA%A9_POC_%D8%B4%DA%A9%D8%B3%D8%AA_%D8%AE%D9%88%D8%B1%D8%AF%D9%87_%D8%AA%D8%A7_%DB%8C%DA%A9_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84_%D9%86%D9%88%D8%A2%D9%88%D8%B1%D8%A7%D9%86%D9%87\" >\u0632\u0645\u06cc\u0646\u0647: \u0627\u0632 \u06cc\u06a9 POC \u0634\u06a9\u0633\u062a \u062e\u0648\u0631\u062f\u0647 \u062a\u0627 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0646\u0648\u0622\u0648\u0631\u0627\u0646\u0647<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%DA%86%D9%87_%DA%86%DB%8C%D8%B2%DB%8C_%D8%AE%D9%88%D8%A8_%DA%A9%D8%A7%D8%B1_%DA%A9%D8%B1%D8%AF\" >\u0686\u0647 \u0686\u06cc\u0632\u06cc \u062e\u0648\u0628 \u06a9\u0627\u0631 \u06a9\u0631\u062f:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%A2%D9%86%DA%86%D9%87_%D8%A8%D9%87_%D8%B7%D9%88%D8%B1_%D9%85%D8%AF%D8%A7%D9%88%D9%85_%D8%B4%DA%A9%D8%B3%D8%AA_%D9%85%DB%8C_%D8%AE%D9%88%D8%B1%D8%AF\" >\u0622\u0646\u0686\u0647 \u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062e\u0648\u0631\u062f:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D9%85%DA%A9%D8%A7%D8%B4%D9%81%D9%87_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\" >\u0645\u06a9\u0627\u0634\u0641\u0647 \u06a9\u0644\u06cc\u062f\u06cc<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%B4%DA%A9%D8%A7%D9%81_%D8%A8%DB%8C%D9%86_%D8%AF%D9%82%D8%AA_%D9%88_%D8%A7%D8%AD%D8%AA%D9%85%D8%A7%D9%84_%D9%BE%DB%8C%D8%A7%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\" >\u0634\u06a9\u0627\u0641 \u0628\u06cc\u0646 \u062f\u0642\u062a \u0648 \u0627\u062d\u062a\u0645\u0627\u0644: \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0631\u0627\u0647 \u062d\u0644<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\" >\u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%AC%D8%B1%DB%8C%D8%A7%D9%86_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4\" >\u062c\u0631\u06cc\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D9%85%D8%B9%D9%85%D8%A7%D8%B1%DB%8C_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\" >\u0645\u0639\u0645\u0627\u0631\u06cc \u0631\u0627\u0647 \u062d\u0644<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#1_%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D9%88_%D9%84%D8%A7%DB%8C%D9%87_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C\" >1. \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0644\u0627\u06cc\u0647 \u0622\u0645\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#11_%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D9%BE%D8%A7%DB%8C%D9%87\" >1.1 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#12_%D8%AF%DB%8C%DA%A9%D8%B4%D9%86%D8%B1%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7\" >1.2 \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#2_%D8%B3%DB%8C%D8%B3%D8%AA%D9%85_%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\" >2. \u0633\u06cc\u0633\u062a\u0645 \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#21_%D8%AF%D8%B1%D8%AE%D9%88%D8%A7%D8%B3%D8%AA_%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C\" >2.1 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#22_%D8%AA%D9%88%D9%84%DB%8C%D8%AF_SQL_%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_LLM\" >2.2 \u062a\u0648\u0644\u06cc\u062f SQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 LLM<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#221_%D9%BE%DB%8C%DA%A9%D8%B1%D8%A8%D9%86%D8%AF%DB%8C_%D9%88_%D9%81%D8%B1%D8%A7%D8%AE%D9%88%D8%A7%D9%86%DB%8C_%D9%85%D8%AF%D9%84\" >2.2.1 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0648 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u062f\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#222_%D9%85%D8%AB%D8%A7%D9%84_%D8%AC%D8%B1%DB%8C%D8%A7%D9%86_%DA%A9%D8%A7%D9%85%D9%84\" >2.2.2 \u0645\u062b\u0627\u0644 \u062c\u0631\u06cc\u0627\u0646 \u06a9\u0627\u0645\u0644<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#3_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%82%D8%B7%D8%B9%DB%8C\" >3. \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#31_%D8%A7%D8%AC%D8%B1%D8%A7%DB%8C_%DA%A9%D9%88%D8%A6%D8%B1%DB%8C_%D9%87%D8%A7%DB%8C_%D8%A2%D8%AA%D9%86%D8%A7\" >3.1 \u0627\u062c\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627\u06cc \u0622\u062a\u0646\u0627<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#4_%D9%82%D8%A7%D9%84%D8%A8_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%A7%D8%B3%D8%AE\" >4. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u067e\u0627\u0633\u062e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#5_%D8%B1%D8%B3%DB%8C%D8%AF%DA%AF%DB%8C_%D8%A8%D9%87_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\" >5. \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#51_%D8%B4%D9%86%D8%A7%D8%B3%D8%A7%DB%8C%DB%8C_%D9%88_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4\" >5.1 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u067e\u0631\u062f\u0627\u0632\u0634<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#52_%D9%BE%DB%8C%DA%A9%D8%B1%D8%A8%D9%86%D8%AF%DB%8C_%D9%85%D8%AF%D9%84\" >5.2 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0645\u062f\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#53_%D9%86%D9%85%D9%88%D9%86%D9%87_%D9%87%D8%A7%DB%8C%DB%8C_%D8%A7%D8%B2_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\" >5.3 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87_%DA%AF%DB%8C%D8%B1%DB%8C_%D9%88_%D9%85%D8%B1%D8%A7%D8%AD%D9%84_%D8%A8%D8%B9%D8%AF%DB%8C\" >\u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc \u0648 \u0645\u0631\u0627\u062d\u0644 \u0628\u0639\u062f\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/nabfollower.com\/blog\/resolviendo-preguntas-deterministicas-con-ia-generativa-un-enfoque-practico-2oho\/#%D8%A8%D8%A7%D8%B2%D8%AA%D8%A7%D8%A8_%D9%87%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\" >\u0628\u0627\u0632\u062a\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D9%82%D8%AF%D9%85%D9%87\"><\/span>\n<p>  \u0645\u0642\u062f\u0645\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u067e\u0648\u06cc\u0627 \u0645\u0648\u0644\u062f \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0627\u0645\u0631\u0648\u0632\u06cc\u060c \u0645\u062f\u0644 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0632\u0631\u06af (LLM) \u062a\u0639\u0627\u0645\u0644 \u0645\u0627 \u0628\u0627 \u0641\u0646\u0627\u0648\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0634\u062f\u062a \u0645\u062a\u062d\u0648\u0644 \u06a9\u0631\u062f\u0647 \u0627\u0646\u062f. \u0627\u06cc\u0646 \u0645\u062f\u0644\u200c\u0647\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u062b\u0646\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u062a\u0648\u0644\u06cc\u062f \u0645\u062a\u0646\u060c \u062a\u062d\u0644\u06cc\u0644 \u0627\u062d\u0633\u0627\u0633\u0627\u062a \u0648 \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647\u200c\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0627\u0646\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u0627 \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627\u06cc\u06cc \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645 \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0645\u0646\u062f \u062f\u0642\u062a \u0645\u0637\u0644\u0642 \u0648 \u0646\u062a\u0627\u06cc\u062c \u0642\u0637\u0639\u06cc \u0647\u0633\u062a\u0646\u062f\u060c \u0628\u0627 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u0630\u0627\u062a\u06cc \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0646\u0648\u0622\u0648\u0631\u0627\u0646\u0647 \u0645\u0648\u0631\u062f \u062a\u0648\u062c\u0647 \u0642\u0631\u0627\u0631 \u06af\u06cc\u0631\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%DA%86%D8%A7%D9%84%D8%B4_%D9%85%D8%AF%D9%84_%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\"><\/span>\n<p>  \u0686\u0627\u0644\u0634 \u0645\u062f\u0644 \u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%A8%D8%A7%D9%86%DB%8C_%D8%B9%D9%85%D9%84%DB%8C%D8%A7%D8%AA_LLM\"><\/span>\n<p>  \u0645\u0628\u0627\u0646\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a LLM<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u062f\u0644\u200c\u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0632\u0631\u06af \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0627\u062d\u062a\u0645\u0627\u0644\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u062f\u0631 \u0647\u0633\u062a\u0647 \u062e\u0648\u062f\u060c \u0627\u06cc\u0646 \u0645\u062f\u0644 \u0647\u0627:<\/p>\n<ol>\n<li>\n<strong>\u067e\u06cc\u0634\u200c\u0628\u06cc\u0646\u06cc \u0645\u062a\u0646\u06cc<\/strong>: \u0622\u0646\u0647\u0627 \u0632\u0645\u06cc\u0646\u0647 \u0642\u0628\u0644\u06cc \u0631\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u0646\u062f \u062a\u0627 \u0645\u062d\u062a\u0645\u0644 \u062a\u0631\u06cc\u0646 \u06a9\u0644\u0645\u0647 \u06cc\u0627 \u062f\u0646\u0628\u0627\u0644\u0647 \u0628\u0639\u062f\u06cc \u0631\u0627 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u06a9\u0646\u0646\u062f.<\/li>\n<li>\n<strong>\u062a\u0648\u0632\u06cc\u0639 \u0627\u062d\u062a\u0645\u0627\u0644<\/strong>: \u0622\u0646\u0647\u0627 \u06cc\u06a9 \u062a\u0648\u0632\u06cc\u0639 \u0627\u062d\u062a\u0645\u0627\u0644 \u0628\u0631\u0627\u06cc \u06af\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u067e\u0627\u0633\u062e \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/li>\n<li>\n<strong>\u062f\u0645\u0627 \u0648 \u062a\u0635\u0627\u062f\u0641\u06cc \u0628\u0648\u062f\u0646<\/strong>: \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u062f\u0645\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0646\u062a\u0631\u0644 \u062e\u0644\u0627\u0642\u06cc\u062a \u062f\u0631 \u0645\u0642\u0627\u0628\u0644. \u062c\u0628\u0631 \u062f\u0631 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0622\u0646\u0647\u0627<\/li>\n<\/ol>\n<p>\u0627\u06cc\u0646 \u0645\u0627\u0647\u06cc\u062a \u0627\u062d\u062a\u0645\u0627\u0644\u06cc \u062f\u0642\u06cc\u0642\u0627\u064b \u0647\u0645\u0627\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 LLM \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0647\u0627\u06cc \u062e\u0644\u0627\u0642\u0627\u0646\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0645\u062a\u0646\u0648\u0639 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0642\u062a \u0639\u062f\u062f\u06cc \u06cc\u0627 \u062f\u0642\u062a \u0645\u0637\u0644\u0642 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f \u06a9\u0645\u062a\u0631 \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B2%D9%85%DB%8C%D9%86%D9%87_%D8%A7%D8%B2_%DB%8C%DA%A9_POC_%D8%B4%DA%A9%D8%B3%D8%AA_%D8%AE%D9%88%D8%B1%D8%AF%D9%87_%D8%AA%D8%A7_%DB%8C%DA%A9_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84_%D9%86%D9%88%D8%A2%D9%88%D8%B1%D8%A7%D9%86%D9%87\"><\/span>\n<p>  \u0632\u0645\u06cc\u0646\u0647: \u0627\u0632 \u06cc\u06a9 POC \u0634\u06a9\u0633\u062a \u062e\u0648\u0631\u062f\u0647 \u062a\u0627 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0646\u0648\u0622\u0648\u0631\u0627\u0646\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0637\u06cc \u0686\u0646\u062f \u0645\u0627\u0647 \u06af\u0630\u0634\u062a\u0647\u060c \u062f\u0631 \u062d\u06cc\u0646 \u0627\u0646\u062c\u0627\u0645 \u0686\u0646\u062f\u06cc\u0646 \u06af\u0641\u062a\u06af\u0648 \u062f\u0631 \u0645\u0648\u0631\u062f \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc Generative\u060c \u06cc\u06a9 \u0645\u06a9\u0627\u0644\u0645\u0647 \u062e\u0627\u0635 \u062a\u0648\u062c\u0647 \u0645\u0646 \u0631\u0627 \u0628\u0647 \u062e\u0648\u062f \u062c\u0644\u0628 \u06a9\u0631\u062f. \u06cc\u06a9 \u062a\u06cc\u0645 \u062a\u0648\u0633\u0639\u0647 \u0646\u0627\u0631\u0636\u0627\u06cc\u062a\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0627\u062b\u0628\u0627\u062a \u0645\u0641\u0647\u0648\u0645\u06cc (POC) \u06a9\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0622\u0646\u0647\u0627 \u0646\u0627\u0645\u0648\u0641\u0642 \u0628\u0648\u062f\u060c \u0628\u0627 \u0645\u0646 \u062f\u0631 \u0645\u06cc\u0627\u0646 \u06af\u0630\u0627\u0634\u062a\u0646\u062f. \u0645\u0634\u06a9\u0644: \u0627\u062c\u0631\u0627\u06cc \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u0648\u0644\u062f \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u06cc\u0637 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u062a\u0627\u06cc\u062c \u0645\u062a\u0646\u0627\u0642\u0636\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f.<\/p>\n<p>\u0628\u0627 \u062d\u0641\u0627\u0631\u06cc \u0639\u0645\u06cc\u0642 \u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f\u060c \u06cc\u06a9 \u0627\u0644\u06af\u0648\u06cc \u062c\u0627\u0644\u0628 \u0638\u0627\u0647\u0631 \u0634\u062f:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%DA%86%D9%87_%DA%86%DB%8C%D8%B2%DB%8C_%D8%AE%D9%88%D8%A8_%DA%A9%D8%A7%D8%B1_%DA%A9%D8%B1%D8%AF\"><\/span>\n<p>  \u0686\u0647 \u0686\u06cc\u0632\u06cc \u062e\u0648\u0628 \u06a9\u0627\u0631 \u06a9\u0631\u062f:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>&#8220;\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u06cc\u06a9\u062a \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc X&#8221;<\/li>\n<li>&#8220;\u062e\u0644\u0627\u0635\u0647 \u0645\u0648\u0631\u062f Y \u0686\u06cc\u0633\u062a\u061f&#8221;<\/li>\n<li>&#8220;\u0627\u06cc\u0646 \u06af\u0632\u0627\u0631\u0634 \u062d\u0627\u062f\u062b\u0647 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f\u061f&#8221;<\/li>\n<\/ul>\n<p>\u0627\u06cc\u0646 \u0633\u0648\u0627\u0644\u0627\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0645\u0646\u062f \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647 \u0627\u06cc \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u06cc\u0641\u06cc \u0628\u0648\u062f\u0646\u062f\u060c \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0648 \u0645\u0641\u06cc\u062f\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D8%A2%D9%86%DA%86%D9%87_%D8%A8%D9%87_%D8%B7%D9%88%D8%B1_%D9%85%D8%AF%D8%A7%D9%88%D9%85_%D8%B4%DA%A9%D8%B3%D8%AA_%D9%85%DB%8C_%D8%AE%D9%88%D8%B1%D8%AF\"><\/span>\n<p>  \u0622\u0646\u0686\u0647 \u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062e\u0648\u0631\u062f:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>&#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221;<\/li>\n<li>\u0645\u0627\u0647 \u06af\u0630\u0634\u062a\u0647 \u0628\u0647 \u0686\u0646\u062f \u0628\u0644\u06cc\u0637 \u067e\u0627\u0633\u062e \u062f\u0627\u062f\u0647 \u0634\u062f\u061f<\/li>\n<li>&#8220;\u0645\u062a\u0648\u0633\u0637 \u200b\u200b\u0632\u0645\u0627\u0646 \u062a\u0641\u06a9\u06cc\u06a9 \u0686\u0642\u062f\u0631 \u0627\u0633\u062a\u061f&#8221;<\/li>\n<\/ul>\n<p>\u0633\u0648\u0627\u0644\u0627\u062a\u06cc \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0642\u062a \u0639\u062f\u062f\u06cc \u0648 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u062f\u0627\u0634\u062a\u0646\u062f\u060c \u0647\u0631\u06af\u0632 \u0646\u062a\u0627\u06cc\u062c \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f\u06cc \u0627\u0631\u0627\u0626\u0647 \u0646\u06a9\u0631\u062f\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%DA%A9%D8%A7%D8%B4%D9%81%D9%87_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\"><\/span>\n<p>  \u0645\u06a9\u0627\u0634\u0641\u0647 \u06a9\u0644\u06cc\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u062f\u0644\u06cc\u0644 \u0634\u06a9\u0633\u062a \u0632\u0645\u0627\u0646\u06cc \u0622\u0634\u06a9\u0627\u0631 \u0634\u062f \u06a9\u0647 \u0645\u0627\u0647\u06cc\u062a \u0627\u0633\u0627\u0633\u06cc LLM \u0647\u0627 \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0631\u062f\u06cc\u0645: \u0622\u0646\u0647\u0627 \u0630\u0627\u062a\u0627 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u0647\u0633\u062a\u0646\u062f. \u0646\u0642\u0637\u0647 \u0642\u0648\u062a \u0622\u0646 \u062f\u0631 \u067e\u0631\u062f\u0627\u0632\u0634 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc \u0648 \u062a\u0648\u0644\u06cc\u062f \u0645\u062d\u062a\u0648\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0627\u062d\u062a\u0645\u0627\u0644 \u0627\u0633\u062a\u060c \u0646\u0647 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u06cc\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647.<\/p>\n<p>\u0627\u06cc\u0646 \u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u0645\u0646 \u0631\u0627 \u0628\u0631 \u0622\u0646 \u062f\u0627\u0634\u062a \u062a\u0627 \u067e\u0631\u0633\u0634 \u06a9\u0644\u06cc\u062f\u06cc \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0641\u0631\u0645\u0648\u0644\u0647 \u06a9\u0646\u0645:<\/p>\n<blockquote>\n<p>\u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u0633\u0624\u0627\u0644\u0627\u062a \u0642\u0637\u0639\u06cc \u067e\u0627\u0633\u062e \u062f\u0647\u06cc\u0645 \u0648\u0642\u062a\u06cc \u06a9\u0647 \u06cc\u06a9 LLM\u060c \u0628\u0646\u0627 \u0628\u0647 \u0645\u0627\u0647\u06cc\u062a \u062e\u0648\u062f\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0637\u0631\u0627\u062d\u06cc \u0646\u0634\u062f\u0647 \u0627\u0633\u062a\u061f<\/p>\n<\/blockquote>\n<p>\u067e\u0627\u0633\u062e \u0627\u0632 \u062f\u0631\u06a9 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0628\u0648\u062f \u06a9\u0647 \u0645\u0627 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0648\u0627\u062f\u0627\u0631 \u06a9\u0631\u062f\u0646 LLM \u0628\u0647 \u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0637\u0631\u0627\u062d\u06cc \u0646\u0634\u062f\u0647 \u0628\u0648\u062f\u060c \u0628\u0647 \u062f\u0633\u062a \u0622\u0645\u062f. \u062f\u0631 \u0639\u0648\u0636\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645:<\/p>\n<ol>\n<li>\u0627\u0632 LLM \u0628\u0631\u0627\u06cc \u0628\u0647\u062a\u0631\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f: \u0647\u062f\u0641 \u0633\u0648\u0627\u0644 \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0635\u0648\u0631\u062a \u0644\u0632\u0648\u0645 \u0622\u0646 \u0647\u062f\u0641 \u0631\u0627 \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u062a\u0631\u062c\u0645\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u0632 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062e\u0635\u0635\u06cc \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0642\u06cc\u0642 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0646\u0633\u062c\u0645 \u0648 \u0637\u0628\u06cc\u0639\u06cc \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B4%DA%A9%D8%A7%D9%81_%D8%A8%DB%8C%D9%86_%D8%AF%D9%82%D8%AA_%D9%88_%D8%A7%D8%AD%D8%AA%D9%85%D8%A7%D9%84_%D9%BE%DB%8C%D8%A7%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\"><\/span>\n<p>  \u0634\u06a9\u0627\u0641 \u0628\u06cc\u0646 \u062f\u0642\u062a \u0648 \u0627\u062d\u062a\u0645\u0627\u0644: \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0631\u0627\u0647 \u062d\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0647\u0633\u062a\u0647 \u0627\u0635\u0644\u06cc \u0645\u0634\u06a9\u0644 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0634\u062f\u060c \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0645 \u06a9\u0647 \u0627\u0628\u062a\u062f\u0627 \u0645\u0627\u0647\u06cc\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0633\u067e\u0633 \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\"><\/span>\n<p>  \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc:<\/strong><\/p>\n<p>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627:<\/p>\n<ul>\n<li>\u0622\u0646\u0647\u0627 \u0628\u0647 \u0634\u0645\u0627\u0631\u0634 \u062f\u0642\u06cc\u0642 \u0648 \u0642\u0627\u0628\u0644 \u062a\u06a9\u0631\u0627\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u0634\u0627\u0645\u0644 \u062a\u062c\u0645\u06cc\u0639 \u062f\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0628\u0644\u06cc\u0637 \u062e\u0627\u0635 \u0647\u0633\u062a\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0637\u0631\u062d \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062f\u0631 \u0622\u062a\u0646\u0627 \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0645\u062b\u0627\u0644 \u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc:<\/p>\n<ol>\n<li>&#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221; SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code>   <span class=\"k\">SELECT<\/span> <span class=\"n\">departamento<\/span><span class=\"p\">,<\/span> <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">total<\/span>\n   <span class=\"k\">FROM<\/span> <span class=\"n\">tickets<\/span>\n   <span class=\"k\">WHERE<\/span> <span class=\"n\">estado<\/span> <span class=\"o\">!=<\/span> <span class=\"s1\">'CLOSED'<\/span>\n   <span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">departamento<\/span>\n   <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">total<\/span> <span class=\"k\">DESC<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>&#8220;\u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u0644\u062a \u062d\u0648\u0627\u062f\u062b \u062b\u0628\u062a \u0634\u062f\u0647 \u0686\u06cc\u0633\u062a\u061f&#8221; SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code>   <span class=\"k\">SELECT<\/span> <span class=\"n\">causante<\/span><span class=\"p\">,<\/span> <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">total_incidentes<\/span>\n   <span class=\"k\">FROM<\/span> <span class=\"n\">tickets<\/span>\n   <span class=\"k\">WHERE<\/span> <span class=\"n\">solicitudes<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Incidentes'<\/span>\n   <span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">causante<\/span>\n   <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">total_incidentes<\/span> <span class=\"k\">DESC<\/span>\n   <span class=\"k\">LIMIT<\/span> <span class=\"mi\">1<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc:<\/strong><\/p>\n<p>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627:<\/p>\n<ul>\n<li>\u0622\u0646\u0647\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062a\u0646\u06cc \u0645\u062d\u062a\u0648\u0627\u06cc \u0628\u0644\u06cc\u0637 \u062f\u0627\u0631\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc \u0628\u0647\u0631\u0647 \u0645\u06cc \u0628\u0631\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u062a\u0648\u0633\u0637 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u0646\u0634 \u0628\u0633\u062a\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0645\u062b\u0627\u0644 \u0647\u0627:<\/p>\n<ol>\n<li>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062d\u062a\u0648\u0627\u06cc \u062e\u0627\u0635 \u0628\u0644\u06cc\u0637<\/li>\n<li>\u062e\u0644\u0627\u0635\u0647 \u0645\u0648\u0627\u0631\u062f<\/li>\n<li>\u062a\u0641\u0633\u06cc\u0631 \u0627\u0644\u06af\u0648\u0647\u0627 \u062f\u0631 \u06af\u0632\u0627\u0631\u0634 \u0647\u0627<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"%D8%AC%D8%B1%DB%8C%D8%A7%D9%86_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4\"><\/span>\n<p>  \u062c\u0631\u06cc\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u062c\u0631\u06cc\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a\u0645 \u0628\u0631\u0627\u06cc \u0645\u0642\u0627\u0628\u0644\u0647 \u0628\u0627 \u0686\u0627\u0644\u0634 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0645 \u0628\u0647 \u0633\u0647 \u0645\u0631\u062d\u0644\u0647 \u0633\u0627\u062f\u0647 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<ol>\n<li>\n<p><strong>\u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0627\u0648\u0644\u06cc\u0647<\/strong><\/p>\n<ul>\n<li>\u0627\u0632 \u0627\u0639\u0644\u0627\u0646 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u06cc\u06cc\u0646 \u0642\u0637\u0639\u06cc \u0628\u0648\u062f\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0648 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0628\u0639\u062f\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u06cc\u062f\u060c \u0645\u0646 \u0627\u0632 \u06cc\u06a9 LLM \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645 \u062a\u0627 \u0628\u062f\u0627\u0646\u0645 \u0622\u06cc\u0627 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u067e\u0631\u0633\u062f \u0645\u0627\u0647\u06cc\u062a \u0642\u0637\u0639\u06cc \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<\/li>\n<li>\u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0642\u0637\u0639\u06cc \u0628\u0627\u0634\u062f\u060c LLM SQL \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u062f\u0631\u0648\u0646 \u062a\u06af \u0647\u0627 \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f <code><sql\/><\/code>. \u0627\u06cc\u0646 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062c\u062f\u0648\u0644 \u0622\u062a\u0646\u0627 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><strong>\u062a\u0639\u0642\u06cc\u0628 \u0642\u0636\u0627\u06cc\u06cc<\/strong><\/p>\n<ul>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc: \u0627\u0632 \u0637\u0631\u06cc\u0642 Athena \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u060c \u0645\u0627 \u06cc\u06a9 SQL \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06cc\u06a9 LLM \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc: \u0622\u0646\u0647\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 Amazon Bedrock &#8211; Knowledge Base \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u0634\u0648\u0646\u062f. \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u0646\u0634 \u062d\u0627\u0648\u06cc \u0647\u0645\u0627\u0646 \u0641\u0627\u06cc\u0644 CSV \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u062f\u0631 \u0622\u062a\u0646\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><strong>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u067e\u0627\u0633\u062e<\/strong><\/p>\n<ul>\n<li>\u0646\u062a\u0627\u06cc\u062c \u0622\u062a\u0646\u0627 \u0628\u0647 25 \u0631\u06a9\u0648\u0631\u062f \u0645\u062d\u062f\u0648\u062f \u0634\u062f\u0647 \u0627\u0633\u062a (\u0627\u06cc\u0646 \u0628\u0647 \u0627\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u0646\u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0633\u0624\u0627\u0644\u06cc \u0628\u062a\u0648\u0627\u0646\u062f \u06a9\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f).<\/li>\n<li>LLM \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0646\u062a\u0627\u06cc\u062c \u0628\u0647 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0637\u0628\u06cc\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<li>\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0632\u0628\u0627\u0646 \u0633\u0624\u0627\u0644 \u0627\u0635\u0644\u06cc \u062d\u0641\u0638 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%B9%D9%85%D8%A7%D8%B1%DB%8C_%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\"><\/span>\n<p>  \u0645\u0639\u0645\u0627\u0631\u06cc \u0631\u0627\u0647 \u062d\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u062f\u0647 \u0686\u0627\u0644\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0631\u06a9\u06cc\u0628 \u0627\u0633\u062a\u0631\u0627\u062a\u0698\u06cc\u06a9 \u062e\u062f\u0645\u0627\u062a AWS \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 LLM \u062d\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0631 \u0645\u0648\u0631\u062f \u0647\u0631 \u062c\u0632\u0621 \u0648 \u0627\u062c\u0631\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0622\u0646 \u0628\u062d\u062b \u06a9\u0646\u06cc\u0645.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D9%88_%D9%84%D8%A7%DB%8C%D9%87_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C\"><\/span>\n<p>  1. \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0644\u0627\u06cc\u0647 \u0622\u0645\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"11_%D8%B3%D8%A7%D8%AE%D8%AA%D8%A7%D8%B1_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D9%BE%D8%A7%DB%8C%D9%87\"><\/span>\n<p>  1.1 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0627\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0631 \u0631\u0648\u06cc \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 S3 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0633\u0648\u0627\u0628\u0642 \u0628\u0644\u06cc\u0637 \u0627\u0633\u062a. \u062a\u0647\u06cc\u0647 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">EXTERNAL<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">IF<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">EXISTS<\/span> <span class=\"nv\">`default`<\/span><span class=\"p\">.<\/span><span class=\"nv\">`tickets`<\/span> <span class=\"p\">(<\/span>\n <span class=\"nv\">`fechaResolucion`<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n <span class=\"nv\">`asignado`<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n <span class=\"nv\">`solicitudes`<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n <span class=\"nv\">`producto`<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n <span class=\"nv\">`departamento`<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n <span class=\"c1\">-- [resto de campos]<\/span>\n<span class=\"p\">)<\/span>\n<span class=\"k\">COMMENT<\/span> <span class=\"nv\">\"Tabla de tiquetes de Ejemplo\"<\/span>\n<span class=\"k\">ROW<\/span> <span class=\"n\">FORMAT<\/span> <span class=\"n\">SERDE<\/span> <span class=\"s1\">'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'<\/span>\n<span class=\"k\">WITH<\/span> <span class=\"n\">SERDEPROPERTIES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'field.delim'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">';'<\/span><span class=\"p\">)<\/span>\n<span class=\"n\">STORED<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">INPUTFORMAT<\/span> <span class=\"s1\">'org.apache.hadoop.mapred.TextInputFormat'<\/span>\n<span class=\"n\">OUTPUTFORMAT<\/span> <span class=\"s1\">'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'<\/span>\n<span class=\"k\">LOCATION<\/span> <span class=\"s1\">'s3:\/\/MiBucket\/'<\/span>\n<span class=\"n\">TBLPROPERTIES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'classification'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'csv'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 DDL \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u0632\u06cc\u0631\u0627:<\/p>\n<ul>\n<li>\u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0642\u06cc\u0642\u06cc \u0631\u0627 \u06a9\u0647 \u0622\u062a\u0646\u0627 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f\u060c \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u062c\u062f\u0627 \u06a9\u0646\u0646\u062f\u0647 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f <code>;<\/code> \u0628\u0631\u0627\u06cc \u062a\u0641\u0633\u06cc\u0631 \u0635\u062d\u06cc\u062d CSV.<\/li>\n<li>\u0645\u062d\u0644 \u0642\u0631\u0627\u0631\u06af\u06cc\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 S3 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u0641\u0631\u0645\u062a \u0648\u0631\u0648\u062f\u06cc\/\u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"12_%D8%AF%DB%8C%DA%A9%D8%B4%D9%86%D8%B1%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7\"><\/span>\n<p>  1.2 \u062f\u06cc\u06a9\u0634\u0646\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u0633\u0627\u062e\u062a\u0627\u0631\u060c \u0645\u0627 \u06cc\u06a9 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u062f\u0642\u06cc\u0642 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 LLM \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>fechaResolucion: Campo que indica la fecha y hora de resoluci\u00f3n del ticket.\n                Formato: mes\/dia\/anno hora:minuto\ncausante: Campo categ\u00f3rico que indica si el ticket fue levantado por A o B\ndepartamento: Campo calculado descriptivo del departamento que atendi\u00f3\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_%D8%B3%DB%8C%D8%B3%D8%AA%D9%85_%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88\"><\/span>\n<p>  2. \u0633\u06cc\u0633\u062a\u0645 \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"21_%D8%AF%D8%B1%D8%AE%D9%88%D8%A7%D8%B3%D8%AA_%D8%B7%D8%A8%D9%82%D9%87_%D8%A8%D9%86%D8%AF%DB%8C\"><\/span>\n<p>  2.1 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0637\u0628\u0642\u0647 \u0628\u0646\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0645\u0647\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u0645 \u0622\u06cc\u0627 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631. \u0645\u0627 \u0627\u06cc\u0646 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 \u062e\u0627\u0635 \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nc\">StringBuilder<\/span> <span class=\"n\">prompt<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">StringBuilder<\/span><span class=\"o\">(<\/span>\n   <span class=\"s\">\"Eres un experto en an\u00e1lisis de tiquetes, necesito que analices \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"s\">\"la pregunta que te indico y si esa pregunta no puede ser respondida \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"s\">\"por un LLM (ya que es determin\u00edstica) respondas solamente la frase \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"s\">\"'DETERMINISTICA' seguido de un SQL dentro de un tag <sql> que cumpla \"<\/sql><\/span> <span class=\"o\">+<\/span>\n   <span class=\"s\">\"con la definici\u00f3n de la siguiente tabla de Athena y su glosario...\"<\/span>\n<span class=\"o\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0627\u0639\u0644\u0627\u0646 \u062d\u06cc\u0627\u062a\u06cc \u0627\u0633\u062a \u0632\u06cc\u0631\u0627:<\/p>\n<ul>\n<li>\u0646\u0642\u0634 \u062e\u0627\u0635 \u0645\u062f\u0644 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u0642\u0627\u0644\u0628 \u067e\u0627\u0633\u062e \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631 \u062f\u0642\u06cc\u0642 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u0634\u0627\u0645\u0644 \u0632\u0645\u06cc\u0646\u0647 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u06cc\u06a9 \u067e\u0627\u0633\u062e \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0648 \u0639\u0645\u0644\u06cc \u0631\u0627 \u0648\u0627\u062f\u0627\u0631 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"22_%D8%AA%D9%88%D9%84%DB%8C%D8%AF_SQL_%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_LLM\"><\/span>\n<p>  2.2 \u062a\u0648\u0644\u06cc\u062f SQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 LLM<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u062a\u0634\u062e\u06cc\u0635 \u062f\u0627\u062f \u06a9\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0627\u0633\u062a\u060c SQL \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u0633\u0627\u0644 \u0628\u0647 Athena \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u06cc\u0646 \u0628\u0647 \u0644\u0637\u0641 \u0627\u06cc\u0646 \u0648\u0627\u0642\u0639\u06cc\u062a \u062d\u0627\u0635\u0644 \u0645\u06cc \u0634\u0648\u062f \u06a9\u0647 \u0645\u0627 \u062f\u0631 \u0627\u0639\u0644\u0627\u0646 \u0642\u0628\u0644\u06cc \u062a\u0639\u0631\u06cc\u0641 \u062c\u062f\u0648\u0644 \u0648 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u062f\u0627\u062f\u0647 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/p>\n<p>\u062f\u0631 \u0645\u0642\u0627\u0644\u0647 \u0642\u0628\u0644\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Bedrock \u0628\u0627 RDS{:target=&#8221;_blank&#8221;} \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 LLM \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0648 \u062a\u062c\u0631\u0628\u0647 \u0642\u0628\u0644\u06cc \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u0627\u0633\u062a.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"221_%D9%BE%DB%8C%DA%A9%D8%B1%D8%A8%D9%86%D8%AF%DB%8C_%D9%88_%D9%81%D8%B1%D8%A7%D8%AE%D9%88%D8%A7%D9%86%DB%8C_%D9%85%D8%AF%D9%84\"><\/span>\n<p>  2.2.1 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0648 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u062f\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"kt\">var<\/span> <span class=\"n\">message<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">Message<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">content<\/span><span class=\"o\">(<\/span><span class=\"nc\">ContentBlock<\/span><span class=\"o\">.<\/span><span class=\"na\">fromText<\/span><span class=\"o\">(<\/span><span class=\"n\">prompt<\/span><span class=\"o\">.<\/span><span class=\"na\">toString<\/span><span class=\"o\">()))<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">role<\/span><span class=\"o\">(<\/span><span class=\"nc\">ConversationRole<\/span><span class=\"o\">.<\/span><span class=\"na\">USER<\/span><span class=\"o\">)<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n<span class=\"k\">try<\/span> <span class=\"o\">{<\/span>\n  <span class=\"kt\">var<\/span> <span class=\"n\">client<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">BedrockRuntimeClient<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">credentialsProvider<\/span><span class=\"o\">(<\/span><span class=\"nc\">DefaultCredentialsProvider<\/span><span class=\"o\">.<\/span><span class=\"na\">create<\/span><span class=\"o\">())<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">region<\/span><span class=\"o\">(<\/span><span class=\"nc\">Region<\/span><span class=\"o\">.<\/span><span class=\"na\">US_EAST_1<\/span><span class=\"o\">)<\/span>\n      <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n  <span class=\"c1\">\/\/ Send the message with a basic inference configuration.<\/span>\n  <span class=\"nc\">ConverseResponse<\/span> <span class=\"n\">response<\/span> <span class=\"o\">=<\/span> <span class=\"n\">client<\/span><span class=\"o\">.<\/span><span class=\"na\">converse<\/span><span class=\"o\">(<\/span><span class=\"n\">request<\/span> <span class=\"o\">-&gt;<\/span> <span class=\"n\">request<\/span>\n          <span class=\"o\">.<\/span><span class=\"na\">modelId<\/span><span class=\"o\">(<\/span><span class=\"no\">FOUNDATIONAL_MODEL<\/span><span class=\"o\">)<\/span>\n          <span class=\"o\">.<\/span><span class=\"na\">messages<\/span><span class=\"o\">(<\/span><span class=\"n\">message<\/span><span class=\"o\">)<\/span>\n          <span class=\"o\">.<\/span><span class=\"na\">inferenceConfig<\/span><span class=\"o\">(<\/span><span class=\"n\">config<\/span> <span class=\"o\">-&gt;<\/span> <span class=\"n\">config<\/span>\n                  <span class=\"o\">.<\/span><span class=\"na\">maxTokens<\/span><span class=\"o\">(<\/span><span class=\"mi\">512<\/span><span class=\"o\">)<\/span>    <span class=\"c1\">\/\/ Suficiente para consultas SQL complejas<\/span>\n                  <span class=\"o\">.<\/span><span class=\"na\">temperature<\/span><span class=\"o\">(<\/span><span class=\"mf\">0.5<\/span><span class=\"no\">F<\/span><span class=\"o\">)<\/span> <span class=\"c1\">\/\/ Bajo para mayor precisi\u00f3n<\/span>\n                  <span class=\"o\">.<\/span><span class=\"na\">topP<\/span><span class=\"o\">(<\/span><span class=\"mf\">0.9<\/span><span class=\"no\">F<\/span><span class=\"o\">)));<\/span>     <span class=\"c1\">\/\/ Alta coherencia en la estructura<\/span>\n\n  <span class=\"c1\">\/\/ Retrieve the generated text from Bedrock's response object.<\/span>\n  <span class=\"kt\">var<\/span> <span class=\"n\">responseText<\/span> <span class=\"o\">=<\/span> <span class=\"n\">response<\/span><span class=\"o\">.<\/span><span class=\"na\">output<\/span><span class=\"o\">().<\/span><span class=\"na\">message<\/span><span class=\"o\">().<\/span><span class=\"na\">content<\/span><span class=\"o\">().<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">0<\/span><span class=\"o\">).<\/span><span class=\"na\">text<\/span><span class=\"o\">();<\/span>\n  <span class=\"n\">client<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\n\n  <span class=\"k\">return<\/span> <span class=\"n\">responseText<\/span><span class=\"o\">;<\/span>\n\n<span class=\"o\">}<\/span> <span class=\"k\">catch<\/span> <span class=\"o\">(<\/span><span class=\"nc\">SdkClientException<\/span> <span class=\"n\">e<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\n  <span class=\"nc\">System<\/span><span class=\"o\">.<\/span><span class=\"na\">err<\/span><span class=\"o\">.<\/span><span class=\"na\">printf<\/span><span class=\"o\">(<\/span><span class=\"s\">\"ERROR: Can't invoke '%s'. Reason: %s\"<\/span><span class=\"o\">,<\/span> <span class=\"no\">FOUNDATIONAL_MODEL<\/span><span class=\"o\">,<\/span> <span class=\"n\">e<\/span><span class=\"o\">.<\/span><span class=\"na\">getMessage<\/span><span class=\"o\">());<\/span>\n  <span class=\"k\">return<\/span> <span class=\"s\">\"No se puede responder esa pregunta\"<\/span><span class=\"o\">;<\/span>\n<span class=\"o\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h5><span class=\"ez-toc-section\" id=\"222_%D9%85%D8%AB%D8%A7%D9%84_%D8%AC%D8%B1%DB%8C%D8%A7%D9%86_%DA%A9%D8%A7%D9%85%D9%84\"><\/span>\n<p>  2.2.2 \u0645\u062b\u0627\u0644 \u062c\u0631\u06cc\u0627\u0646 \u06a9\u0627\u0645\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0646 \u0627\u06cc\u0646 \u0631\u0648\u0646\u062f\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0633\u0648\u0627\u0644 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u0645: &#8220;\u06a9\u062f\u0627\u0645 \u0628\u062e\u0634 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0644\u06cc\u0637 \u0628\u0627\u0632 \u0627\u0633\u062a\u061f&#8221;<\/p>\n<ol>\n<li>\n<strong>\u0648\u0631\u0648\u062f\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0645\u062f\u0644<\/strong>:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>[Todo el contexto anterior + schema + diccionario]\nPregunta: \u00bfCu\u00e1l departamento tiene m\u00e1s tickets abiertos?\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\n<strong>SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0627\u0633\u062a<\/strong>:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n   <span class=\"n\">departamento<\/span><span class=\"p\">,<\/span>\n   <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">total_tickets<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">tickets<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">fechaResolucion<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">NULL<\/span>\n<span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">departamento<\/span>\n<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">total_tickets<\/span> <span class=\"k\">DESC<\/span>\n<span class=\"k\">LIMIT<\/span> <span class=\"mi\">25<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627 \u0628\u0647 \u0622\u062a\u0646\u0627 \u0641\u0631\u0633\u062a\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0648\u0627\u0642\u0639\u06cc\u062a \u06a9\u0647 \u0645\u062f\u0644 \u0627\u0632 \u0642\u0628\u0644 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0642\u06cc\u0642 \u062c\u062f\u0648\u0644 \u0648 \u0645\u0639\u0646\u0627\u06cc \u0647\u0631 \u0641\u06cc\u0644\u062f \u0631\u0627 \u0628\u0647 \u0644\u0637\u0641 \u0632\u0645\u06cc\u0646\u0647 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0645\u06cc \u062f\u0627\u0646\u062f.<\/p>\n<p>\u06a9\u0644\u06cc\u062f \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062f\u0631 \u062f\u0642\u062a \u0632\u0645\u06cc\u0646\u0647 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0628\u0647 \u0645\u062f\u0644 \u0648 \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0631 \u0642\u0627\u0644\u0628 \u067e\u0627\u0633\u062e \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u06cc \u0646\u0647\u0641\u062a\u0647 \u0627\u0633\u062a\u060c \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u062a\u0648\u0644\u06cc\u062f \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u062f\u0642\u06cc\u0642\u0627\u064b \u0628\u0627 \u0637\u0631\u062d \u0645\u0627 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%82%D8%B7%D8%B9%DB%8C\"><\/span>\n<p>  3. \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_%D8%A7%D8%AC%D8%B1%D8%A7%DB%8C_%DA%A9%D9%88%D8%A6%D8%B1%DB%8C_%D9%87%D8%A7%DB%8C_%D8%A2%D8%AA%D9%86%D8%A7\"><\/span>\n<p>  3.1 \u0627\u062c\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627\u06cc \u0622\u062a\u0646\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0642\u0637\u0639\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0634\u062f\u060c \u0633\u06cc\u0633\u062a\u0645 SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">executeAthenaQuery<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">query<\/span><span class=\"o\">,<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">database<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\n <span class=\"k\">try<\/span> <span class=\"o\">(<\/span><span class=\"nc\">AthenaClient<\/span> <span class=\"n\">athenaClient<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">AthenaClient<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n   <span class=\"o\">.<\/span><span class=\"na\">region<\/span><span class=\"o\">(<\/span><span class=\"nc\">Region<\/span><span class=\"o\">.<\/span><span class=\"na\">US_EAST_1<\/span><span class=\"o\">)<\/span> <span class=\"c1\">\/\/ Ajusta la regi\u00f3n seg\u00fan tu configuraci\u00f3n<\/span>\n   <span class=\"o\">.<\/span><span class=\"na\">credentialsProvider<\/span><span class=\"o\">(<\/span><span class=\"nc\">DefaultCredentialsProvider<\/span><span class=\"o\">.<\/span><span class=\"na\">create<\/span><span class=\"o\">())<\/span>\n   <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">())<\/span> <span class=\"o\">{<\/span>\n\n   <span class=\"c1\">\/\/ Configurar la solicitud de consulta<\/span>\n   <span class=\"nc\">StartQueryExecutionRequest<\/span> <span class=\"n\">startQueryExecutionRequest<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">StartQueryExecutionRequest<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n     <span class=\"o\">.<\/span><span class=\"na\">queryString<\/span><span class=\"o\">(<\/span><span class=\"n\">query<\/span><span class=\"o\">)<\/span>\n     <span class=\"o\">.<\/span><span class=\"na\">queryExecutionContext<\/span><span class=\"o\">(<\/span><span class=\"nc\">QueryExecutionContext<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n       <span class=\"o\">.<\/span><span class=\"na\">database<\/span><span class=\"o\">(<\/span><span class=\"n\">database<\/span><span class=\"o\">)<\/span>\n       <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">())<\/span>\n     <span class=\"o\">.<\/span><span class=\"na\">resultConfiguration<\/span><span class=\"o\">(<\/span><span class=\"nc\">ResultConfiguration<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n       <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">())<\/span>\n     <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n   <span class=\"c1\">\/\/ Iniciar la consulta<\/span>\n   <span class=\"nc\">StartQueryExecutionResponse<\/span> <span class=\"n\">startQueryExecutionResponse<\/span> <span class=\"o\">=<\/span> <span class=\"n\">athenaClient<\/span><span class=\"o\">.<\/span><span class=\"na\">startQueryExecution<\/span><span class=\"o\">(<\/span><span class=\"n\">startQueryExecutionRequest<\/span><span class=\"o\">);<\/span>\n   <span class=\"nc\">String<\/span> <span class=\"n\">queryExecutionId<\/span> <span class=\"o\">=<\/span> <span class=\"n\">startQueryExecutionResponse<\/span><span class=\"o\">.<\/span><span class=\"na\">queryExecutionId<\/span><span class=\"o\">();<\/span>\n\n   <span class=\"c1\">\/\/ Esperar a que la consulta termine<\/span>\n   <span class=\"n\">waitForQueryToComplete<\/span><span class=\"o\">(<\/span><span class=\"n\">athenaClient<\/span><span class=\"o\">,<\/span> <span class=\"n\">queryExecutionId<\/span><span class=\"o\">);<\/span>\n\n   <span class=\"c1\">\/\/ Obtener los resultados de la consulta<\/span>\n   <span class=\"k\">return<\/span> <span class=\"nf\">getQueryResults<\/span><span class=\"o\">(<\/span><span class=\"n\">athenaClient<\/span><span class=\"o\">,<\/span> <span class=\"n\">queryExecutionId<\/span><span class=\"o\">);<\/span>\n\n <span class=\"o\">}<\/span> <span class=\"k\">catch<\/span> <span class=\"o\">(<\/span><span class=\"nc\">Exception<\/span> <span class=\"n\">e<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\n   <span class=\"n\">e<\/span><span class=\"o\">.<\/span><span class=\"na\">printStackTrace<\/span><span class=\"o\">();<\/span>\n   <span class=\"k\">throw<\/span> <span class=\"k\">new<\/span> <span class=\"nf\">RuntimeException<\/span><span class=\"o\">(<\/span><span class=\"s\">\"Error executing Athena query\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">e<\/span><span class=\"o\">);<\/span>\n <span class=\"o\">}<\/span>\n<span class=\"o\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u06a9\u062f:<\/p>\n<ul>\n<li>\u0627\u0631\u062a\u0628\u0627\u0637 \u0627\u06cc\u0645\u0646 \u0628\u0627 \u0622\u062a\u0646\u0627 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0646\u0627\u0647\u0645\u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u0634\u0646\u0627\u0633\u0647 \u0627\u062c\u0631\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u06a9\u0646\u062a\u0631\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"4_%D9%82%D8%A7%D9%84%D8%A8_%D8%A8%D9%86%D8%AF%DB%8C_%D9%BE%D8%A7%D8%B3%D8%AE\"><\/span>\n<p>  4. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u067e\u0627\u0633\u062e<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0634\u0627\u0645\u0644 \u062a\u0628\u062f\u06cc\u0644 \u0646\u062a\u0627\u06cc\u062c \u0641\u0646\u06cc \u0628\u0647 \u067e\u0627\u0633\u062e \u0647\u0627\u06cc \u0642\u0627\u0628\u0644 \u062f\u0631\u06a9 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nc\">StringBuilder<\/span> <span class=\"n\">prompt<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">StringBuilder<\/span><span class=\"o\">(<\/span>\n   <span class=\"s\">\"Eres un experto en atenci\u00f3n a consultas, debes responder \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"s\">\"de manera profesional, concisa y clara. La pregunta realizada fue \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"n\">preguntaUsuario<\/span> <span class=\"o\">+<\/span> <span class=\"s\">\" y la respuesta de la base de datos es: \"<\/span> <span class=\"o\">+<\/span>\n   <span class=\"n\">respuestaBD<\/span><span class=\"o\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc:<\/p>\n<ul>\n<li>\u0632\u0645\u06cc\u0646\u0647 \u0633\u0648\u0627\u0644 \u0627\u0635\u0644\u06cc \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u067e\u0627\u0633\u062e \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0637\u0628\u06cc\u0639\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u062f\u0642\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0645\u062f\u0647 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"5_%D8%B1%D8%B3%DB%8C%D8%AF%DA%AF%DB%8C_%D8%A8%D9%87_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\"><\/span>\n<p>  5. \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u062a\u0634\u062e\u06cc\u0635 \u0645\u06cc \u062f\u0647\u062f\u060c \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062a\u0646\u06cc \u06cc\u0627 \u062a\u0641\u0633\u06cc\u0631\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0633\u062a\u0642\u06cc\u0645 SQL \u0642\u0627\u0628\u0644 \u062d\u0644 \u0646\u06cc\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a\u060c \u0633\u06cc\u0633\u062a\u0645 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u0645\u062f\u0644 Anthropic \u0628\u0631\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"51_%D8%B4%D9%86%D8%A7%D8%B3%D8%A7%DB%8C%DB%8C_%D9%88_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4\"><\/span>\n<p>  5.1 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u067e\u0631\u062f\u0627\u0632\u0634<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f\u060c \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u062f\u0644 \u06a9\u0644\u0645\u0647 &#8220;DETERMINISTIC&#8221; \u0648 \u0633\u067e\u0633 \u06cc\u06a9 SQL \u0631\u0627 \u0628\u0631 \u0646\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a\u060c \u0633\u06cc\u0633\u062a\u0645 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062f\u0644 Bedrock \u0628\u0647 \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc\u200c\u067e\u0631\u062f\u0627\u0632\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"52_%D9%BE%DB%8C%DA%A9%D8%B1%D8%A8%D9%86%D8%AF%DB%8C_%D9%85%D8%AF%D9%84\"><\/span>\n<p>  5.2 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0645\u062f\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u067e\u0631\u0633\u0634\u200c\u0647\u0627\u060c \u0627\u0632 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u067e\u0627\u06cc\u0647 \u0645\u062f\u0644 Anthropic Sonnet 3.5 v2 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nc\">RetrieveAndGenerateInput<\/span> <span class=\"n\">input<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">RetrieveAndGenerateInput<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">text<\/span><span class=\"o\">(<\/span><span class=\"n\">prompt<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n<span class=\"nc\">KnowledgeBaseRetrieveAndGenerateConfiguration<\/span> <span class=\"n\">knowledgeConfig<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">KnowledgeBaseRetrieveAndGenerateConfiguration<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">knowledgeBaseId<\/span><span class=\"o\">(<\/span><span class=\"no\">KNOWLEDGE_BASE_ID<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">modelArn<\/span><span class=\"o\">(<\/span><span class=\"no\">MODEL_ARN<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n<span class=\"nc\">RetrieveAndGenerateConfiguration<\/span> <span class=\"n\">retrieveConfig<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">RetrieveAndGenerateConfiguration<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">knowledgeBaseConfiguration<\/span><span class=\"o\">(<\/span><span class=\"n\">knowledgeConfig<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">type<\/span><span class=\"o\">(<\/span><span class=\"s\">\"KNOWLEDGE_BASE\"<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n<span class=\"nc\">RetrieveAndGenerateRequest<\/span> <span class=\"n\">request1<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">RetrieveAndGenerateRequest<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">()<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">retrieveAndGenerateConfiguration<\/span><span class=\"o\">(<\/span><span class=\"n\">retrieveConfig<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">input<\/span><span class=\"o\">(<\/span><span class=\"n\">input<\/span><span class=\"o\">)<\/span>\n        <span class=\"o\">.<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\n\n<span class=\"nc\">RetrieveAndGenerateResponse<\/span> <span class=\"n\">response1<\/span> <span class=\"o\">=<\/span> <span class=\"n\">bedrockAgentRuntimeClient<\/span><span class=\"o\">.<\/span><span class=\"na\">retrieveAndGenerate<\/span><span class=\"o\">(<\/span><span class=\"n\">request1<\/span><span class=\"o\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"53_%D9%86%D9%85%D9%88%D9%86%D9%87_%D9%87%D8%A7%DB%8C%DB%8C_%D8%A7%D8%B2_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D9%82%D8%B7%D8%B9%DB%8C\"><\/span>\n<p>  5.3 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0647 \u0635\u0648\u0631\u062a \u062a\u0641\u0633\u06cc\u0631\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<ol>\n<li>\n<strong>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u062d\u062a\u0648\u0627<\/strong>:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>  Pregunta: \"\u00bfCu\u00e1les son los patrones comunes en los tickets de error de conexi\u00f3n?\"\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\n<strong>\u062a\u0641\u0633\u06cc\u0631 \u067e\u0631\u0648\u0646\u062f\u0647<\/strong>:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>  Pregunta: \"\u00bfC\u00f3mo se resolvi\u00f3 un caso similar la \u00faltima vez?\"\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\n<strong>\u062e\u0644\u0627\u0635\u0647 \u0647\u0627\u06cc \u0645\u062a\u0646\u06cc<\/strong>:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>  Pregunta: \"Resume el problema principal del ticket #12345\"\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0627\u0631\u062f \u0633\u06cc\u0633\u062a\u0645:<\/p>\n<ul>\n<li>\u062a\u0644\u0627\u0634\u06cc \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0646\u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u062f\u0644 \u067e\u0631\u062f\u0627\u0632\u0634 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u067e\u0627\u0633\u062e\u06cc \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0632\u0645\u06cc\u0646\u0647 \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u062c\u0648\u062f \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<li>\u0642\u0627\u0644\u0628 \u0648 \u0644\u062d\u0646 \u0631\u0627 \u0628\u0627 \u0633\u0648\u0627\u0644 \u0627\u0635\u0644\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0647\u06cc\u062f.<\/li>\n<\/ul>\n<p>\u067e\u0627\u0633\u062e \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u062a\u062d\u0648\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0627\u0647\u06cc\u062a \u0645\u06a9\u0627\u0644\u0645\u0647 \u0648 \u0632\u0645\u06cc\u0646\u0647 \u0633\u0624\u0627\u0644 \u0627\u0635\u0644\u06cc \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87_%DA%AF%DB%8C%D8%B1%DB%8C_%D9%88_%D9%85%D8%B1%D8%A7%D8%AD%D9%84_%D8%A8%D8%B9%D8%AF%DB%8C\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc \u0648 \u0645\u0631\u0627\u062d\u0644 \u0628\u0639\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0627\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645 \u062a\u0631\u06a9\u06cc\u0628\u06cc\u060c \u06a9\u0647 \u062f\u0642\u062a \u067e\u0631\u0633\u0634\u200c\u0647\u0627\u06cc SQL \u0631\u0627 \u0628\u0627 \u0638\u0631\u0641\u06cc\u062a \u062a\u0641\u0633\u06cc\u0631\u06cc \u0645\u062f\u0644\u200c\u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0646\u0634\u0627\u0646\u200c\u062f\u0647\u0646\u062f\u0647 \u0634\u0631\u0648\u0639\u06cc \u0627\u0633\u062a \u0627\u0632 \u0622\u0646\u0686\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u0648\u0644\u062f \u062f\u0631 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7%D8%B2%D8%AA%D8%A7%D8%A8_%D9%87%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C%D8%AF%DB%8C\"><\/span>\n<p>  \u0628\u0627\u0632\u062a\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u062a\u0645\u0627\u06cc\u0632 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u06cc\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0642\u0637\u0639\u06cc \u0648 \u063a\u06cc\u0631 \u0642\u0637\u0639\u06cc \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0647\u0631 \u062f\u0648 \u062c\u0647\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645: \u062f\u0631\u0633\u062a\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0648 \u062f\u0631\u06a9 \u0645\u062a\u0646\u06cc LLM.<\/li>\n<li>\u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u062f\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u062f\u0642\u062a \u0644\u0627\u0632\u0645 \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u062d\u0641\u0638 \u06a9\u0631\u062f \u0648 \u062f\u0631 \u0639\u06cc\u0646 \u062d\u0627\u0644 \u062a\u062c\u0631\u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0642\u0627\u0628\u0644\u200c\u062a\u0648\u062c\u0647\u06cc \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u06cc\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062e\u062f\u0645\u0627\u062a \u0645\u062f\u0631\u0646 \u0645\u0627\u0646\u0646\u062f Amazon Bedrock \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0631\u0627 \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0632\u06cc\u0631\u0633\u0627\u062e\u062a \u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0648 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062a\u0631\u06cc\u0646 LLM \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645.<\/li>\n<\/ul>\n<p>\u0645\u0646 \u0627\u0632 \u0634\u0645\u0627 \u062f\u0639\u0648\u062a \u0645\u06cc \u06a9\u0646\u0645 \u06a9\u0647 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0648\u0634 \u0647\u0627\u06cc \u062e\u0648\u062f \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0686\u0647 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0628\u0647\u0628\u0648\u062f \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u06cc\u0637 \u062e\u0648\u062f \u0628\u0627\u0634\u06cc\u062f\u060c \u0686\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0645\u0641\u0627\u0647\u06cc\u0645 \u0631\u0627 \u062f\u0631 \u062d\u0648\u0632\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0647 \u06a9\u0627\u0631 \u0628\u0628\u0631\u06cc\u062f\u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u062a \u0628\u0633\u06cc\u0627\u0631 \u0632\u06cc\u0627\u062f \u0627\u0633\u062a.<\/p>\n<p>GenAI \u0646\u062d\u0648\u0647 \u062a\u0639\u0627\u0645\u0644 \u0645\u0627 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u062f \u0648 \u0645\u0646 \u0647\u06cc\u062c\u0627\u0646 \u0632\u062f\u0647 \u0647\u0633\u062a\u0645 \u06a9\u0647 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u062a\u062d\u0648\u0644 \u0628\u0627\u0634\u0645. \u0622\u06cc\u0627 \u0634\u0645\u0627 \u0647\u0645 \u062c\u0631\u0627\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0628\u062e\u0634\u06cc \u0627\u0632 \u0622\u0646 \u0628\u0627\u0634\u06cc\u062f\u061f<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summarize this content to 400 words in Persian Lang \u0645\u0642\u062f\u0645\u0647 \u062f\u0631 \u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u067e\u0648\u06cc\u0627 \u0645\u0648\u0644\u062f \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0627\u0645\u0631\u0648\u0632\u06cc\u060c \u0645\u062f\u0644 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646\u06cc \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0632\u0631\u06af (LLM) \u062a\u0639\u0627\u0645\u0644 \u0645\u0627 \u0628\u0627 \u0641\u0646\u0627\u0648\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0634\u062f\u062a \u0645\u062a\u062d\u0648\u0644 \u06a9\u0631\u062f\u0647 \u0627\u0646\u062f. \u0627\u06cc\u0646 \u0645\u062f\u0644\u200c\u0647\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u062b\u0646\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u062a\u0648\u0644\u06cc\u062f \u0645\u062a\u0646\u060c \u062a\u062d\u0644\u06cc\u0644 \u0627\u062d\u0633\u0627\u0633\u0627\u062a \u0648 \u062f\u0631\u06a9 \u0632\u0645\u06cc\u0646\u0647\u200c\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0627\u0646\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c &hellip;<\/p>\n","protected":false},"author":2,"featured_media":86092,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-86091","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/86091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=86091"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/86091\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/86092"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=86091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=86091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=86091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}