You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Arvind S <ar...@gmail.com> on 2016/12/07 07:53:26 UTC

Timeout queries and background inserts

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