hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: NullPointerException when dropping database backed by S3
Date Fri, 06 May 2016 17:02:40 GMT
Hi Marcin,

That error coming from Hive metadata. Can you go to that database
services_csvs  and do show tables?

May be an orphan table.

Can you drop tables manually?

Is it possible that Hive database has some inconsistency. Depending on the
issue you can look at what is in table DBS and TBLS in your metastore.

Cheers,


Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 6 May 2016 at 17:29, Marcin Tustin <mtustin@handybook.com> wrote:

> Hi All,
>
> I have a database backed by an s3 bucket. When I try to drop that
> database, I get a NullPointerException:
>
> hive> drop database services_csvs cascade;
>
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask.
> MetaException(message:java.lang.NullPointerException)
>
>
> hive> describe database services_csvs;
>
> OK
>
> services_csvs s3a://ID:SECRETWITHOUTSLASHES@services-csvs/ mtustin USER
>
> → hive --version
>
> WARNING: Use "yarn jar" to launch YARN applications.
>
> Hive 1.2.1.2.3.4.0-3485
>
> Subversion
> git://c66-slave-20176e25-2/grid/0/jenkins/workspace/HDP-build-centos6/bigtop/build/hive/rpm/BUILD/hive-1.2.1.2.3.4.0
> -r efb067075854961dfa41165d5802a62ae334a2db
>
> Compiled by jenkins on Wed Dec 16 04:01:39 UTC 2015
>
> From source with checksum 4ecc763ed826fd070121da702cbd17e9
>
> Any ideas or suggestions would be greatly appreciated.
>
>
> Thanks,
>
> Marcin
>
> Want to work at Handy? Check out our culture deck and open roles
> <http://www.handy.com/careers>
> Latest news <http://www.handy.com/press> at Handy
> Handy just raised $50m
> <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/>
led
> by Fidelity
>
>

Mime
View raw message