@donno  I know how frustrating it is. I have just downloaded a fresh image of HDP 2.6.5  unpacked the image and performed the classic steps all all is looks fine I hope you a step that you might have missed.  Here we go. Sandbox settings, Memory, CPU, Network I enabled on Bridged Adapter as my laptop is connected to my LAN a class C network   Uncompressed the HDP  2.6.5 image and on successful extraction, I get the IP and URL with my local IP     My Local hosts file   Reset the root  default is root/hadoop and Ambari admin passwords this automatically starts the Ambari server After the successful start-up of Ambari I can now access the Ambari UI using my local LAN IP All service is up  and you can see the Ambari and HDP versions I have  demo'ed this 100's of time in here I hope you get successful and happy ending  Happy hadooping ... View more

@Amn_468    The NameNode is solely responsible for the Cluster Metadata so please increase the NN heap size and restart the services. Please revert    ... View more

@Amn_468  Increasing the Java Heap Size for the NameNode and Secondary NameNode Services,you could be using the default 1GB setting for heap size As a general rule of thumb take a look at the configuration of your Heap Sizes for every 1 Million Blocks in your cluster should have at least 1GB of Heap Size. 2 Million Blocks 2GB heap size 3 Million Blocks 3GB heap size ..... n Million Blocks n GB heap size After increasing the Java Heap Size and restart the HDFS Services that should resolve the issue.   Please revert ... View more

@sriram72  Can you share screenshots I just posted a response to a similar query? Please have a look at this Sandbox  issue    Hope that helps ... View more

@ParthiCyberPunk  Unfortunately, you didn't share the connect string. below is an example you could use jdbc:hive2://host:10000/DB_name;ssl=true;sslTrustStore=$JAVA_HOME/jre/lib/security/certs_name;trustStorePassword=$password Substitute  host,port, truststore location and certificate name and password accordingly. Keep me posted     ... View more

@anhthu  You will need to fire-up your cluster  start by scrolling at the bottom  see the attached screen and start the Cloudera Manager [CM]  the blue triangular shape will give you a drop-down menu chose start you will see some startup logs and if all goes well it will be green   You can see exactly the same error I have on my Quickstart sandbox because my service are not started  again see the attached screenshot on the blue inverted triangle you will see a drop-down list chose start the services. This will start all the service in the right order ,again once all is GREEN you are good to go   Happy Hadooping ... View more

@akoudoum  Great it worked for you  Happy hadooping ... View more

@sgovi  Can you confirm you have only one network card enabled? Please share the output of the below command from the web-shell CLI $ ifconfig       Please revert    ... View more

@cbfr  Before you decide whether the cluster has corrupt files can you check the replication factor? If it's set to 2 then that normal  The help option will give you a full list of sub commands $ hdfs fsck / ? fsck: can only operate on one path at a time '?' The list of sub command options $ fsck <path> [-list-corruptfileblocks | [-move | -delete | -openforwrite] [-files [-blocks [-locations | -racks | -replicaDetails | -upgradedomains]]]] [-includeSnapshots] [-showprogress] [-storagepolicies] [-maintenance] [-blockId <blk_Id>] start checking from this path -move move corrupted files to /lost+found -delete delete corrupted files -files print out files being checked -openforwrite print out files opened for write -includeSnapshots include snapshot data of a snapshottable directory -list-corruptfileblocks print out list of missing blocks and files they belong to -files -blocks print out block report -files -blocks -locations print out locations for every block -files -blocks -racks print out network topology for data-node locations -files -blocks -replicaDetails print out each replica details -files -blocks -upgradedomains print out upgrade domains for every block -storagepolicies print out storage policy summary for the blocks -maintenance print out maintenance state node details -showprogress show progress in output. Default is OFF (no progress) -blockId print out which file this blockId belongs to, locations (nodes, racks)   It would be good to first check for corrupt files and then run the delete    $ hdfs fsck / -list-corruptfileblocks Connecting to namenode via http://mackenzie.test.com:50070/fsck?ugi=hdfs&listcorruptfileblocks=1&path=%2F ---output-- The filesystem under path '/' has 0 CORRUPT files A simple demo here my replication factor is 1  see above screenshot when I create a new file in hdfs the default repélication factor is set to 1 $ hdfs dfs -touch /user/tester.txt Now to check the replication fact  see the number 1 before the group:user hdfs:hdfs $ hdfs dfs -ls /user/tester.txt -rw-r--r-- 1 hdfs hdfs 0 2020-10-18 10:21 /user/tester.txt   Hope that helps            ... View more

