phoeinx报错、格式错误

新增数据时：

UPSERT INTO “ORDER_DTL” VALUES(‘02602f66-adc7-40d4-8485-76b5632b5b53’,‘已提交’,4070,1,‘4944191’,‘2020-04-25 12:09:16’,‘手机;’);

报错信息：

UPSERT INTO "ORDER_DTL" VALUES('02602f66-adc7-40d4-8485-76b5632b5b53','已提交',4070,1,'4944191','2020-04-25 12:09:16','手机;');
Error: ERROR 601 (42P00): Syntax error. Encountered "UPSERT INTO " at line 1, column 1. (state=42P00,code=601)
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "UPSERT INTO " at line 1, column 1.
        at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
        at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1644)
        at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1727)
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1819)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:813)
        at sqlline.SqlLine.begin(SqlLine.java:686)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:291)
Caused by: NoViableAltException(108@[])
        at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:832)
        at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:524)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
        ... 9 more

原因：
因为从文档上 或者 nodepad++ 上复制之后的问题（应该是格式问题）在idea上重写了一遍即可，把一些空格删除之后再加上，改变复制来的内容的格式
新的新增语句：

UPSERT INTO "ORDER_DTL" VALUES('02602f66-adc7-40d4-8485-76b5632b5b53','已提交',4070,1,'4944191','2020-04-25 12:09:16','手机;');

创建视图

create view if not exists “MOMO_CHAT”. “MSG” (
“pk” varchar primary key,
“C1”.“msg_time” varchar,
“C1”.“sender_nickyname” varchar,
“C1”.“sender_account” varchar,
“C1”.“sender_sex” varchar,
“C1”.“sender_ip” varchar,
“C1”.“sender_os” varchar,
“C1”.“sender_phone_type” varchar,
“C1”.“sender_network” varchar,
“C1”.“sender_gps” varchar,
“C1”.“receiver_nickyname” varchar,
“C1”.“receiver_ip” varchar,
“C1”.“receiver_account” varchar,
“C1”.“receiver_os” varchar,
“C1”.“receiver_phone_type” varchar,
“C1”.“receiver_network” varchar,
“C1”.“receiver_gps” varchar,
“C1”.“receiver_sex” varchar,
“C1”.“msg_type” varchar,
“C1”.“distance” varchar,
“C1”.“message” varchar
);

• 报错信息：

Error: ERROR 601 (42P00): Syntax error. Encountered "ot" at line 1, column 1. (state=42P00,code=601)
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "ot" at line 1, column 1.
        at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
        at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1644)
        at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1727)
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1819)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:813)
        at sqlline.SqlLine.begin(SqlLine.java:686)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:291)
Caused by: NoViableAltException(108@[])
        at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:832)
        at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:524)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
        ... 9 more

原因：
因为从文档上 或者 nodepad++ 上复制之后的问题（应该是格式问题）在idea上重写了一遍即可，把一些空格删除之后再加上，改变复制来的内容的格式
新的创建视图语句：

create view if not exists "MOMO_CHAT"."MSG"(
    "pk" varchar primary key,
    "C1"."msg_time" varchar,
    "C1"."sender_nickyname" varchar,
    "C1"."sender_account" varchar,
    "C1"."sender_sex" varchar,
    "C1"."sender_ip" varchar,
    "C1"."sender_os" varchar,
    "C1"."sender_phone_type" varchar,
    "C1"."sender_network" varchar,
    "C1"."sender_gps" varchar,
    "C1"."receiver_nickyname" varchar,
    "C1"."receiver_ip" varchar,
    "C1"."receiver_account" varchar,
    "C1"."receiver_os" varchar,
    "C1"."receiver_phone_type" varchar,
    "C1"."receiver_network" varchar,
    "C1"."receiver_gps" varchar,
    "C1"."receiver_sex" varchar,
    "C1"."msg_type" varchar,
    "C1"."distance" varchar,
    "C1"."message" varchar
);