Try rebuilding your metastore db using the schema tool .. From: Chaoran Yu <yuchaoran2...@gmail.com> Reply-To: "user@hive.apache.org" <user@hive.apache.org> Date: Wednesday, March 28, 2018 at 10:53 AM To: "user@hive.apache.org" <user@hive.apache.org> Subject: Hive master branch broken?
Hi, I made some changes to a local Hive repo based on the latest master branch. But somehow I got the following error when running a "CREATE TABLE" statement in Hive shell: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Insert of object "org.apache.hadoop.hive.metastore.model.MSerDeInfo@ace2408" using statement "INSERT INTO SERDES (SERDE_ID,DESCRIPTION,DESERIALIZER_CLASS,"NAME",SERDE_TYPE,SLIB,SERIALIZER_CLASS) VALUES (?,?,?,?,?,?,?)" failed : 'DESCRIPTION' is not a column in table or VTI 'APP.SERDES'.) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Insert of object "org.apache.hadoop.hive.metastore.model.MSerDeInfo@ace2408" using statement "INSERT INTO SERDES (SERDE_ID,DESCRIPTION,DESERIALIZER_CLASS,"NAME",SERDE_TYPE,SLIB,SERIALIZER_CLASS) VALUES (?,?,?,?,?,?,?)" failed : 'DESCRIPTION' is not a column in table or VTI 'APP.SERDES'.) No matter what table name or schema I create, I got the same error. I remember testing my changes about three weeks ago using the master branch back then, everything was working. It only started failing today after I merged the latest commits in master. Is anyone aware of recent commits that might break this write code path? And do we know when the next release of Hive is coming out? Thank you, Chaoran Yu
