Error: Error while compiling statement: FAILED: ParseException line 1:28 mismatched input ‘,’ expecting ( near ‘char’ in primitive type specification (state=42000,code=40000)
hive建表时报错
0: jdbc:hive2://linux01:10000> create table score(name char,`month` String,money int)row format delimited fields terminated by ','stored as textfile;
Error: Error while compiling statement: FAILED: ParseException line 1:28 mismatched input ',' expecting ( near 'char' in primitive type specification (state=42000,code=40000)
原因:hive中没有char类型,把char换成string即可
char' in primitive type specification (state=42000,code=40000)
0: jdbc:hive2://linux01:10000> create table score(name String,mh String,money int)
. . . . . . . . . . . . . . .> row format delimited fields terminated by ',' stored as textfile;
INFO : Compiling command(queryId=root_20210228101547_c8d7