flink SQL 运行 String sqlWindPrice = "create VIEW temp_wind_price as " + "select SUBSTRING(s_info_windcode,1,6) as ts_code," + "s_dq_close as close_price " + "from AShareEODPrices " + "where trade_dt = '20010823'"; tEnv.executeSql(sqlWindPrice); 报错Encountered: "\uff08" (65288), after : ""
时间: 2024-04-15 07:29:39 浏览: 223
在你提供的代码中,报错是由于使用了错误的括号符号导致的。请注意,正确的括号符号应该是半角括号 "(" 和 ")",而不是全角括号 "(" 和 ")"。请尝试将代码中的全角括号替换为半角括号,如下所示:
```java
String sqlWindPrice = "CREATE VIEW temp_wind_price AS " +
"SELECT SUBSTRING(s_info_windcode, 1, 6) AS ts_code, " +
"s_dq_close AS close_price " +
"FROM AShareEODPrices " +
"WHERE trade_dt = '20010823'";
tEnv.executeSql(sqlWindPrice);
```
请确保在代码中使用半角括号来定义字符串,以避免类似的语法错误。
阅读全文