Hive Sql测试错误

[chenyanlann]

Hive Sql测试错误

[chenyanlann]

{ "[]": { "Comment": { "@column": "DISTINCT momentId;count(DISTINCT userId)" , "@group": "momentId" }, "page": 0 }, "ok": false , "code": 500 , "msg": "Error while compiling statement: FAILED: SemanticException 1:86 SELECT DISTINCT and GROUP BY can not be in the same query. Error encountered near token 'momentId'" , "throw": "org.apache.hive.service.cli.HiveSQLException" }

[chenyanlann]

"Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'ViewTable'"

[chenyanlann]

{ "ViewTable[]": { "ViewTable": { "toId": 0 , "content~": "a" }, "page": 0 }, "ok": false , "code": 500 , "msg": "Error while compiling statement: FAILED: ParseException line 1:81 cannot recognize input near 'BINARY' ''a'' ')' in expression specification" , "throw": "org.apache.hive.service.cli.HiveSQLException" }

[chenyanlann]

"Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 1:86 Invalid function 'json_contains'"

[chenyanlann]

{ "User[]": { "User": { "name~": "^[0-9]+$" }, "count": 3 , "page": 0 }, "ok": false , "code": 500 , "msg": "Error while compiling statement: FAILED: ParseException line 1:64 cannot recognize input near 'BINARY' ''^[0-9]+$'' ')' in expression specification" , "throw": "org.apache.hive.service.cli.HiveSQLException" }

[chenyanlann]

{ "[]": { "Moment": { "@column": "id,userId,content" }, "User": { "id@": "/Moment/userId" , "@column": "id,name" }, "page": 0 , "join": "@/User/id@" }, "ok": false , "code": 500 , "msg": "Method not supported" , "throw": "java.sql.SQLFeatureNotSupportedException" }