dongwanfu created PHOENIX-5925:
----------------------------------
Summary: Mismatched input. Expecting "ASTERISK", got "TO_CHAR" at
line
Key: PHOENIX-5925
URL: https://issues.apache.org/jira/browse/PHOENIX-5925
Project: Phoenix
Issue Type: Bug
Components: core
Affects Versions: 4.14.3
Reporter: dongwanfu
{code:java}
sql> create view BIGTEST1.V_BD_ORDER as selectsql> create view
BIGTEST1.V_BD_ORDER as select TO_CHAR(BIRTHTIME, 'yyyy-MM-dd HH:mm:ss')
birthtimestr from BIGTEST1.BD_ORDER
[2020-05-28 12:49:09] [42P00][604] ERROR 604 (42P00): Syntax error. Mismatched
input. Expecting "ASTERISK", got "TO_CHAR" at line 2, column 5.[2020-05-28
12:49:09] java.lang.RuntimeException:
MismatchedTokenException(108!=13)[2020-05-28 12:49:09] at
org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:376)
{code}
Can only write ’select * ‘? How to convert data in a view
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
