Re: [EXTERNAL] Re: Slow Hive query with a lot of 'get_materialized_views_for_rewriting'

2023-11-16 Thread Eugene Miretsky
is called by mistake. > > Thanks, > > Butao Zhang > Replied Message ---- > From Eugene Miretsky > Date 11/16/2023 02:21 > To > Subject Slow Hive query with a lot of > 'get_materialized_views_for_rewriting' > Hey! > > We have a catalog with fairly a lot of data

Slow Hive query with a lot of 'get_materialized_views_for_rewriting'

2023-11-15 Thread Eugene Miretsky
s actually coming from a very old Hive version (1.1), and we migrated it to the newest version of the Metastore using the upgrade tool. In the original Hive version materialized views were not even supported. Cheers, Eugene -- *Eugene Miretsky* Managing Partner | Badal.io | Book a meeting /w

Metastore: How is the unique ID of new databases and tables determined?

2023-10-22 Thread Eugene Miretsky
Hey! Looking for a way to control the ids (DB_ID and TABLE_ID) of newly created databases and tables. We have a somewhat complicated use case where we replicate the metastore (and data) from a source Hive cluster to a target cluster. However new tables can be added on both source and target. We