About SK1

SK1 · ‎04-12-2016

Thanks @Benjamin Leonhardi

SK1 · ‎04-11-2016

tq @Benjamin Leonhardi. but do you have any idea that it is going to be in upcoming release or already there ?

SK1 · ‎04-11-2016

Team: We are using hdp2.3.4.0 so can we have authentication for falcon UI with local or LDAP ? Because anyone can login to UI with just username ?

SK1 · ‎04-05-2016

@Benjamin Leonhardi: Thanks a lot for your help. It worked and delete database without any error. But can you please help me to understand why it was not deleting functions and worked with forced option(cascade) ? hive> DROP DATABASE IF EXISTS prashant_db CASCADE; OK Time taken: 0.345 seconds hive> show databases; OK adotest afrankli archive_db baseline_db

SK1 · ‎04-05-2016

I can see two functions are present in database but when I am trying to drop them, those are not getting delete. hive> drop function prashant_db.getevent; OK Time taken: 0.009 seconds hive> show functions > ; OK ! != % & prashant_db.getevent prashant_db.gettheevent printf

SK1 · ‎04-05-2016

Hi Team, I am not able to drop database though we do not have any table in that database ? hive> use prashant_db; OK Time taken: 0.221 seconds hive> drop database prashant_db; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidOperationException(message:Database prashant_db is not empty. One or more functions exist.) hive> show tables; OK Time taken: 0.226 seconds hive>

SK1 · ‎03-22-2016

Can you restart all mapreduce and Yarn services ?

SK1 · ‎03-22-2016

Is your content on local or on hdfs at some other cluster ?

SK1 · ‎03-22-2016

You can also use falocn with hive action.

SK1 · ‎03-07-2016

@Neeraj Sabharwal: Thanks Neeraj, I have opened a case and working on it with support team. Let see what would be finding, I will update here if I will find solution.

Online	Offline
Last Visited	‎01-15-2021 02:12 AM

Member Since	‎05-29-2017 06:13 AM
Last Visited	‎01-15-2021 02:12 AM
Posts	408
Kudos received	123

Cloudera Community

Re: select * from table is not returning any rows ...

Re: Falcon feed throwing an error during feed sche...

Re: we are getting below error/exception while exe...

Re: bin/solr status throwing an error "clusterstat...

Re: How to solve buffer memory issue in Solr

Re: Can we configure falcon UI with username and p...

Re: Can we configure falcon UI with username and p...

Can we configure falcon UI with username and passo...

Re: Not able to drop database in hive

Re: Not able to drop database in hive

Not able to drop database in hive

Re: Yarn App Timeline Server down quietly

Re: How to import existing repositories's contents...

Re: Which tool to schedule Hive queries?

Re: Failed with exception MetaException(message:In...