[
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nishani updated PHOENIX-2273:
------------------------------
Attachment: ScreenshotOfOrders&CustomersTables.png
ScreenShotOfJoinquery.png
The Tables CUSTOMERS & ORDERS used for join query.
create table ORDERS (id integer not null primary key, item varchar, customerid
varchar);
create table CUSTOMERS (id integer not null primary key, name varchar);
SELECT O.ID, C.Name, O.Item FROM Orders AS O INNER JOIN Customers AS C ON
O.CustomerID = C.ID;
> Join Queries fail to give results within a finite time period
> --------------------------------------------------------------
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
> Issue Type: Bug
> Reporter: Nishani
> Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png,
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give
> results. Either it takes a long time to give the results or the join queries
> are not executed properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