@sgovi  I have just downloaded a Virtual box sandbox image and imported it into the VirtualBox successfully. In my configuration, I  enabled only one network card Bridge Adapter so it picks the IP from my LAN of 192.168.0.x   After uncompressing the Docker image, the initial screen shows it picked my local LAN IP which I used to access the browser CLI as shown below.  Make sure you update your  windows hosts file in C:\Windows\System32\drivers\etc  Using the above  URL  change the initial  root and Ambari passwords see steps I completed the below steps changing the initial root password Hadoop and then reset the Ambai user password. Once that is successful is starts the Ambari server    sandbox-hdp login: root root@sandbox-hdp.hortonworks.com's password: You are required to change your password immediately (root enforced) Last login: Sat Oct 17 20:21:47 2020 Changing password for root. (current) UNIX password: New password:   Ambari user password reset steps   ambari-admin-password-reset Please set the password for admin: Please retype the password for admin: The admin password has been set. Restarting ambari-server to make the password change effective... Using python /usr/bin/python Restarting ambari-server Waiting for server stop... Ambari Server stopped Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Ambari database consistency check started... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start................................ Server started listening on 8080 DB configs consistency check: no errors and warnings were found.   Using the Local IP given to the VirtualBox from my LAN,I could access Ambari with the new password I reset above and restarted all serive though some were running. Can you confirm you followed those steps and still failed?? Happy hadooping ... View more

@nilesh_shrimant  If you want to get help you should share more detail like datatype and  the create external table snippet.   But I think this  post should your answer ... View more

@bhoken  In a kerberized cluster the Kafka ACL is leveraged by Ranger,if the Kafka plugin is enabled don't look further than the Ranger  Please share you Ranger-Kafka policy  ... View more

@kumarkeshav  The parameter you are looking for hbase.regionserver.global.memstore.size is found in the  hbase-site.xml   I don't know where this value can be separately edit or centrally by Ambari ... View more

@mike_bronson7  Once you connect the 10 new data nodes to the cluster Ambari automatically distributes the common hadoop config file i.e hdfs-site.xml,Mapred-site.xml,yarn-site.xml etc to those new nodes so they can start receiving data blocks.   My suggestion as a workaround would be to add these 10 new datanodes hostnames FQDN or IP (separated by a newline character) in the dfs.exclude file on the NameNode machine, edit the <HADOOP_CONF_DIR>/dfs.exclude file and where <HADOOP_CONF_DIR> is the directory for storing the Hadoop configuration files. For example, /etc/hadoop/conf.   First, ensure the DNS resolution is working or your /etc/hosts are updated and the passwordless connection is working with those hosts. Once the 10 new nodes are in the dfs.exclude file the namenode will consider them as bad nodes so no data will be replicated to them as long as these hosts remain in the dfs.exclude file once you have updated the NameNode with the new set of excluded DataNodes.   On the NameNode host machine, execute the following command:   su <HDFS_USER> hdfs dfsadmin -refreshNodes   where <HDFS_USER> is the user owning the HDFS services   That should do the trick, once these hosts are visible in Ambari turn maintenance mode on so you don't receive any alerts The day you will decide to add/enable these 10 new datanodes you will simply cp or mv the dfs.exclude to dfs.include file located <HADOOP_CONF_DIR>/dfs.include these nodes will start heartbeating and notifying the NameNode that  thes DataNodes are ready to start receiving files and participating in the data distribution in the cluster.   On the NameNode host machine remember to execute the following command:   su <HDFS_USER> hdfs dfsadmin -refreshNodes     Don't forget to disable Maintenance mode on the new datanodes and remove them from  dfs.exclude file if you didn't rename or delete it.   Run the HDFS Balancer a tool for balancing the data across the storage devices of an HDFS cluster.   sudo -u hdfs hdfs balancer   The above balancer command has a couple of options either threshold or again the dfs.include and dfs.exclude see explanation below                                                 Include and Exclude Lists   When the include list is non-empty, only the datanodes specified in the list are balanced by the HDFS Balancer. An empty include list means including all the datanodes in the cluster. The default value is an empty list.   [-include [-f <hosts-file> | <comma-separated list of hosts>]]   The datanodes specified in the exclude list are excluded so that the HDFS Balancer does not balance those datanodes. An empty exclude list means that no datanodes are excluded. When a datanode is specified in both in the include list and the exclude list, the datanode is excluded. The default value is an empty list.   [-exclude [-f <hosts-file> | <comma-separated list of hosts>]]     If no df s.include file is specified, all DataNodes are considered to be included in the cluster (unless excluded explicitly in the dfs.exclude file). The dfs.hosts and dfs.hosts.exclude properties in hdfs-site.xml are used to specify the dfs.include and dfs.exclude files. Hope that helps  ... View more

