About prakodi

prakodi · ‎02-17-2023

Thank you very much. Regards, PK

prakodi · ‎02-17-2023

Hi, Thank you for the reply, but if I know the role or group, I can easily get the details from above commands, but for a specific DB , if I want to find out what are the roles assigned, is there a way to do it ? Assume, my schema name is schema1, how to find out the roles assigned to this schema ? Thank you. Regards, PK

prakodi · ‎02-14-2023

CDH 6.3

prakodi · ‎02-10-2023

Hi All, I want to find out what are the roles / groups assigned to a DB / Schema in Hive, how I can get those details ? please suggest. Thank you. Regards, PK

prakodi · ‎01-16-2023

Hi All, I need to drop around 5000 tables from a schema - schemaDB, am using below script, tableNameList list contains all the 5000 tables names which I need to drop from the schema, but as the loop calling beeline process each time for each drop, the process to drop all the 5000 tables is taking lot of time, do we have another option where we can acheive it fastly. for tableName in $(cat tableNameList) do beeline -u "jdbc:hive2://server1.com:10000/default;principal=hive/server1.com@.com;" -e "drop table schemaDB.$tableName" >> $drop.log done Thanks praKodi

prakodi · ‎01-11-2023

Hi Tarun, This solutions looks fine, but unfortunately we are still using CDH6.3 version only, so we dont use Ranger, so is there any option for CHD 6.3 version ? Thanks, PK

prakodi · ‎01-10-2023

Hi All, Do we have any script to export all the DDL's of the table for a schema in Hive ? we have a schema name - staging_DB and its contains around 2000 tables, now we need to export all the DDL's of this tables to a txt file so that we can run this DDL's in another setup. Please suggest if we have any script or any easy way to do it, thank you. - PK

prakodi · ‎01-10-2023

Hi, we need to sync only few schemas, this solution is completely moving all the metastore from one region to another region. Just for one schema which contains 100's of tables, we want to sync the DDL's to another region.

prakodi · ‎01-06-2023

Hi All, Need advice, how we can export all the DDL of one scheme from Hive ( from QA region, a schema with around 2000 tables) to Dev or ACPT region, only DDL's needed to be in sync , not worried about the data, so do we have any option or script to import / export all the DDL's from one region to another region in one go, please suggest, thank you. PK

Online	Offline
Last Visited	‎01-30-2024 09:47 PM

Member Since	‎06-22-2022 08:01 AM
Last Visited	‎01-30-2024 09:47 PM
Posts	9

Cloudera Community

Re: How to find out the roles / groups assigned to...

Re: How to find out the roles / groups assigned to...

Re: How to find out the roles / groups assigned to...

How to find out the roles / groups assigned to a s...

How to drop large number of tables from a schema u...

Re: How to sync schemas from one region to another

How to export DDL's of all table's for a schema in...

Re: How to sync schemas from one region to another

How to sync schemas from one region to another