[jira] [Updated] (PHOENIX-2273) Join Queries fail to give results within a finite time period

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

     [ 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)