ISSUE DESCRIPTION [BUG] Glue BatchDeleteTable is unsupported Service AWS Glue AWS API…
- User
ISSUE DESCRIPTION
[BUG] Glue BatchDeleteTable is unsupported
Service
AWS API Action
Expected behavior
AWS behavior supports
BatchDeleteTable. When the request contains one existing table and one missing table, AWS deletes the existing table and returns anErrorsentry for the missing table.AWS behavior verified with AWS CLI:
{ "Errors": [ { "TableName": "missing_table", "ErrorDetail": { "ErrorCode": "EntityNotFoundException", "ErrorMessage": "Table missing_table not found" } } ] }A subsequent
GetTablefor the existing table returnsEntityNotFoundException.Actual behavior
Floci
floci/floci:1.5.22rejectsBatchDeleteTableas an unsupported action.aws: [ERROR]: An error occurred (InvalidAction) when calling the BatchDeleteTable operation: Action BatchDeleteTable is not supportedReproduction
endpoint=http://localhost:4566 export AWS_ACCESS_KEY_ID=<redacted-secret> AWS_SECRET_ACCESS_KEY=<redacted-secret> AWS_DEFAULT_REGION=us-east-1 db=test_floci_batch_delete aws --endpoint-url "$endpoint" glue create-database --database-input "Name=$db" aws --endpoint-url "$endpoint" glue create-table \ --database-name "$db" \ --table-input 'Name=existing_table,StorageDescriptor={Columns=[{Name=id,Type=int}]}' aws --endpoint-url "$endpoint" glue batch-delete-table \ --database-name "$db" \ --tables-to-delete existing_table missing_tableEnvironment
- Floci version / image tag:
floci/floci:1.5.22 - Java SDK version (if applicable): AWS CLI
- How you're running Floci (Docker / native /
mvn quarkus:dev): Docker
Interface
Type: Function Name: batchDeleteTables Path: src/main/java/io/github/hectorvent/floci/services/glue/GlueService.java Input: String databaseName, List tableNames Output: List<GlueService.BatchDeleteTableError> Description: Deletes multiple tables by name within a database, skipping and reporting errors for any tables that are not found. Use this to process the
BatchDeleteTableAWS Glue API action.ADDITIONAL ADVICE
Since you are given a git repository, you can use git commands to simplify your work. For example, if you made a mistake and want to revert your changes, you can use
git checkout <file>to restore the file to its original state. You can also reset all changes in the repository usinggit reset --hardcommand. Additionally, you can usegit stashandgit stash popto temporarily save your changes and restore them later. Finally, you can see the changes that you've made (which will be submitted when you callsubmit) usinggit statusorgit diffcommands. However you don't need to usegit addorgit commitbefore submitting your changes. In fact,submitonly submits currently unstaged changes because it usesgit diffto get the changes that need to be submitted.CHECKLIST
Before submitting your solution, please go over the following checklist and make sure you've done everything:
- If an error was reported in the issue description, I have successfully reproduced it.
- If an error was reported in the issue description, I have confirmed that my fix resolves the error.
- I have thought about edge cases and made sure my fix handles them as well.
- I have run existing tests in the repository that might have been affected by the change I made and confirmed that they pass. I want you to list every bullet from this checklist and write your reasoning for why you think you did it or didn't need to.
Repository has been uploaded and your shell is currently at the repository root. Time to solve the issue!
(Current directory: /floci, current file: none) bash-$
- Floci version / image tag:
- Assistant
I’ll first inspect the Glue service, API routing, models, and relevant tests to understand how neighboring batch operations are implemented. Then I’ll reproduce the unsupported action through the project’s test/runtime mechanism, implement the service and endpoint mapping, and run focused plus broader tests.
- Assistant
The Glue implementation is concentrated in
GlueJsonHandlerandGlueService, with direct unit tests for the service. I found no existing Glue batch-delete support, so I’ll now inspect action dispatch, table deletion semantics, storage behavior, and test conventions before making a minimal compatible change. - Assistant
The handler uses an explicit action switch and AWS-style PascalCase response keys. To ensure partial success is correct, I need the exact
deleteTableimplementation and whether partitions are cascaded. I’ll isolate those methods and inspect integration-test patterns and JSON serialization configuration, especially record property naming. - Assistant
deleteTableis intentionally idempotent/silent and therefore cannot itself distinguish missing entries. The new batch method should check each normalized table key, delete existing tables (including partitions), and accumulate per-item errors without aborting. I’ll verify the global Jackson naming strategy so the service’s nested error records serialize exactly asTableName,ErrorDetail,ErrorCode, andErrorMessage, and inspect controller routing to reproduce the current HTTP failure. - Assistant
The project’s Glue model classes explicitly annotate AWS field names; plain Java records would otherwise serialize lower camel case. I’ll follow the issue’s requested service output type while annotating record components with
@JsonPropertyfor exact wire compatibility. Before editing, I’ll run a focused existing integration test request forBatchDeleteTable(using a temporary test is forbidden, but a curl/runtime or existing test mechanism can establish the unsupported switch; the source switch itself already deterministically shows the reportedInvalidAction). I’ll also inspect build/test profiles to choose the fastest safe verification. - Assistant
I’ll implement the requested
batchDeleteTables(String, List<String>)interface directly inGlueService. It will validate the database once, preserve request order, use case-insensitive existing key semantics, cascade deletion throughdeleteTable, and return one annotated error record per absent table with the AWS message shown in the issue. The handler will parseTablesToDeleteand always return anErrorsarray, including an empty array on complete success. - Assistant
Python is unavailable in the environment, so no files were changed. I’ll apply the same focused edits using the repository’s non-interactive editor commands, then inspect the resulting diff.
- Assistant
The line-number insertion replaced
deleteTable’s closing brace rather than inserting after it; inspection caught this before compilation. I’ll restore that brace, add the two annotated public record types beside existing service result records, and then add the handler case. - Assistant
The service is structurally correct now; only minor blank-line style remains. I’ll use literal block replacement for the handler to avoid further line-number insertion ambiguity, then format the service spacing and compile.
- Assistant
The functional diff is complete. I’ll clean the two missing separator blank lines with
sed, then run the focusedGlueServiceTestand Glue catalog integration test. These tests compile both modified classes and exercise table lifecycle/HTTP serialization infrastructure; afterward I’ll perform a direct HTTP reproduction of the exact mixed existing/missing batch request if the environment permits. - Assistant
The Maven wrapper failed before running tests because this container has no
HOMEenvironment variable, not because of the code. I’ll rerun with a command-localHOME=/root(without modifying repository configuration). - Assistant
Both focused suites passed. To verify the exact reported behavior end-to-end rather than relying only on compilation and neighboring tests, I’ll start Quarkus in the background, issue raw AWS JSON 1.1 requests for create database/table, mixed batch deletion, and subsequent get, capture status/body, then stop the process. This does not add or alter tests.
- Assistant
Quarkus dev mode paused at its first-run analytics consent prompt, so the server never started. I’ll terminate that stopped process and relaunch non-interactively with analytics disabled and stdin redirected from
/dev/null. - Assistant
The emulator is ready. I’ll now send the exact action sequence and print each HTTP status/body, including
GetTableafter deletion, then shut down dev mode cleanly. - Assistant
The end-to-end reproduction now exactly matches the issue: HTTP 200 with one correctly shaped missing-table error, while the existing table is deleted and later returns
EntityNotFoundException. I’ll inspect repository status for runtime artifacts, review the final source around changes, and run all Glue-named tests to cover schema registry and catalog interactions before final submission. - Assistant
All Glue-named tests passed. The review shows two missing blank separators (cosmetic only) because this environment’s
sed a\did not insert empty lines as expected. I’ll correct those withawk, verify no unintended files or whitespace errors, and inspect the complete final diff.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.
Identical first prompt
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-27BCompare side by side →
Qwen/Qwen3.6-27BCompare side by side →