Hive SQL Agent

Required Parameters

• Language Model: The AI model used for query processing
• Tool: SQL processing capabilities
• Hive Service: Hive connection service configuration
• Hive Table: Target table configuration
• Prompt: Query generation prompt template
• Database: Database connection details

Output Format

{
  "queryResult": {
    "data": array,
    "metadata": {
      "affectedRows": number,
      "executionTime": string
    }
  }
}

Example Usage

const hiveSqlAgent = new HiveSQLAgent({
  languageModel: "gpt-4",
  tool: "sql-processor",
  hiveService: {
    host: "hive-server",
    port: 10000
  },
  hiveTable: "example_table",
  prompt: "Generate a Hive SQL query to...",
  database: "example_db"
});

const result = await hiveSqlAgent.process({
  input: "Show me all sales from last month"
});