[jira] [Commented] (PHOENIX-3411) Support for Dynamic Columns in Phoenix-Calcite

["Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org>]

    [ 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)