[HIVE-26952] set the value of metastore.storage.schema.reader.impl to org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader as default

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 17/Jan/23 07:36
• Updated: 15/Aug/23 06:33
• Resolved: 10/May/23 13:22

Description

With the default value of

 

DefaultStorageSchemaReader.class.getName()

 

in the Metastore Config, metastore.storage.schema.reader.impl

below exception is thrown when trying to read Avro schema

Caused by: org.apache.hive.service.cli.HiveSQLException: MetaException (message:java.lang.UnsupportedOperationException: Storage schema reading not supported)
    at org.apache.hive.service.cli.operation.GetColumnsOperation.runInternal(GetColumnsOperation.java:213)
    at org.apache.hive.service.cli.operation.Operation.run(Operation.java:247)
    at org.apache.hive.service.cli.session.HiveSessionImpl.getColumns(HiveSessionImpl.java:729)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
    at org.apache.hive.service.cli.session.HiveSessionProxy.access-zsh(HiveSessionProxy.java:36)
    at org.apache.hive.service.cli.session.HiveSessionProxy.run(HiveSessionProxy.java:63)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:422)
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)
    at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
    at com.sun.proxy..getColumns(Unknown Source)
    at org.apache.hive.service.cli.CLIService.getColumns(CLIService.java:390)

setting the above config with org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader resolves issue

Proposing to make this value as default in code base, so that in upcoming versions we don't have to set this value manually

Issue Links

• links to: GitHub Pull Request #3959