Member since
10-29-2015
98
Posts
10
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1272 | 06-24-2022 09:06 AM | |
2512 | 01-19-2021 06:56 AM | |
50631 | 01-18-2016 06:59 PM |
09-27-2023
05:25 AM
@TommyH Login to DB server where CM is storing metadata and then will need to delete the authentication backend entry. Please refer to below queries: select ATTR, VALUE from CONFIGS where ATTR = 'auth_backend_order'; delete from CONFIGS where ATTR = “auth_backend_order” and SERVICE_ID is null Hope this helps. Thanks snm1523
... View more
07-12-2023
02:05 AM
Hello All, Just checking if anyone is aware or can guide me to a documentation that would provide details of comparison between CDP Private Cloud vs HPE Ezmeral Data Fabric Platform. I have read somewhere that HP took over MapR and then formed HPE Ezmeral. However, can't find what are the differences. Please advise. Thanks snm1523
... View more
Labels:
06-16-2023
11:11 AM
Hello, We are on CDP 7.1.7 SP1 and as per my understanding when DistCp is executed with below parameters, it does the following: 1. update: this will update the files in destination that have got modified at source 2. delete: this will delete the files in destination that exist in destination but not in source. Apart feom above, it will copy over any new files at source that do not exist in destination. While copy and update is happening, it does not delete the files instead duplicates them and hence, the data count at destination is double than the source. Kindly help urgently as we are at the verge of initiating heavy data copy. Thanks snm1523
... View more
Labels:
06-09-2023
05:57 AM
Hello, How do we fetch the number of columns each table has in each DB from HMS DB? I have an urgent need to do a comparison for the number of columns each table has in each DB between 2 clusters. Doing that manually is practically impossible. Kindly help Thanks snm1523
... View more
Labels:
06-09-2023
05:53 AM
@smruti - thank you for the response
... View more
06-07-2023
11:29 PM
Hi, How do we change the InputFormat and OutputFormat of an existing Hive table? I tried below, but got an error: alter table <table name> SET InputFormat "org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat"; Error: Cannot recognize input near 'SET' 'InputFormat' 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' Kindly suggest
... View more
Labels:
06-06-2023
08:02 PM
Hello, Is there a way get the hdfs locations of all tables in CDP 7.1.7 SP1? I tried running a for loop against a list of tables on below command, however, it will take ages to get the list as I am looking forward to 66k+ tables. hive -e “desc formatted <table>;” | grep Location Thought of to get from HMS DB directly, however, I can only see DB location URI, but nothing specific to tables. Kindly help as this is urgent. Thanks snm1523
... View more
Labels:
03-04-2023
06:44 AM
Hello @smdas, Thank you for the reply. I attempted you first suggestion to check permissions in Ranger policies. Doing this i found ranger authorization was not enabled in Solr, which I did and ensured policies are updated correctly and applied. Still got the same problem and even in incognito mode. not able to completely understand you third suggestion. How will I ensure that SPNEGO is properly configured. Thanks Sunil
... View more