quintoandar / hive-metastore-client

A client for connecting and running DDLs on hive metastore.
Apache License 2.0
52 stars 15 forks source link

alter and drop tables #40

Closed rotten closed 3 years ago

rotten commented 3 years ago

Feature related:

Sorry to bother you. I have a need to alter and drop tables. There aren't any examples in your code base for how to do that, and it really isn't obvious. For now, when I need to alter a table, I'm dropping out to the presto command line and dropping it, then jumping back into this client to build the updated version. It is rather inelegant.

If this is already supported and you could point me to a better approach, I'd love to learn more.

Thank you!

felipemiquelim commented 3 years ago

Hello there @rotten ! I think you can still work through the library to drop and alter tables. You still have access to the 'base methods' that were generated from Thrift, you can find them here.

We also tried to document the possibility of using said methods here.

For instance, you can use the method: .drop_table(dbname='db_a', name='table_b')

We still have not found the chance to use those 'base methods' therefore we did not add any example code, since we are creating examples as we go. Yet, we will consider adding examples to clarify further usage of them :smile:

rotten commented 3 years ago

Aha, that is very helpful, and was not at all obvious. Thank you.