@David2  does the file exist?? What kind of file is this?  Please share the DDL for the table. Please also share the application logs of the failed job Share application logs for the failed compaction job too. ... View more

@Venk123 I think you are hitting https://issues.apache.org/jira/browse/HIVE-3363   I would request to raise case to get it verified and if verified you would receive a patch. ... View more

@P2as Can you. please provide a testcase.     a.DDL   b. Sample data   c. Steps to test   d. WHat is the distribution and version,so that we can test internaly ... View more

@Anitauzanna could you explain the meaning of below    the second column is date in int   Could you please provide an example for the scenario?? ... View more

@David2 Is this a managed table? I don't see delta/base dir hdfs://xxx/user/hive/warehouse/xxx.db/table/dt=2021-09-25/hr=00/_tmp_d5b133c1-68a1-4e98-af45-308ffbdc9f42   Can you try a  MAJOR compaction and run the job,if this is a MANAGED table???? ... View more

Lets take an example   Hiveserver1 ==> HMS ==> Mysqldatabase with schema(hive) ==> Contains databases as students(student database is in hive not MySQL)   Hiveserver2 ==> HMS ==> Mysqldatabase with schema(test) ==> Contains databases as employee(employee database is in hive not MySQL)]   When connected to beeline ==> hiveserve1 ==> Show databases would yield students   When connected to beeline ==> hiveserve2 ==> Show databases would yield employees   This must be performed using config groups in ambari.   In CM it must be used using role instances.           ... View more

@mailsmail  This is not tested yet. You can create a POC environment and test.    I don't have to create/run new MySQL instance for each metastore. Ans: A separatevschema is required. Avoid using hive/metastore as this would be by-default. use a different database/schema. Is it possible for one hiveserver2 to connect to multiple metastore, so all user will use the same endpoint? or do I have to run another hiveserver2 for each metastore? Ans: You can have one hiveserver2 to connect to multiple HMS by updating "hive.metastore.uris" field. You need to create a separate config group for another HMS with different database and also you need a different hiveserver2 and update "hive.metastore.uris" accordingly   Please let me know,if you have any queries or accept it as solution,if your queries are answered. ... View more

@mailsmail    You can have below approach:   1. create a separate schema in metastore db named user2 2. Add a hivemetastore pointing to same MySQL but different db user2 on hostA 3. Add a separate hiveserver2 on hostA 4. Create a config group and add the hostA 5. Override metastore uri for hiveserver2   This is one way you can achieve multitenancy.Your databases in hive would remain independent. Please let us know if you have additional quries. ... View more

ORC is not supported in CDH . Please check the documentation. https://docs.cloudera.com/documentation/enterprise/6/release-notes/topics/rg_cdh_633_known_issues.html#id_lck_wmv_slb ... View more