MAP OBJECT log TO gpadmin.hive_task_log AT postgresql;
DECLARE
Start_time VARCHAR(20);
End_time VARCHAR(20);
Return_code INT;
BEGIN
Start_time = SYSDATE || '';
SELECT COUNT(1) FROM default.zhou_m;
Return_code = SQLCODE;
End_time = SYSDATE || '';
INSERT INTO log (`start_time`,`end_time`,`return_code`)
VALUES(start_time,end_time,return_code);
EXCEPTION WHEN OTHERS THEN
Return_code = SQLCODE;
End_time = SYSDATE || '';
INSERT INTO log (`start_time`,`end_time`,`return_code`)
VALUES(start_time,end_time,return_code);
DBMS_OUTPUT.PUT_LINE('SQL execute error,return code : ' || return_code);
END
when i running this query i am getting syntax error like
org.postgresql.util.PSQLException: ERROR: syntax error at or near "TABLE"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
at org.apache.hive.hplsql.Conn.executeSql(Conn.java:110)
at org.apache.hive.hplsql.Exec.executeSql(Exec.java:596)
at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:800)
at org.apache.hive.hplsql.Stmt.insert(Stmt.java:713)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1120)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:52)
at org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10316)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1013)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:52)
at org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1011)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:28)
at org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:448)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:42)
at org.apache.hive.hplsql.Exec.visitException_block_item(Exec.java:1147)
at org.apache.hive.hplsql.Exec.visitException_block_item(Exec.java:52)
at org.apache.hive.hplsql.HplsqlParser$Exception_block_itemContext.accept(HplsqlParser.java:1597)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
at org.apache.hive.hplsql.HplsqlBaseVisitor.visitException_block(HplsqlBaseVisitor.java:77)
please help me to resolve this issue
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/129458.html
標籤：Power Linux