永洪社区
标题: 永洪连接hive数据，创建数据集报错 [打印本页]
作者: wudixiaozhi 时间: 2020-6-3 15:54
标题: 永洪连接hive数据，创建数据集报错
系统版本：8.6.1.2出现概率：连hive创建数据集时经常出现一下两种报错
sql语句：select * from table
报错信息：1、Could not create ResultSet: Required field 'type' is unset! Struct:TPrimitiveTypeEntry(type:null, typeQualifiers:TTypeQualifiers(qualifiers:{characterMaximumLength=}))
2、执行SQL失败：“COMPILE FAILED: Parse error: [Error 1002] line 10:102 mismatched character ',' expecting '`'
line 10:107 required (...)+ loop did not match anything at character '\n'
line 11:15 mismatched character ',' expecting '`'
line 11:20 required (...)+ loop did not match anything at character ','
line 11:34 mismatched character ',' expecting '`'
line 11:39 required (...)+ loop did not match anything at character ','
line 11:53 mismatched character ',' expecting '`'
line 11:59 required (...)+ loop did not match anything at character ','
”
作者: 永洪tech-Jace 时间: 2020-6-3 18:15
1、数据库连接有问题吗
2、您保证您的sql语句能在其他地方正常执行吗
3、您这个报错我在网上搜了一下有相同的例子，您检查一下
作者: wudixiaozhi 时间: 2020-6-4 12:29
数据库连接，我测试没有问题！sql语句在数据库里面执行的没有问题啊！换用oracle后就没有这种报错
作者: 永洪tech-Jace 时间: 2020-6-4 22:01
您看一下
(, 下载次数: 78)