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)

Reply via email to