- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
message:java.lang.UnsupportedOperationException: Storage schema reading not supported
Created 10-07-2021 11:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm getting the error "
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
Created 10-07-2021 10:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To resolve this issue, configure Hive Metastore to use SerdeStorageSchemaReader implementation:
- Go to Ambari > Hive > Config > Custom hive-site.
- Set the following property to configure Hive Metastore:
metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader
Created 10-12-2021 07:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created 10-12-2021 09:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@MikeB please provide the screenshot
Created 10-12-2021 12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created 10-13-2021 02:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please ignore the property type,please fill in key and value
Created 11-02-2021 05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Even I am seeing a similar issue while trying to discover the schema of a table created with Regex Serde. However, we are using HDP 2.6.5 in our environment and wanted to know if this parameter
metastore.storage.schema.reader.impl and the suggestion provided in this thread is applicable to the version of the HDP that we are using ?
Could you please let us know in which version of the HDP and Hive this has been introduced ?
Regards
Created 10-07-2021 10:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 10-10-2021 11:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Regards,
Vidya Sargur,Community Manager
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
Created 09-08-2022 06:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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