[HUDI-2627] Fix unsupported query instant time format in quickstart page

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 0.9.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Haihui Xu
• Created: 26/Oct/21 07:58
• Updated: 13/Dec/21 22:09

Description

when run the demo code:
spark.read.
format("hudi").
option("as.of.instant", "2021-07-28 14: 11: 08").
load(basePath)

there are exceptions:
java.lang.IllegalArgumentException: Unsupported query instant time format: 2021-07-28 14: 11: 08,Supported time format are: 'yyyy-MM-dd: HH:mm:ss' or 'yyyy-MM-dd' or 'yyyyMMddHHmmss'
at org.apache.spark.sql.hudi.HoodieSqlUtils$.formatQueryInstant(HoodieSqlUtils.scala:250)
at org.apache.hudi.HoodieFileIndex.$anonfun$specifiedQueryInstant$1(HoodieFileIndex.scala:85)
at scala.Option.map(Option.scala:230)
at org.apache.hudi.HoodieFileIndex.<init>(HoodieFileIndex.scala:85)
at org.apache.hudi.DefaultSource.getBaseFileOnlyView(DefaultSource.scala:201)
at org.apache.hudi.DefaultSource.createRelation(DefaultSource.scala:117)
at org.apache.hudi.DefaultSource.createRelation(DefaultSource.scala:67)
at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:350)
at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:274)
at org.apache.spark.sql.DataFrameReader.$anonfun$load$3(DataFrameReader.scala:245)
at scala.Option.getOrElse(Option.scala:189)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:245)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:188)
... 63 elided

Issue Links

• links to: GitHub Pull Request #3881