phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arvind S <arvind18...@gmail.com>
Subject Timeout queries and background inserts
Date Wed, 07 Dec 2016 07:53:26 GMT
Using phoenix on Hbase cluster (on azure-hd insight) with single worker
node.

HBase: 1.1.2.2.4
phoenix: 4.4.0.2.4.2.0-258

I loaded a million lines (from CSV) into a stage table and now use it to
load another one (dynamic view) multiple times to simulate load.

*UPSERT INTO tsevents_target (SELECT id, etime, Event_Type, Duration) *
*SELECT id, etime, Event_Type, Duration FROM csvstgsnappy where etype =
'Test';*

when my source is selecting 1000's of rows there are not issues ..
when selecting million+ the query time's out.. but insert seems to go on in
the background and completes after some time..

is there any way to know the completion ?
is this fixed in some later versions ?

*Cheers !!*
Arvind

Mime
View raw message