hiveavrohive-serde

hive standalone metastore reading avro data with schema not working

we have usecase of presto hive accessing s3 file present in avro format. When we try to use standalone hive-metastore and read this avro data using external table ,we are getting issue SerDeStorageSchemaReader class not found issue

    MetaException(message:org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader class not found)
    at org.apache.hadoop.hive.metastore.utils.JavaUtils.getClass(JavaUtils.java:54)

We understand this error is coming because SerDeStorageSchemaReader class is not available in standalone-metastore.

i want to understand can be run hive-metastore without using hive/hadoop or there is any other option too?

Solution

  • standalone hive doesnt support avro. we need to install full hadoop plus hive version and start only hive metastore to fix it