Member since
01-19-2017
3682
Posts
633
Kudos Received
373
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2007 | 06-04-2025 11:36 PM | |
| 2344 | 03-23-2025 05:23 AM | |
| 1127 | 03-17-2025 10:18 AM | |
| 4442 | 03-05-2025 01:34 PM | |
| 2967 | 03-03-2025 01:09 PM |
03-29-2023
04:47 PM
2 Kudos
@vciampa I tried to recreate your scenarion using HDP and ODBC ODBC screens I created a hive database and table and used a non ssl connection as shown below as my HDP is not Secured, though the ODBS delivers a certificate in C:\Program Files\Cloudera ODBC Driver for Apache Hive\lib\cacerts.pem Ping from Windows DSN Config ODBC config SSL Config Table creation Connect test So it does work for non-TLS but when I enable TLS I get the below because TLS is not enabled on my HDP cluster , I will try in install sa self signed certificate and revert Geoffrey
... View more
03-24-2023
06:53 AM
@ambari275 These are the steps to follow assuming you are logged in as root # su - hdfs $ klist -kt /etc/security/keytabs/hdfs-headless.keytab Then the output should give you the principal to use $ kinit -kt /etc/security/keytabs/hdfs-headless.keytab
... View more
03-23-2023
11:02 AM
@BrianChan HUE uses a back end database and it would be interesting if you shared the creation steps The DB configuration is in the hue.ini check the [database] section for the path to the DB (or look at /dump_config/, desktop, database). If MySQL/MariaDB please check the config in /etc/my.cnf [mysqld] ... bind-address=0.0.0.0 default-storage-engine=innodb sql_mode=STRICT_ALL_TABLES Verify the DB connectivity mysql -u hue -p Enter password: <password> quit The HUE database file seems gone or not readable
... View more
03-23-2023
05:39 AM
@hive1 What is the hive version? Can you try the below and revert Set the below two properties before executing the rename partition hive> set fs.hdfs.impl.disable.cache=false; hive> set fs.file.impl.disable.cache=false; Then run the rename partition command hive> ALTER TABLE <table_name> (code='YATHAH%0188QW') RENAME TO PARTITION (code='new_name'); Share the output for further analysis
... View more
01-11-2023
11:00 AM
@mike_bronson7 Hadoop uses the attribute dfs.hosts.exclude in hdfs-site.xml as a pointer to a file where node exclusions should be adequately documented. Since there is no default value for this attribute, the Hadoop cluster will not exclude any nodes in the absence of a file location and a file in the absence of dfs.hosts.exclude If dfs.hosts.exclude is not set in your cluster, take the actions listed below. Shutdown the Namenode. Edit hdfs-site.xml and add a dfs.hosts.exclude entry with the file's location. This can be a text file with the hostname that you intend to remove should be added to the file described in dfs.hosts.exclude. Start the namenode Add the hostname to the file specified in dfs.hosts.exclude that you intend to remove when dfs.hosts.exclude is already configured. Run the following command to exclude a data node After adding the hostname to the exclusion run the below command to exclude the node from functioning as a Datanode after adding the hostname to the exclusion. $ hdfs dfsadmin -refreshNodes Below command will exclude the node from functioning as a Node Manager $ yarn rmadmin -refreshNodes After the above actions, you should see one data node marked as decommissioned in Ambari. No data blocks will be sent to this data node as YARN has already marked it as unusable Hope that answers your question
... View more
11-12-2022
01:09 PM
@hassan-ki5 This looks a typical CM database connection issue can you check and compare the entries in cat /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.type=[Oracle/mysql/postgresql] com.cloudera.cmf.db.host=localhost com.cloudera.cmf.db.name=scm com.cloudera.cmf.db.user=scm com.cloudera.cmf.db.setupType=EXTERNAL com.cloudera.cmf.db.password=scm Ensure the DB.password, name, and user are correct since you seem to be running Mysql can you check this page CM using Mysql
... View more
11-04-2022
03:36 PM
@lysConsulting Are you using embedded DB? if not can you log in to the HUE database from the CLI?
... View more
11-03-2022
03:50 PM
@lysConsulting This looks like a driver issue can you run the below it would affect your ambari server ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres/postgresql.jar Then retry the earlier steps or just create HUE database manually then with the credentials connect through the HUE service setup
... View more
10-31-2022
06:00 AM
@Ninja I see a difference in the networking can you change that and retry
... View more
10-30-2022
01:19 PM
@Ninja downloaded the 2.6.5 and there is no difference in the steps above. Please let me know if you still need help
... View more