@lxs    I have helped resolve this kind of issue a couple of times. Can you help with screenshots of your configuration of the sandbox? Memory Network  Splash screen After restarting the sandbox and any other screenshot you deem important ... View more

@vinod_artga    The first step is to check the Cloudera upgrade path using the My environment matrix calculator See screenshot below     After filling in all the information request this generates for you a report and warnings like Warning Upgrades from CDH 5.12 and lower to  CDP Private Cloud Base  are not supported. You must upgrade the cluster to CDH versions 5.13 - 5.16 before upgrading to  CDP Private Cloud Base . Warning For upgrades from CDH 5 clusters with Sentry to Cloudera Runtime 7.1.1 (or higher) clusters where Sentry privileges are to be transitioned to Apache Ranger, the cluster must have Kerberos enabled before upgrading It also gives you comprehensive details about the best approach and component incompatibilities, this is your source of true I would suggest you try it and revert HTH ... View more

@pazufst                                                                  How Ranger policies work for HDFS Apache Ranger offers a federated authorization model for HDFS. Ranger plugin for HDFS checks for Ranger policies and if a policy exists, access is granted to user. If a policy doesn’t exist in Ranger, then Ranger would default to the native permissions model in HDFS (POSIX or HDFS ACL). This federated model is applicable for HDFS and Yarn service in Ranger. For other services such as Hive or HBase, Ranger operates as the sole authorizer which means only Ranger policies are in effect. The option for the fallback model is configured using a property in Ambari → Ranger → HDFS config → Advanced ranger-hdfs-security   xasecure.add-hadoop-authorization=true   The federated authorization model enables to safely implement Ranger in an existing cluster without affecting jobs that rely on POSIX permissions to enable this option as the default model for all deployments. org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=XXXXX, access=READ, inode="/user/.snapshot/user_201806150000":w93651:hdfs:drwx------ Is self-explanatory does the user w93651 exist on both clusters with valid Kerberos tickets if the cluster is kerberized? Ensure the CROSS-REALM is configured and working.   Is your ranger managing the 2 clusters? HTH ... View more

