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)