[
https://issues.apache.org/jira/browse/PHOENIX-3411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15880441#comment-15880441
]
Rajeshbabu Chintaguntla commented on PHOENIX-3411:
--------------------------------------------------
[~julianhyde] [~maryannxue] [~jamestaylor]
Apache Phoenix supports dynamic columns features which allows to write and read
the columns not in the schema. This is very useful feature for many users.
http://phoenix.apache.org/dynamic_columns.html
Here is the example for upsert and select queries with dynamic columns. The
columns in the bold are dynamic columns which has type while specifying the
column which is not a standard. Is there any way we can support same through
calcite.
{nofomrat}
UPSERT INTO EventLog (eventId, eventTime, eventType,*lastGCTime TIME,
usedMemory BIGINT, maxMemory BIGINT*) VALUES(1, CURRENT_TIME(), ‘abc’,
CURRENT_TIME(), 512, 1024);
{noformat}
{noformat}
SELECT eventTime, lastGCTime, usedMemory, maxMemory
FROM EventLog(*lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT*)
WHERE eventType = 'OOM' AND lastGCTime < eventTime - 1
{noformat}
[~maryannxue] pointed me org.apache.calcite.plan.RelOptTable#extend to extend
the columns in a table. But we might need changes in parsing as well.
> Support for Dynamic Columns in Phoenix-Calcite
> ----------------------------------------------
>
> Key: PHOENIX-3411
> URL: https://issues.apache.org/jira/browse/PHOENIX-3411
> Project: Phoenix
> Issue Type: Bug
> Reporter: Rajeshbabu Chintaguntla
> Assignee: Rajeshbabu Chintaguntla
> Labels: calcite
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
