[
https://issues.apache.org/jira/browse/PHOENIX-1?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swaroopa Kadam reassigned PHOENIX-1:
------------------------------------
Assignee: Swaroopa Kadam
> select only gives results for certain combinations of selected columns when
> performing join
> -------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1
> URL: https://issues.apache.org/jira/browse/PHOENIX-1
> Project: Phoenix
> Issue Type: Bug
> Reporter: Sergio Esteves
> Assignee: Swaroopa Kadam
> Priority: Major
>
> I'm using last version from master branch (
> 995f508b2a80d9158467c708f35afcf6da4f0cce ) and I've been facing a strange
> behavior.
> When I run the following queries:
> bq. select * FROM customer inner join address ON customer.c_addr_id =
> address.addr_id inner join country ON address.addr_co_id = country.co_id;
> bq. SELECT c_id, c_uname, c_passwd, c_fname, c_lname, c_addr_id, c_phone,
> c_email, c_since, c_last_login, c_login, c_expiration, c_discount, c_balance,
> c_ytd_pmt, c_birthdate, c_data, addr_id, addr_street1, addr_street2,
> addr_city, addr_state, addr_zip, addr_co_id, co_id, co_name, co_exchange,
> co_currency FROM customer inner join address ON customer.c_addr_id =
> address.addr_id inner join country ON address.addr_co_id = country.co_id;
> the resulting table is empty.
> But if I remove some columns, like this:
> bq. SELECT c_id, c_uname, c_passwd, c_fname, c_lname, c_addr_id, c_phone,
> c_email, c_since, c_last_login, c_login, c_expiration, c_discount, c_balance,
> c_ytd_pmt FROM customer inner join address ON customer.c_addr_id =
> address.addr_id inner join country ON address.addr_co_id = country.co_id;
> bq. SELECT c_id, c_uname, c_passwd, c_fname, c_lname, c_addr_id, c_phone,
> c_email, c_since, c_last_login, c_login, c_expiration, c_discount, c_balance,
> c_ytd_pmt, addr_id FROM customer inner join address ON customer.c_addr_id =
> address.addr_id inner join country ON address.addr_co_id = country.co_id;
> the resulting table is not empty anymore, listing all rows correctly. Seems
> to me that there is some sort of limit on the size (in bytes) that all
> aggregated values of a row in the result can have.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
