[jira] [Created] (PHOENIX-4649) Phoenix Upsert..Select query is not working for long running query.But while we ran same query with limit clause then it works fine

["Nitin D Chunke (JIRA)" <ji...@apache.org>]

Nitin D Chunke created PHOENIX-4649:
---------------------------------------

             Summary: Phoenix Upsert..Select query is not working for long running query.But while we ran same query with limit clause then it works fine  
                 Key: PHOENIX-4649
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4649
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.11.0
            Reporter: Nitin D Chunke
             Fix For: 5.0.0-alpha
         Attachments: image-2018-03-11-00-16-14-968.png, image-2018-03-11-00-22-32-613.png

We have data in table A which is around 3 Million Records. and from this table we have upsert data in to table B with out limit clause.

(Note : Here we already export the hbase conf path and set all phoenix properties to mentioned value and both the tables are salted)

Please find following hbase-site.xml screen shot.

!image-2018-03-11-00-22-32-613.png!

But hbase conf was not picked up when we launch sqlline/psql.

Please refer following screenshot 

!image-2018-03-11-00-16-14-968.png!

And when we ran same query with setting limit clause which is higher than total number record present in table A,it runs absolutely fine with out giving any error. 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)