eshu opened a new issue, #6058:
URL: https://github.com/apache/hudi/issues/6058
Hudi version: 0.11.1
Spark version: 3.1.1
Storage: S3
AWS Glue: 3
Function
```scala
import org.apache.spark.sql.{functions => fn}
def readAndShow(path: String) {
val df = spark.read.format("hudi").load(path)
df.select(fn.min(fn.col("updated_at")),
fn.min(fn.col("_hoodie_commit_time"))) show false
val idf = spark.read.format("hudi")
.option("hoodie.datasource.query.type", "incremental")
.option("hoodie.datasource.read.begin.instanttime", "0")
.option("hoodie.datasource.read.incr.fallback.fulltablescan.enable",
"true")
.load(path)
idf.select(fn.min(fn.col("updated_at")),
fn.min(fn.col("_hoodie_commit_time"))) show false
}
```
shows different results, but because
`hoodie.datasource.read.begin.instanttime` is 0, the same ones should appear.
Examples of output
```
+-------------------+------------------------+
|min(updated_at) |min(_hoodie_commit_time)|
+-------------------+------------------------+
|2018-09-05 13:29:40|20220608041038459 |
+-------------------+------------------------+
+-----------------------+------------------------+
|min(updated_at) |min(_hoodie_commit_time)|
+-----------------------+------------------------+
|2022-07-06 12:02:04.736|20220706130300379 |
+-----------------------+------------------------+
```
```
+-------------------+------------------------+
|min(updated_at) |min(_hoodie_commit_time)|
+-------------------+------------------------+
|2019-08-28 08:47:12|20220606081029941 |
+-------------------+------------------------+
+-------------------+------------------------+
|min(updated_at) |min(_hoodie_commit_time)|
+-------------------+------------------------+
|2022-07-06 00:02:04|20220706010239483 |
+-------------------+------------------------+
```
These results are reproducible, but unfortunately I can't provide the
dataset. I tried with and without
`hoodie.datasource.read.incr.fallback.fulltablescan.enable` option, but the
result is the same all the time. Could you please help me to read data with the
incremental query from the beginning?
When I tried to replace 0 with commit time from the first request of
function, I receive the same result.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
