Cloudera Community
snm1523
user rank
Expert Contributor

Re: Change input and output format of existing hiv...

by Expert Contributor in Support Questions
‎06-09-2023 05:53 AM
‎06-09-2023 05:53 AM
@smruti - thank you for the response ... View more

Change input and output format of existing hive ta...

by Expert Contributor in Support Questions
‎06-07-2023 11:29 PM
‎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

Re: All hive tables location

by Expert Contributor in Support Questions
‎06-07-2023 10:51 PM
‎06-07-2023 10:51 PM
Thank you for the respone @ggangadharan  ... View more

All hive tables location

by Expert Contributor in Support Questions
‎06-06-2023 08:02 PM
‎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

Re: Solr failing to collect audit and logs

by Expert Contributor in Support Questions
‎03-04-2023 06:44 AM
‎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

Solr failing to collect audit and logs

by Expert Contributor in Support Questions
‎03-01-2023 05:37 AM
‎03-01-2023 05:37 AM
Hello,   Have recently deployed a CDP 7.1.7 SP1 cluster and unable to figure out issues with Solr service. When I open Solr Admin UI, it does opens the UI but with red strips and no information related to system, logs, audits, collections, etc. Ideally we should be able to see some system info on the home page and also various logs when in Logging section, and so on.   I checked in logs but do not see any error.   Kindly help / guide on how this can be investigated. Thanks snm1523 ... View more

URGENT: MIgrate Hive data from HDP 3 to CDP 7 PB

by Expert Contributor in Support Questions
‎02-14-2023 03:11 PM
‎02-14-2023 03:11 PM
Hello All,   Please help with some references / documentations / guide / steps on how do we migrate Hive metadata from HDP3 to CDP 7 PB. I started reading through the HMS Mirror tool, but to be honest, was unable to translate how it be used. This is a bit urgent, so any help would be really helpful.   Thanks snm1523 ... View more

Re: URGENT: Enabling AD KDC on CDP 7.1.7

by Expert Contributor in Support Questions
‎02-08-2023 03:22 AM
‎02-08-2023 03:22 AM
Was able to get this fixed. We ultimately identified there were some permissions for child objects not given yet. We got on a call with AD team and asked for a screen share to validate the permissions and then found it is not assigned yet.   Thanks ... View more

Re: URGENT: Enabling AD KDC on CDP 7.1.7

by Expert Contributor in Support Questions
‎01-18-2023 11:15 PM
‎01-18-2023 11:15 PM
Thank you for the response @tj2007. We have ensured that the required permissions are assigned to the account that is provided to Cloudera to create principals.   we further tweaked some settings and also after a quick modification to gen_credentials_ad.sh script (post discussion with Cloudera support) got through with error. However, now getting below error:   We have scheduled a call later today with Cloudera once again to discuss this. However, if you may be able to suggest something would be helpful. Thanks snm1523 ... View more

URGENT: Enabling AD KDC on CDP 7.1.7

by Expert Contributor in Support Questions
‎01-17-2023 02:57 PM
‎01-17-2023 02:57 PM
Hello,   I am in process of setting up a CDP 7.1.7 cluster. At the moment, CM 7.6.1 is installed and integrated to AD on LDAPS protocol (Had to select authentication type as LDAP for the integration to work even though we have AD being used). Next step is I have added few basic services i.e. HDFS, YARN and Zookeeper and now I am enabling Kerberos. At the step of Generating credentials it fails with attached screenshot. However, in the same window I noticed that CM is trying to connect to AD on LDAP protocol on port 389. Ideally it should be connecting via LDAPS on 636 as we have TLS also configured and enabled. Not sure if this is even relevant.   From where does CM gets the LDAP URL? I tried to understand gen_credentials_ad.sh script at /opt/cloudera/cm/bin, however, did not completely interpret.   Please help as this is bit urgent.   Thanks snm1523 ... View more
Contact Me
Online
Offline
Last Visited
‎01-16-2025 08:57 AM
Community Statistics
Member Since ‎10-29-2015 07:36 PM
Last Visited ‎01-16-2025 08:57 AM
Posts 123
Kudos received 31