-2

I am not exactly sure why this schema is been searched for. Any flyway experts who worked with vertica ?

Mukilan Ashok
  • 3
  • 2
  • Welcome to [Stack Overflow](https://stackoverflow.com/)! At this site you are expected to try to **write the code yourself**. After [doing more research](https://meta.stackoverflow.com/questions/261592) if you have a problem you can **post what you've tried** with a **clear explanation of what isn't working** and providing a [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve). I suggest reading [How to ask a good question](https://stackoverflow.com/questions/how-to-ask). Also, be sure to take the [tour](https://stackoverflow.com/tour). – Peter Reid Jun 29 '17 at 19:08

1 Answers1

0

Even though the information_schema is defined as a standard implemented by most RDBMSs like MySQL, it is not implemented by Vertica.

In Vertica, the information_schema equivalent SQL structure is the v_catalog SQL schema.

The error returned by the Vertica JDBC driver means you are querying erroneously the information_schema. If you are not doing it yourself, it may be a library you're using inadequately (ex : Hibernate would query the information_schema).

Nicolas Riousset
  • 3,447
  • 1
  • 22
  • 25