[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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.11.0
• Fix Version/s: 5.0.0-alpha
• Labels: patch
• Flags: Important
• Assignee: Unassigned
• Reporter: Nitin D Chunke
• Created: 10/Mar/18 18:53
• Updated: 15/Mar/18 01:57

Description

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 error.