Don't know, yet, have not had time to investigate. ... View more

Thank you. We contacted Liquibase. Unfortunately, they don't have a built-in extension of Hive/Impala extension. Though they promise to look into this requirement in more detail. Hopefully, they come-up with a solution soon. ... View more

@Gcima009 are you trying to collect the logs with the same user that you submitted the job with? This query completed the map phase, and failed in reducer phase. If you are not able to collect the app logs, do check the HS2 log with the query ID hive_20211210173528_ff76c3df-a33b-41d0-b328-460c9b65deda if you get more information what caused the job to fail. ... View more

@HareshAmin, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

@mhchethan Yes, you could mention multiple LDAP URLs separated by spaces. Hive will try the URLs in the mentioned order until a connection is successful.   Ref: hive.server2.authentication.ldap.url    ... View more

Yes, that is the issue. Schema across all the tables is not same. For that we are trying to fill in NULL while using SELECT statement on each table for those columns which are not present in that table.  The changes for columns are not consistent accross tables. That is only few tables might update, few remain same.  ... View more

@sat_046, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

Thanks @smruti . Will try this and update with results. ... View more

@hxn We should not have any hiveserver2 under "Hive" service. hiveserver2 should be present only under "Hive on Tez".   If you have a hiveserver2 instance under "Hive" service, please delete it. ... View more

@dr If it's a managed table, you could get its size from TABLE_PARAMS table: e.g. SELECT a.TBL_NAME AS `TABLE`, b.PARAM_VALUE AS `SIZE` from TABLE_PARAMS b INNER JOIN TBLS a where a.TBL_ID=b.TBL_ID and b.PARAM_KEY='totalSize';   You could change the you need it. But, if there are external tables, or the table stats are not generated regularly, then you might not get the correct data.   You could get the table size using HDFS file system commands as well:   hdfs dfs -du -s -h <path to the table location>   This will give you more accurate data. ... View more