Skip to main content
MikeB
Silver ⭐️⭐️
Oct 7, 2021 6:08 PM UTC
Question

message:java.lang.UnsupportedOperationException: Storage schema reading not supported

I'm getting the error "

message:java.lang.UnsupportedOperationException: Storage schema reading not supported"
 
I've found this online and similar articles to it:
 
That says to "To resolve this issue, add the following property to the hive_site.xml file in the cluster configuration and restart the Data Integration Service: metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader​"

I'm running Hive 3.1.5.  I have hive-site.xml files on all of the hive clients in the cluster as well as on the server.  I don't see an option to add that value to the Hive configs in the Ambari GUI.  Also, when I look at the Ambari GUI, there's no Data Integration Service for Hive.  

 

So, to fix that issue, do I add that line to all of the client hive-site.xml files then stop/start certain Hive servers on the Ambari GUI?  Or is this all command line and outside of that GUI?  

 

Please advise when you can.  TIA

 
 
 

9 replies

balajip
Gold ⭐️
Gold ⭐️
Oct 8, 2021 5:43 AM UTC

@MikeB 

To resolve this issue, configure Hive Metastore to use SerdeStorageSchemaReader implementation:

  1. Go to Ambari > Hive > Config > Custom hive-site. 
  2. Set the following property to configure Hive Metastore:
    metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader
Translate
MikeB
MikeBAuthor
Silver ⭐️⭐️
Oct 12, 2021 2:24 PM UTC

Thanks for the prompt response!  One follow-up question:  In Ambari, when I go to Add Property in Custom hive-site, There's a box for Property Type, and the choices in it are:  PASSWORD, USER, GROUP, TEXT, ADDITIONAL_USER_PROPERTY, NOT_MANAGED_HDFS_PATH, and VALUE_FROM_PROPERTY_FILE.  Which Property Type do I use for that?

Translate
asish
Gold ⭐️⭐️⭐️
Gold ⭐️⭐️⭐️
Oct 12, 2021 4:07 PM UTC

@MikeB please provide the screenshot

Translate
asish
Gold ⭐️⭐️⭐️
Gold ⭐️⭐️⭐️
Oct 8, 2021 5:43 AM UTC

@MikeB 

If you are sure about the solution you can add the property in "custom hive-site" and "custom hive-metastore-site"

Add the property and value.

 

 

Please accept this as solution,if this works

Translate
VidyaSargur
Community Manager
Community Manager
Oct 11, 2021 6:32 AM UTC

@MikeB, Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  

Translate
Regards, Vidya Sargur Madabhushi| Senior Community Manager | Was your question answered? Make sure to mark the answer as the Best Answer. If you find a reply useful, say thanks by clicking on the thumbs up button.
cesar_rodriguez
Silver ⭐️⭐️
Sep 8, 2022 1:19 PM UTC

This issue is still present in CDP 7.1.7 sp1.

We had to edit the advanced snippet for hive-site.xml for the Metastore service and add:

metastore.storage.schema.reader.impl
org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader

Translate