NullPointerException when dropping database backed by S3

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)

Re: NullPointerException when dropping database backed by S3

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

Re: NullPointerException when dropping database backed by S3

Hi. Do you have access to logs? A callstack would be helpful. From: Marcin Tustin mailto:mtus...@handybook.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Friday, May 6, 2016 at 09:29 To: "user@hive.apache.org"

org.apache.hadoop.hive.serde2.io.DoubleWritable cannot be cast to org.apache.hadoop.hive.serde2.io.HiveDecimalWritable error

I created a table using SparkSQL and loaded parquet data into the table but when I attempt to do a 'SELECT * FROM tbl' I keep running into this error: Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.Double