Search found 5 matches

by micha034
Tue Mar 13, 2018 10:33 am
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 36409

Re: @@Rowcount

New update about my issues. While previously presented solution helped in 99% of the cases. Now we reached the point of loading chunks of data with more than Integer.MAX_VALE of rows (8 billion actually :) ). JDBC affected rows returns only int and JDBC "executeLargeUpdate" that was built for such c...
by micha034
Tue Feb 13, 2018 9:38 am
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 36409

Re: @@Rowcount

Ok, it was pretty "stupid" From some reason JDBC implementation of Vertica on calls without statement returns affected rows correctly but with prepared statement returns 0; 1. No prepared statement = GOOD int accepted = conn.executeUpdate(copyQuery); --- > return number of affected rows 2. With prep...
by micha034
Tue Feb 13, 2018 7:13 am
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 36409

Re: @@Rowcount

Thanks again for your help. GET_NUM_ACCEPTED_ROWS is not supported on multi node operation. We worked with this function when we we used WEBHDFS protocol and it was ok but this not working with 'hdfs://' protocol. Following exception is thrown: Caused by: com.vertica.support.exceptions.FeatureNotSup...
by micha034
Mon Feb 12, 2018 10:44 pm
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 36409

Re: @@Rowcount

Thanks for quick reply. Vertica version 8.1.1 Using JDBC. Tried following but returns 0 although data is loaded: int numAccepted1 = copyStatement.executeUpdate(); int numAccepted2 = copyStatement.getUpdateCount(); Performing COPY command from JDBC like following: COPY tests.table FROM 'hdfs://hdfs-n...
by micha034
Mon Feb 12, 2018 5:22 pm
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 36409

Re: @@Rowcount

Hi,

I know its pretty old thread but...
How can I get number of accepted rows while performing COPY from HDFS via hdfs:// protocol?

Go to advanced search