[
https://issues.apache.org/jira/browse/PHOENIX-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeongdae Kim updated PHOENIX-3423:
----------------------------------
Description:
PhoenixObjectInspector doesn't have information on length of the column. this
causes making incorrect constant valuesfor char columns in select statement
because of padding spaces with max length(255), and get wrong results because
of invalid filter conditions.
ex) column : r_name char(6),
hive query : select * from r_name = 'EUROPE',
phoenix query : select * from r_name = 'EUROPE ' (with
249(255 - 6) tailing white spaces)
was:
PhoenixObjectInspector doesn't have information on length of the column. this
causes making incorrect constant values(with max length) for char/vchar columns
in select statment, and get wrong results because of invalid filter conditions.
ex) column : r_name char(6),
hive query : select * from r_name = 'EUROPE',
phoenix query : select * from r_name = 'EUROPE ' (with
249(255 - 6) tailing white spaces)
> PhoenixObjectInspector doesn't have information on length of the column.
> ------------------------------------------------------------------------
>
> Key: PHOENIX-3423
> URL: https://issues.apache.org/jira/browse/PHOENIX-3423
> Project: Phoenix
> Issue Type: Bug
> Reporter: Jeongdae Kim
>
> PhoenixObjectInspector doesn't have information on length of the column. this
> causes making incorrect constant valuesfor char columns in select statement
> because of padding spaces with max length(255), and get wrong results because
> of invalid filter conditions.
> ex) column : r_name char(6),
> hive query : select * from r_name = 'EUROPE',
> phoenix query : select * from r_name = 'EUROPE ' (with
> 249(255 - 6) tailing white spaces)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
