Member since
07-30-2019
68
Posts
17
Kudos Received
6
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
562 | 08-15-2018 01:57 PM | |
3697 | 03-20-2017 05:09 PM | |
2389 | 02-08-2017 03:26 PM | |
1631 | 02-07-2017 01:50 PM | |
1184 | 02-01-2017 05:15 PM |
11-28-2018
06:20 PM
This is due to nodes in cluster cannot resolve names correctly. Could be a node manager node or the very edge node (if running from there) where Beeline is started. Need to ensure that, if using DNS, resolution occurs at low latency, if using /etc/hosts, this file needs to be checked across cluster nodes
... View more
08-15-2018
02:05 PM
You may want to take a look at this https://community.hortonworks.com/articles/808/phoenix-jdbc-client-setup.html Then, you can extrapolate information for squirrel from this one https://community.hortonworks.com/articles/19016/connect-to-phoenix-hbase-using-dbvisualizer.html
... View more
08-15-2018
01:57 PM
Can you check on: - Incorrect port (Are you using binary or hhtp mode?) - The Hiveserver2 availability (is it up and running?) Also root as user to connect to hive seems odd... Can you attempt hive user and its password?
... View more
07-09-2018
03:26 PM
2 Kudos
Hello Flume has been replaced in HDP-3.0 by Hortonworks DataFlow (HDF) capabilities. Please check the deprecated items in the documentation below and it is recommended to explore HDF for Flume use cases. https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_release-notes/content/deprecated_items.html
... View more
07-09-2018
03:22 PM
Was this recently import it? added a file to it? If so, you might need to run ANALYZE TABLE ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS
... View more
10-19-2017
06:06 PM
SMB should work on Hive 1.2.1. Make sure these properties are set set hive.auto.convert.sortmerge.join=true;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true; https://cwiki.apache.org/confluence/display/Hive/LanguageManual+JoinOptimization#LanguageManualJoinOptimization-AutoConversiontoSMBMapJoin
... View more
10-19-2017
05:36 PM
Can you share the full application id log? yarn logs -applicationId application_1508346468136_0028
... View more
10-19-2017
05:18 PM
You might to have a look at the following HCC series of articles https://community.hortonworks.com/articles/43525/disaster-recovery-and-backup-best-practices-in-a-t.html
... View more
07-03-2017
09:21 PM
That's correct https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-troubleshooting/content/resolving_cluster_install_and_configuration_problems.html
... View more
05-09-2017
02:12 AM
Currently a query that spawns a yarn job cannot be influenced independently, like it is shown in DAG, reason being is that resources (appplication id) used by any given query, can be reused by a different one, so its not a 1:1 relation
... View more
05-09-2017
02:07 AM
Check this thread if it does help https://community.hortonworks.com/questions/31968/hi-is-there-a-way-to-load-xlsx-file-into-hive-tabl.html
... View more
05-09-2017
01:54 AM
You can rejoin the node into the cluster, install Hivemetastore there pointing to an already created database
... View more
05-09-2017
01:47 AM
Check your zookeeper logs for disconnection errors
... View more
05-09-2017
01:40 AM
Did you upgrade your ambari agents?
... View more
04-25-2017
03:06 PM
OS should not matter on this. Compare the two /etc/hive/conf/hive-site.xml file from CentOS6 and CentOS7 respectively.
Make sure you are using Tez as execution engine set hive.execution.engine=tez;
... View more
04-25-2017
02:59 PM
Please share the log file information with the error you are getting
... View more
04-24-2017
03:47 PM
Can you share the output error you are getting?
... View more
03-20-2017
05:09 PM
Bruce, Try to change your /etc/hosts file accordingly and restart the sandbox and check ambari host
... View more
03-01-2017
08:25 PM
@Anders Boje Jugding by principal parameter --> principal=hive/XXX.YYY.com I assume the Kerberos real in the connection string is in upper case, right?. If not, it needs to be
... View more
03-01-2017
08:17 PM
@Viswa If created the cluster during yesterday you might have encountered the AWS outage while trying to start Ambari. Is it starting now?
... View more
03-01-2017
08:16 PM
@Gaurav Jain I would recommend you to follow Hive tutorial to process such files and importing it in Hive table https://hortonworks.com/hadoop-tutorial/how-to-process-data-with-apache-hive/
... View more
02-08-2017
03:26 PM
1 Kudo
@ed day Have you tried adding the jar in the script? add jar /path/to/jar/file.jar
... View more
02-07-2017
03:00 PM
@Huahua Wei Along with cleaning up the recommended directories in the mentioned post, take a look at the AMS tuning guide and set your AMS accordingly: https://cwiki.apache.org/confluence/display/AMBARI/Configurations+-+Tuning
... View more
02-07-2017
01:50 PM
@Nandini Bhattacharjee You might want to take a look at the following HCC post https://community.hortonworks.com/questions/22321/can-i-create-primary-key-in-hive-table-i-saw-in-tb.html
... View more
02-03-2017
09:18 PM
@Raja Sekhar Chintalapati Can you share log information from the moment you try to start the metastore? Also the output of --> klist -kte /etc/security/keytabs/hive.service.keytab
... View more
02-01-2017
05:56 PM
3 Kudos
@PJ Can you check on Metastore Heap Size if it had changed after upgrade? Also, check the max user processes for the user running the queries (ulimit -a) Hope that helps
... View more
02-01-2017
05:15 PM
1 Kudo
@Sunile Manjee Please have a look at the following HCC post https://community.hortonworks.com/questions/77731/is-there-a-way-to-allow-both-sso-and-ldap-authenti.html
... View more
02-01-2017
05:13 PM
2 Kudos
@Dejan Menges You can use Ambari Config Groups to assign an specific configuration to the host where the seconf HS2 lives. Please take a look at the following doc https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.1.0/bk_ambari-user-guide/content/using_host_config_groups.html
... View more
02-01-2017
05:10 PM
1 Kudo
@rakesh kumar You can enforce authorization at any level in hive using Apache Ranger Please have a look http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_security/content/overview_ranger_ambari_install.html
... View more
01-30-2017
02:44 PM
Please check the following, these could give you some pointers: https://community.hortonworks.com/content/supportkb/48949/how-can-i-use-sqoop-to-import-and-create-tables-wi.html https://community.hortonworks.com/articles/17469/creating-hive-partitioned-tables-using-sqoop.html
... View more