phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-374) Enable access to dynamic columns in * or cf.* selection
Date Wed, 06 Feb 2019 03:17:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16761404#comment-16761404
] 

Hudson commented on PHOENIX-374:
--------------------------------

FAILURE: Integrated in Jenkins build PreCommit-PHOENIX-Build #2309 (See [https://builds.apache.org/job/PreCommit-PHOENIX-Build/2309/])
PHOENIX-374: Enable access to dynamic columns in * or cf.* selection (chinmayskulkarni: rev
77ea6eac02dc8a23ccea06713d64932b6affa415)
* (edit) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/HashJoinRegionScanner.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/EncodedColumnsUtil.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/tuple/BaseTuple.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/SortMergeJoinPlan.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/TupleProjector.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixResultSet.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/DynamicColumnWildcardIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/ProjectedColumnExpression.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/PRow.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/RowProjector.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/ScanRegionObserver.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryServicesOptions.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/tuple/DelegateTuple.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/tuple/Tuple.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/TupleProjectionCompiler.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/generated/DynamicColumnMetaDataProtos.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/hbase/index/util/KeyValueBuilder.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/PhoenixRuntime.java
* (add) phoenix-protocol/src/main/DynamicColumnMetaData.proto
* (edit) phoenix-core/src/test/java/org/apache/phoenix/util/MetaDataUtilTest.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/PTableImpl.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/MutationState.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/CorrelatePlan.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/iterate/RegionScannerFactory.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/ProjectionCompiler.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/MetaDataUtil.java


> Enable access to dynamic columns in * or cf.* selection
> -------------------------------------------------------
>
>                 Key: PHOENIX-374
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-374
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: nicolas maillard
>            Assignee: Chinmay Kulkarni
>            Priority: Critical
>         Attachments: PHOENIX-374.patch
>
>          Time Spent: 3h 40m
>  Remaining Estimate: 0h
>
> As of recent work we can now read and write columns that are not in the schema, AKA dynamic
columns. the Select and Upsert allow dynamic columns to be specified. 
> I think two additions are still needed.
> - Alter dynamicly: In the Upsert and/or Select statement  the ability to add on the specified
dynamic column to schema. Say Upsert into Table (key, cf.dynColumn varchar SCHEMAADD) values
(..)
> and for select: 
>      - select key, cf.dynColumn varchar from T would only read
>      - select key from T(cf.dynColumn varchar ) would only read and wrtie to schema
> - Select a complete column Family: More complex, accessing a whole Column Family with
all rows known in schema or not.
>  select cf.* from T
> today this works for know columns it could be nice to have this for all columns of a
family in the schema or not. I'm trying right now to extend this to schema for unknown columns.
However every new row can a lot of very different unknowcolumns. The defined ones will be
first but the unknown one will be appended at the end.
> This means the metadata might need to be updated at every row to account for all new
columns discovered.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message