hue_execute_query
Execute SQL queries on Hadoop Hue to retrieve data using Hive, SparkSQL, or Impala dialects with configurable timeout and batch size.
Instructions
Execute a SQL query on Hue and return the results.
This tool executes a SQL statement, waits for completion, and fetches all results.
Use this for SELECT queries where you want to retrieve data.
Args:
statement: The SQL statement to execute (e.g., "SELECT * FROM table LIMIT 100")
dialect: SQL dialect to use - 'hive', 'sparksql', or 'impala' (default: 'hive')
timeout: Maximum time to wait for query completion in seconds (default: 300)
batch_size: Number of rows to fetch per batch for pagination (default: 1000)
Returns:
QueryResult with headers, rows, and row_count
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| statement | Yes | ||
| dialect | No | hive | |
| timeout | No | ||
| batch_size | No |