@Johannes Peter The Kerberos plugin uses SPNego to negotiate authentication. HTTP indicates the type of requests which this service principal will be used to authenticate. The HTTP/ in the service principal is a must for SPNego to work with requests to Solr over HTTP. ... View more

try disabling the firewall. service iptables stop Please let me know if that helps ... View more

@Weidong Ding Port 8080 might be already in use. Usually tomcat runs on port 8080. You can optionally change the ambari port https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-reference/content/optional_changing_the_default_ambari_server_port.html ... View more

@Bill Schwanitz There is no single property such as server.user that can be modified. There are a lot of modifications/permissions that need to be set as a part of setting up of ambari-server user. Hence this is the only available option as far as I know. ... View more

@Bill Schwanitz I assume you want to run ambari-server under a non-root user. If so, you can run the ambari-server setup command. It can be executed even after ambari is already installed. Then select "Customize user account for ambari-server daemon" as "y" and enter the new user name. You will also need to take care of Sudoer Configuration https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-security/content/sudoer_configuration_server.html ... View more

@Sami Ahmad For some tables hive just looks at the table metadata and fetches the values which might not have been updated. There are two ways to approach this. 1. You can run ANALYZE TABLE pa_lane_txn and then run select count(*) statement. This will give you the correct value. 2. You can force hive to run a mapreduce job to count the number of rows by setting fetch task conversion to none; hive> set hive.fetch.task.conversion=none; ... View more

@Sami Ahmad try hive> set mapred.map.tasks = 32; ... View more

@Anishkumar Valsalam You can run the command desc database <db_name>. There you can find the location of hdfs directory where the db exists and then navigate to find the creation date. From hdfs you can run this command to find the creation date hdfs dfs -stat /apps/hive/warehouse/<db_name.db> ... View more

@Wilson Blanco You can set these variables in /etc/hadoop/conf/hadoop-env.sh file. Typical values of these variables look like export HADOOP_HOME=${HADOOP_HOME:-/usr/hdp/current/hadoop-client} export HADOOP_LIBEXEC_DIR=/usr/hdp/current/hadoop-client/libexec ... View more

@PJ Even after setting replication factor as 1 the data would be split into blocks and would be distributed across different datanodes. So, incase of a datanode failure you will only be able to partially retrieve data. Other advantage of setting replication factor > 1 is parallel processing, i.e. you have multiple copies of data at multiple places and all the machines can simultaneously process data. ... View more

@Vishal Gupta You might not have added principals for kadmin/fqdn@DOMAIN as well as the legacy fallback kadmin/admin@DOMAIN. You can add them using kadmin.local https://web.mit.edu/kerberos/krb5-1.13/doc/admin/admin_commands/kadmin_local.html ... View more

@Leenurs Quadras You can install multiple Hive Servers in case of multiple workloads or applications in which case each HiveServer2 instance can have its own settings for Hive and Tez. You can refer to this document https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_performance_tuning/content/section_hive_setup_for_multiple_queues.html P.S- If the answers help please accept and upvote the answers. Thanks ... View more

@Phoncy Joseph Old versions of ambari used to display such health messages. Usually they harmless. This was fixed in Ambari 2.3.0. https://issues.apache.org/jira/browse/AMBARI-12420. You can check if you are able to access and create files in DFS. You can also run hadoop fsck command to check its health status. ... View more

@Facundo Bianco For the PROD queue you can specify yarn.scheduler.capacity.<prod_queue_path>.capacity to be 50%. For DEV and LABS each you can specify yarn.scheduler.capacity.<dev/labs_queue_path>.capacity to be 25% and yarn.scheduler.capacity.<dev/labs_queue_path>.maximum-capacity as 50% each. This will provide the required elasticity, i.e. when PROD is not being used the other two can use up to 50% each. ... View more

@Leenurs Quadras Hive installation is independent of NameNode/Secondary NameNode location. In the configuration file you just need to specify where is Hadoop installed so that it can access the job tracker for submitting Map Reduce programs. Theoretically you can setup HiveServer, MetaStore Server, hive clients, etc. all in the Master Node. However in a production scenario placing them in a Master or Slave node is not a good idea. You should set up hiveserver on a dedicated Node so it doesn't compete for resources against the namenode processes (It gets quite busy in a multi-user scenario). MetaStore is a separate daemon which can be either embedded with the HiveServer (in this case it uses derby and isn't ideal for a production use) or can be setup separately as a dedicated database service(the recommended way). Beeline (hive client) can run in embedded mode as well as remotely. Remote HiveServer2 mode is recommended for production use, as it is more secure and doesn't require direct HDFS/metastore access to be granted for users. Hope this answers all your questions. ... View more

you can change the ownership of that file by logging in as the user 'hdfs' ... View more

this is a known limitation in non-secure clusters, whereby the containers are running as YARN user and not running as logged user. try setting this <env-var>HADOOP_USER_NAME=${wf:user()}</env-var> ... View more