执行命令异常:
> desc ods_xxx;
FAILED: Error in metadata: at least one column must be specified for the tableFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
根据网上介绍的方法,修改datanucleus.cache.level2.type参数为none问题仍存在;
查看根据sd_id(12134)查看元数据库的columns表,发现对应ods_xxx列值为空;
解决方法:
1、修补元数据 表;
mysql> desc columns;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| SD_ID | bigint(20) | NO | PRI | NULL | |
| COMMENT | varchar(256) | YES | | NULL | |
| COLUMN_NAME | varchar(128) | NO | PRI | NULL | |
| TYPE_NAME | varchar(4000) | NO | | NULL | |
| INT