java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value

最新推荐文章于 2024-07-17 16:39:30 发布

JavaShooter

最新推荐文章于 2024-07-17 16:39:30 发布

阅读量2.5k

点赞数

分类专栏： hive

本文链接：https://blog.csdn.net/JavaShooter/article/details/8866371

版权

hive 专栏收录该内容

17 篇文章

订阅专栏

今天在添加表分区遇到如下的异常：

ALTER TABLE s_search_log ADD IF NOT EXISTS PARTITION (day_id =20130428, PLAT_TYPE=3)
LOCATION '/data/stg/s_search_log/20130428/3/';

异常：
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@1ad997f9" using statement "INSERT INTO `SDS` (`SD_ID`,`IS_COMPRESSED`,`INPUT_FORMAT`,`NUM_BUCKETS`,`SERDE_ID`,`LOCATION`,`CD_ID`,`OUTPUT_FORMAT`) VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
NestedThrowables:
java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

解决方法：

http://mail-archives.apache.org/mod_mbox/hive-dev/201302.mbox/%3CJIRA.12631340.1360272250513.300651.1361168954618@arcas%3E