gnailJC opened a new issue, #5586: URL: https://github.com/apache/hudi/issues/5586
**_Tips before filing an issue_** - Have you gone through our [FAQs](https://hudi.apache.org/learn/faq/)? yes - Join the mailing list to engage in conversations and get faster support at dev-subscr...@hudi.apache.org. - If you have triaged this as a bug, then file an [issue](https://issues.apache.org/jira/projects/HUDI/issues) directly. **Describe the problem you faced** [0.11.0][SparkSQL] I got a ParseException when creating view with `timestamp as of`, such as sql `create view view_enterprise_basic_info_v20220512164415876 as (select enterpriseId, enterpriseName, legalRepresentative, socialCreditCode, orgCode, enterpriseType, regNumber, operStatus, businessTerm, regCapital, payAmount, foundTime, address, registrationAuthority, enterpriseScale, industry, business, description from enterprise_basic_info_rt timestamp as of 20220512164415876)` **To Reproduce** Steps to reproduce the behavior: 1. creata a hudi table like `enterprise_basic_info_rt` and insert some sample data 2. create a view based on `select * form hudi_table timestamp as of xxxx` 3. 4. **Expected behavior** ParseException stack it seem that HoodieSpark3_2ExtendedSqlParser can't parse `timestamp as of` ` create view view_enterprise_basic_info_v20220512164415876 as (select enterpriseId, enterpriseName, legalRepresentative, socialCreditCode, orgCode, enterpriseType, regNumber, operStatus, businessTerm, regCapital, payAmount, foundTime, address, registrationAuthority, enterpriseScale, industry, business, descriptionfrom enterprise_basic_info_rt timestamp as of 20220512164415876) -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^^^ at org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:266) at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parse(ParseDriver.scala:127) at org.apache.spark.sql.execution.SparkSqlParser.parse(SparkSqlParser.scala:51) at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parsePlan(ParseDriver.scala:77) at org.apache.spark.sql.parser.HoodieSpark3_2ExtendedSqlParser.$anonfun$parsePlan$1(HoodieSpark3_2ExtendedSqlParser.scala:44) at org.apache.spark.sql.parser.HoodieSpark3_2ExtendedSqlParser.parse(HoodieSpark3_2ExtendedSqlParser.scala:80) at org.apache.spark.sql.parser.HoodieSpark3_2ExtendedSqlParser.parsePlan(HoodieSpark3_2ExtendedSqlParser.scala:41) at org.apache.spark.sql.parser.HoodieCommonSqlParser.$anonfun$parsePlan$1(HoodieCommonSqlParser.scala:44) at org.apache.spark.sql.parser.HoodieCommonSqlParser.parse(HoodieCommonSqlParser.scala:84) at org.apache.spark.sql.parser.HoodieCommonSqlParser.parsePlan(HoodieCommonSqlParser.scala:41) at org.apache.spark.sql.SparkSession.$anonfun$sql$2(SparkSession.scala:616) at org.apache.spark.sql.catalyst.QueryPlanningTracker.measurePhase(QueryPlanningTracker.scala:111) at org.apache.spark.sql.SparkSession.$anonfun$sql$1(SparkSession.scala:616) at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:775) at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:613) at org.apache.kyuubi.engine.spark.operation.ExecuteStatement.$anonfun$executeStatement$1(ExecuteStatement.scala:80) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at org.apache.kyuubi.engine.spark.operation.SparkOperation.withLocalProperties(SparkOperation.scala:88) at org.apache.kyuubi.engine.spark.operation.ExecuteStatement.org$apache$kyuubi$engine$spark$operation$ExecuteStatement$$executeStatement(ExecuteStatement.scala:74) at org.apache.kyuubi.engine.spark.operation.ExecuteStatement$$anon$1.run(ExecuteStatement.scala:106) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) (state=,code=0) ` **Environment Description** * Hudi version : 0.11.0 * Spark version : 3.2.1 * Hive version : * Hadoop version : 3.3.1 * Storage (HDFS/S3/GCS..) : oss * Running on Docker? (yes/no) : no **Additional context** Add any other context about the problem here. **Stacktrace** ```Add the stacktrace of the error.``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@hudi.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
