Re: I'm testing the ODBC but the test fails

icocio · ‎11-28-2018

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

icocio · ‎08-15-2018

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

icocio · ‎08-15-2018

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?

icocio · ‎07-09-2018

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

icocio · ‎07-09-2018

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

icocio · ‎10-19-2017

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

icocio · ‎10-19-2017

Can you share the full application id log? yarn logs -applicationId application_1508346468136_0028

icocio · ‎10-19-2017

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

icocio · ‎07-03-2017

That's correct https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-troubleshooting/content/resolving_cluster_install_and_configuration_problems.html

icocio · ‎05-09-2017

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

icocio · ‎05-09-2017

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

icocio · ‎05-09-2017

You can rejoin the node into the cluster, install Hivemetastore there pointing to an already created database

icocio · ‎05-09-2017

Check your zookeeper logs for disconnection errors

icocio · ‎05-09-2017

Did you upgrade your ambari agents?

icocio · ‎04-25-2017

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;

icocio · ‎04-25-2017

Please share the log file information with the error you are getting

icocio · ‎04-24-2017

Can you share the output error you are getting?

icocio · ‎03-20-2017

Bruce, Try to change your /etc/hosts file accordingly and restart the sandbox and check ambari host

icocio · ‎03-01-2017

@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

icocio · ‎03-01-2017

@Viswa If created the cluster during yesterday you might have encountered the AWS outage while trying to start Ambari. Is it starting now?

icocio · ‎03-01-2017

@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/

icocio · ‎02-08-2017

@ed day Have you tried adding the jar in the script? add jar /path/to/jar/file.jar

icocio · ‎02-07-2017

@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

icocio · ‎02-07-2017

@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

icocio · ‎02-03-2017

@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

icocio · ‎02-01-2017

@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

icocio · ‎02-01-2017

@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

icocio · ‎02-01-2017

@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

icocio · ‎02-01-2017

@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

icocio · ‎01-30-2017

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

Online	Offline
Last Visited	‎01-15-2021 09:21 AM

Date Registered	‎07-30-2019 09:10 AM
Last Visited	‎01-15-2021 09:21 AM
Total Messages Posted	68
Total Kudos Received	17

Re: I'm testing the ODBC but the test fails

Re: How to Change Host IP in Ambari View

Re: Hive cannot see jar

Re: How can you make the row_id the primary key in...

Re: Does NiFi Support SSO?

Re: UnknownHostException Exception while inserting...

Re: What are the steps to integrate kerberised Hba...

Re: I'm testing the ODBC but the test fails

Re: Why doesn't the hdp 3.0+ version support flume...

Re: Hive query returns zero result

Re: Can we see SMB join in explain query using Tez...

Re: Vertex failed error while executing hive query...

Re: what is the best backup and recovery solution ...

Re: 2 commands to disable hugepage on linux

Re: Naming Hive TEZ session (not individual DAG)

Re: How to do Excel write-back to Hive using ODBC?

Re: Hive master node recovery

Re: NameNode not starting up - Connection refused ...

Re: Ambari 2.4 server does not start,Ambari server...

Re: Hive select query is not giving the exact o/p.

Re: Hive ORC data import

Re: Im trying to load the data from hive to ms sql...

Re: How to Change Host IP in Ambari View

Re: Hive JDBC connection from Windows PC to Linux ...

Re: Ambari not started/working in AWS

Re: How to read Excel/CSV file and write to db tab...

Re: Hive cannot see jar

Re: Metrics Collector has been auto-started 5 time...

Re: How can you make the row_id the primary key in...

Re: Kerberos principal should have 3 parts: hive

Re: Hive metadata.HiveMetaStoreChecker (HiveMetaSt...

Re: Does NiFi Support SSO?

Re: Running multipe Hive Server 2 instances using ...

Re: hive privileges on table vs database.

Re: Sqoop Import - Now what