- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Delete schema from Schema Registry
Created ‎07-11-2017 09:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Is is possible to delete schemas from the Schema Registry, and if not, can this functionality be added to the front end?
In my development environment I've created a bunch of old schema's I'd like to delete to avoid clutter and confusion between not-in-use schemas.
Thanks
Created ‎07-13-2017 09:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In schema registry (HDF-3.0), a schema is immutable & you can't delete/modify a schema.
Created ‎07-13-2017 09:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In schema registry (HDF-3.0), a schema is immutable & you can't delete/modify a schema.
Created ‎07-14-2017 07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The above answer is not fully correct. A schema can be modified but a schema + version appears to be immutable.
Since delete functionality does not exist - can it be added?
If a mistake is made when adding a schema then it cannot be deleted. The schema evolution compatibility prevents me from completely replacing an existing schema and I can't rename it. So instead it seems we need to create a new schema each time, and change configuration elsewhere to now use the new schema name. The old schema still appears in the list which over time becomes confusing as to which schema is correct and in use.
For example in development environments I end up with a lot of schemas which are no longer needed, eg my_schema, my_schema_1, test_my_schema, test_1, schema, working_schema .... which will cause confusion.
Created ‎08-08-2017 01:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Deleting or marking invalid for schemas is a good idea, I have mentioned to the team as I would like to do so as well. I have some I created by mistake.
Created ‎08-08-2017 01:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am able to delete a schema now by going to the underlying MySQL database and deleting the relevant records.
Created ‎10-16-2017 10:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I agree with Bjorn Olsen and Timothy Spann, ability to edit or remove mistaken schemas would be valuable. I've already messed up my sandbox by getting the forward/backward compatibility wrong on one schema, and marking others with group 'Test' and 'test' when I wanted them in the same group for example.
Created ‎05-17-2018 12:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Which is the table/records that we have to delete in order to delete all the versions of a schema ?
Is there a command available in hortonworks to delete a schema by specifying subject name ? (Confluent Schema registry command - curl -X DELETE http://localhost:8081/subjects/{subject_name}/versions/1)
I'm using hortonworks-registry-0.5.1
Created ‎10-17-2018 09:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Al ejecutar el comando se genera un error, ¿cómo puedo eliminar los esquemas que no uso?
curl -X BORRAR http: // localhost: 7788 / subject / TEST_2 / versions / 1 {"responseMessage": "Se produjo una excepción con el mensaje [Método HTTP 405 No permitido] mientras se procesaba la solicitud."}
Created ‎11-15-2018 03:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it can be done with sql
Created ‎06-27-2019 12:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The above question and the entire reply thread below was originally posted in the Community Help track. On Thu Jun 27 00:33 UTC 2019, a member of the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about services in HDF.
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.
