About EricL

EricL · ‎09-20-2018

Then you will need to load the schema for Hive to read, they are under https://github.com/apache/hive/tree/master/metastore/scripts/upgrade Go into the database type directory and locate the version of your Hive, for example: https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql You will need to load it into your database. If you are using Cloudera Manager, go to CM > Hive > Action > Create Hive MetaStore Database Tables Then you should be good.

EricL · ‎09-20-2018

Please try one of below: 1. in beeline run: !connect 'jdbc:hive2://server1.abc.com:10000/default' 2. from shell command line: beeline -u 'jdbc:hive2://server1.abc.com:10000/default' See if that helps

ganeshkumarj · ‎09-19-2018

Hello sparamas, Below are the steps are must follow when submitting the oozie job from oozie server. Kinit with principle and keytab [ kinit user_principle -k -t key_tab ] must use fqdn along with oozie server name in command oozie job -oozie http://machine_name@domain:11000/oozie -config xxxx -run

Tim Armstrong · ‎09-10-2018

@BorjaRodriguez that looks like a different known issue that we've seen with incremental stats on tables with large numbers of columns. It's fixed in CDH5.13+.

Daggers · ‎09-06-2018

Thanks. Well yes I think it is what I need however.... it seems some of my tables have that date changing multiple times during a day. I looked at navigator to try and track down who may have been issuing 'COMPUTE STATS' commands but found nothing. To make the whole picture even stranger is the fact that the table is replicated at the database level using BDR. But the master metadata is different from the target metadata. The target table is the one I am looking at, this is the one getting update multiple times a day. Any suggestions on how to find what is making this LAST_ANALYZED timestamp to increment all the time ?

Harsh J · ‎09-06-2018

> I am little bit confused, so the WebHDFS REST API is listening on the same port as the NameNode's UI? Yes this is correct. The HTTP(S) serving port of the NameNode does multiple things: Serves the UI for browsers on / and a few other paths, serves a REST API on /webhdfs/*, etc. WebHDFS on HDFS service is used by contacting the currently configured web port of the NameNode and DataNode(s) (the latter by following redirects, not directly). In your case, the cluster is set to use HTTPS (TLS security) so you need to use the 50470 port, swebhdfs:// (notice the s-prefix for security) in place of webhdfs:// and https:// in place of http:// when following any WebHDFS tutorial.

RamG · ‎09-01-2018

Yep! I have set jceks configuration in hive and tried to create hive table but same error... Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.io.IOException Cannot find password option fs.s3a.access.key) (state=08S01,code=1) FYI: Able to create table with same configuration in HDP 3.0 But our goal is to make work on Cloudera only, since 90% of our clients using Cloudera CDH! Thank you! ram

Romainr · ‎09-01-2018

You could also look at the 'download_row_limit', e.g. https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini#L1087

EricL · ‎08-31-2018

It is Cloudera Manager's requirement that Oozie is needed before you can install Hue. So you need to have Oozie first.

EricL · ‎08-31-2018

You mentioned that "kerberos authentication" and "sentry" are NOT enabled, then you would NOT have any security at all. That username and password you entered are not checked by hive. You should enable kerberos authentication and sentry authorization if you want any security in your cluster.

Online	Offline
Last Visited	‎08-12-2020 03:17 AM

Member Since	‎03-23-2015 01:24 PM
Last Visited	‎08-12-2020 03:17 AM
Posts	1,288
Kudos received	113

Cloudera Community

Re: max() function generating an error in sqoop

Re: Add a dynamic variable to a Hive view

Re: Hive Server 2 failing to start CDP ,Cloudera M...

Re: Sqoop export from hive to teradata - > issue ...

Re: Cloudera Hadoop internal workings

Re: Hive, Oozie Metadata is not found in MySQL dat...

Re: connection issue from beeline to hive

Re: Oozie Error

Re: Impala Memory limit exceeded despite setting m...

Re: What was the date that a HIVE/IMPALA table get...

Re: NameNode running but 50070 not listening

Re: Unable to create hive table s3a as location us...

Re: Limit Query Result Rows from a Hive Table on H...

Re: HUE without Oozie

Re: Authentication of users through beeline