[
https://issues.apache.org/jira/browse/HUDI-7415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xy updated HUDI-7415:
---------------------
Description:
OLAP query need support read data from origin table by default，for
example，query from olap engine such as starrocks presto，we can only read data
in ro/rt sub table and get empty data from origin table，this is not fitable：
query mor table with starrocks as:
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22_rt;
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
|_hoodie_commit_time|_hoodie_commit_seqno|_hoodie_record_key|_hoodie_partition_path|_hoodie_file_name
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------|
|20230522100703567|20230522100703567_0_0|1|partition=de|f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
1 row in set (2.11 sec)|
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22_ro;
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
|_hoodie_commit_time|_hoodie_commit_seqno|_hoodie_record_key|_hoodie_partition_path|_hoodie_file_name
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------|
|20230522100703567|20230522100703567_0_0|1|partition=de|f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
{+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
1 row in set (0.22 sec)|
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22;
Empty set (1.23 sec)
was:
OLAP query need support read data from origin table by default，for
example，query from olap engine such as starrocks presto，we can only read data
in ro/rt sub table and get empty data from origin table，this is not fitable：
query mor table with starrocks as:
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22;
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
| _hoodie_commit_time | _hoodie_commit_seqno | _hoodie_record_key |
_hoodie_partition_path | _hoodie_file_name
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
| 20230522100703567 | 20230522100703567_0_0 | 1 | partition=de |
f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
1 row in set (2.11 sec)
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22_ro;
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
| _hoodie_commit_time | _hoodie_commit_seqno | _hoodie_record_key |
_hoodie_partition_path | _hoodie_file_name
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
| 20230522100703567 | 20230522100703567_0_0 | 1 | partition=de |
f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
+---------------------+-----------------------+--------------------+------------------------+------------------------------------------------------------
1 row in set (0.22 sec)
MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22;
Empty set (1.23 sec)
> OLAP query need support read data from origin table by default
> --------------------------------------------------------------
>
> Key: HUDI-7415
> URL: https://issues.apache.org/jira/browse/HUDI-7415
> Project: Apache Hudi
> Issue Type: Improvement
> Reporter: xy
> Assignee: xy
> Priority: Major
>
> OLAP query need support read data from origin table by default，for
> example，query from olap engine such as starrocks presto，we can only read data
> in ro/rt sub table and get empty data from origin table，this is not fitable：
> query mor table with starrocks as:
> MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22_rt;
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
> |_hoodie_commit_time|_hoodie_commit_seqno|_hoodie_record_key|_hoodie_partition_path|_hoodie_file_name
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------|
> |20230522100703567|20230522100703567_0_0|1|partition=de|f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
> 1 row in set (2.11 sec)|
> MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22_ro;
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
> |_hoodie_commit_time|_hoodie_commit_seqno|_hoodie_record_key|_hoodie_partition_path|_hoodie_file_name
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------|
> |20230522100703567|20230522100703567_0_0|1|partition=de|f14492ed-b672-4f60-8e86-6359790feb2a-0_0-17-2013_2023052210
> {+}--------------------{-}{-}{+}---------------------{-}++{-}------------------{-}{-}----------------------{-}+{-}-----------------------------------------------------------
> 1 row in set (0.22 sec)|
> MySQL [(none)]> select * from hudi_catalog_01.hudi_test.test_mor_hudi_22;
> Empty set (1.23 sec)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
