[jira] [Commented] (PHOENIX-3421) Column name lookups fail when on an indexed table

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-3421:
---------------------------------------

[~samarthjain] - can you take this one? In PhoenixRuntime.encodeValues, you can just transform the column names passed in if the PTable is an index. I don't think callers of these APIs should have to know how to translate data column names to index column names and visa versa.

> Column name lookups fail when on an indexed table
> -------------------------------------------------
>
>                 Key: PHOENIX-3421
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3421
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.8.0
>            Reporter: Cody Marcel
>
> Using an index the lookup for encoded values fails.
> This happens on tables when using an index.
> The conflict is essentially between the two methods below. The pkColsList create by getPkColsDataTypesForSql() returns column names without a ":", but the encodeValues() method does a lookup on PTable for the column and cannot find it.
> PhoenixRuntime.getPkColsDataTypesForSql(pkColsList, dataTypesList, queryPlan, connection, true);
> PhoenixRuntime.encodeValues(connection, queryPlanTableName, objects , pkColsList);



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)