COPY FROM VERTICA failing

Moderator: NorbertKrupa

Post Reply
dbmsuser7
Intermediate
Intermediate
Posts: 71
Joined: Tue Jan 28, 2014 3:03 am

COPY FROM VERTICA failing

Post by dbmsuser7 » Wed Jan 29, 2014 5:10 pm

I'm trying to copy the contents of a very large table from a 6.1 cluster to a 7.0 cluster.

Initially I think the problem was that the two clusters are on different subnets, meaning their private networks are on different subnets. I fixed that with the CREATE SUBNET command and then ALTER DATABASE.

Now it's still failing, however. In vsql, the COPY FROM VERTICA command just hangs; even if I hit ^C to cancel, it stays hung.

My current suspicion is that the fact that both databases have the same name (although live on different cluster hosts with different public IPs and hostnames) could be causing a problem. Is that possible?

In the vertica log, I get this error:
2014-01-29 11:00:39.096 Init Session:0x7f5ca400f6c0-a0000000034595 <LOG> @v_vap_node0001: 00000/5771: Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: COPY FROM VERTICA failing

Post by JimKnicely » Tue Mar 18, 2014 12:25 pm

FYI... There is a bug fix in Vertica 7.0.1 that may help you?
VER-30443 - Data load / COPY The EXPORT TO VERTICA / COPY FROM VERTICA statements in HP Vertica 7.0.0 could prevent copying data from some external clusters, especially HP Vertica 6.x clusters. This issue has been resolved.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Data Load”