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
             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, 

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.


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

Please refer following screenshot 


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 


This message was sent by Atlassian JIRA

Reply via email to