@pazufst    You should toggle to RECURSIVE for the RWX permission on the hdfs should look like this  /databank/* The selection should look like      Hope that helps   ... View more

@pazufst  Doesn't it look strange that permissions are    /databank/.snapshot/databank_201904250000 :hdfs:hdfs:d---------   The normal permissions show be    rwx   Try that and revert  ... View more

@kvinod    If you have installed Yarn and MRV2 can you check the value of the below parameter in the yarn-site.xml  yarn.nodemanager.aux-services stop the services and change it to look like below <property> <name>yarn.nodemanager.aux-services</name> <value>mapreduce_shuffle</value> </property> Restart and let me know ... View more

@GangWar  Can you regenerate the keytabs through  Cloudare manager? That could resolve  the problem if it doean't please revert with the error cêncountered? ... View more

@wert_1311  Domain name changes will affect the KDC database. Kerberos is super sensitive to domain changes according to experience you will have to recreate the KDC database and regenerate the keytabs/principals to enable you applications to reconnect. Cluster hostname If the hosts in the cluster were re-named ie host1.old.com to host1.new.com then ensure those changes are also reflected or resolved by the DNS.   This is going a tricky one but fortunately, CM or Ambari will make your work easy now that your domain has changed the earlier generated keytabs have the old domain name . A keytab contains a pair of principals and an encrypted copy of that principal's key it's unique to each host since the principal names include the hostname and may be concatenated with the domain name Delete the old KDC database Usually, as the root user call the Kerberos database utility kdb5_util destroy assuming the old domain was OLD.COM this should delete the keytabs and principals linked to the old REALM,   # kdb5_util -r OLD.COM destroy You will need to manually delete the keytabs liked to the old REALM on the file system /etc/security/keytabs/ [HDP] or /etc/hadoop/conf/[CDH]. You will be prompted to confirm before destroying the database, usually, this is a better option if you have second thought rather than using the kdb5_util destroy -f will naturally not prompt you for a confirmation   Recreate the New KDC database Use the Kerberos database utility kdb5_util create [-s] assuming the new domain was NEW.COM # kdb5_util NEW.COM create # kdb5_util -r NEW.COM create -s With the -s option, kdb5_util will stash a copy of the master key in a stash file this allows a KDC to authenticate itself to the database utilities, such as kadmin, kadmind, krb5kdc, and kdb5_util best option.   Update Kerberos files. Make sure you update the below files to reflect the new REALM assuming your MIT KDC server's domain isn't changed. krb5.conf kdc.conf kadm5.acl Auth-to-local Rules jaas.conf files [if being used by applications] Enable Kerberos Using CM or Ambari the process is straight forward.   Please let me know if you need more help   ... View more

@anass  Hive and Impala have 2 distinct use-cases Hive, a data warehouse system is used for analyzing structured data. Uses HQL or the Hive Query Language which gets internally converted to MapReduce jobs which is fault-tolerant and a very good candidate for ETLs and batch-processing. On the other hand, Impala executes faster using an engine designed especially for the mission of interactive SQL over HDFS although unlike Hive, Impala is not fault-tolerance. But a fantastic MPP (Massive Parallel Processing) engine.   - Hive generates query expressions at compile time whereas Impala does runtime code generation for “big loops” with no need for data movement and data transformation for storing data on Hadoop, . - Impala no java knowledge is required programmatically accessing the data in HDFS or HBase a basic knowledge of SQL querying can do the work. - Impala performs best when it queries files stored as Parquet format. It's good for sampling data - Apache Hive is not ideal for interactive computing query whereas Impala is meant for interactive computing. - Hive is batch-based Hadoop MapReduce whereas Impala is more like MPP database. - Hive supports complex types but Impala does not. - Apache Hive is fault-tolerant whereas Impala does not support fault tolerance. So its the best candidate for batch processing which is prone to failures When a hive query is run and if the DataNode goes down while the query is being executed, the output of the query will be produced as Hive is fault-tolerant. However, that is not the case with Impala. If a query execution fails in Impala it has to be started all over again. - Hive can transform SQL queries into Spark or MR jobs making it a good choice for long-running ETL jobs for which it is desirable to have fault tolerance because developers do not want to re-run a long-running job after executing it for several hours.   For better comparison here is the benchmark HAWQ,Hive and Impala Hope that helps ... View more

@BBFayz  Below is the link with all the passwords you could be interested in. The default root password by default is root/hadoop but you will be requested to change that on the first logon   Sandbox passwords  learning rope Setup Static IP on RHEL Hope that helps ... View more

@kvinod  Can you share the steps you have accomplished and attach the specific errors that you are encountering? ... View more