stackabletech / stackabletech/trino-operator

Missing SerDeStorageSchemaReader class when creating tables with avro_schema_url

Open
#783 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

customer-request
Dominant language
Rust
Stars
63
Forks
13
Avg merge
1d 20h
Merged PRs (30d)
12

Description

When creating a Hive external table with the Avro schema URL defined the result is a table that cannot be queried or droped:

 create table hive.test.avro_test (
    LOAD_DATE varchar,
    ID varchar,
    EMAIL varchar,
    NAME varchar
)
with (
    format = 'AVRO',
    external_location = 'hdfs://hdfs/test/table1',
    avro_schema_url = 'hdfs://hdfs/schema/table1.avsc'
);

All operations on the table produce the following error:

SQL Error [16777216]: Query failed (#20250804_105604_00015_upgzh): org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader class not found
 
Once the table is created it can no longer be managed from Trino.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the SQL reproduction in the issue, using an external Hive table with format AVRO and avro_schema_url. Trace how the operator configures Trino and Hive for this table, then verify that the created table can be queried and dropped without the SerDeStorageSchemaReader class-not-found error.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.