Skip to main content

How to write MERGE in Vertica

  • October 24, 2017
  • 8 replies
  • 11 views

Slaagh
Forum|alt.badge.img+1
  • Participating Frequently

Hello,

Vertica.com is down. I have been trying to access it for the past 2 days. Does anyone know how to write a MERGE in VERTICA? I would check the knowledge base, but as I said its down.

Any help would be appreciated.

8 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 24, 2017

Slaagh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 24, 2017

As I said Vertica.com is down. I cannot view anything. Have a look for yourself.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 24, 2017

I did. That's how I got the link :)


Slaagh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 24, 2017

So the issue must be on our end? What could it be?

Thanks for your response.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 24, 2017

Maybe a firewall issue? See if you can ping my.vertica.com from a command line...

Here is what I see:

C:\Users\knicely>ping my.vertica.com

Pinging my.vertica.com [104.154.135.234] with 32 bytes of data:
Reply from 104.154.135.234: bytes=32 time=50ms TTL=54
Reply from 104.154.135.234: bytes=32 time=49ms TTL=54
Reply from 104.154.135.234: bytes=32 time=49ms TTL=54
Reply from 104.154.135.234: bytes=32 time=50ms TTL=54

Ping statistics for 104.154.135.234:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 49ms, Maximum = 50ms, Average = 49ms


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 24, 2017

Since you are having an issue getting to the docs, I attached them here for you.


Slaagh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 24, 2017

Could not find host. I guess I will raise this with our team.

Thanks for your help.


Slaagh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 25, 2017

Thank you for the docs and the info. I really appreciate the help!