phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nitin D Chunke (JIRA)" <j...@apache.org>
Subject [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
Date Sat, 10 Mar 2018 18:54:00 GMT
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)

Mime
View raw message