[
https://issues.apache.org/jira/browse/HIVE-25406?focusedWorklogId=646746&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-646746
]
ASF GitHub Bot logged work on HIVE-25406:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 06/Sep/21 06:24
Start Date: 06/Sep/21 06:24
Worklog Time Spent: 10m
Work Description: kasakrisz merged pull request #2549:
URL: https://github.com/apache/hive/pull/2549
--
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]
Issue Time Tracking
-------------------
Worklog Id: (was: 646746)
Time Spent: 20m (was: 10m)
> Fetch writeId from insert-only transactional tables
> ---------------------------------------------------
>
> Key: HIVE-25406
> URL: https://issues.apache.org/jira/browse/HIVE-25406
> Project: Hive
> Issue Type: Improvement
> Components: ORC, Parquet, Reader, Vectorization
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> When generating plan for incremental materialized view rebuild a filter
> operator is inserted on top of each source table scans. The predicates
> contain a filter for writeId since we want to get all the rows
> inserted/deleted from the source tables since the last rebuild only.
> WriteId is part of the ROW_ID virtual column and only available for
> fully-ACID ORC tables.
> The goal of this jira is to populate a writeId when fetching from insert-only
> transactional tables.
> {code:java}
> create table t1(a int, b int) clustered by (a) into 2 buckets stored as orc
> TBLPROPERTIES ('transactional'='true',
> 'transactional_properties'='insert_only');
> ...
> SELECT t1.ROW__ID.writeId, a, b FROM t1;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
