Does HP Vertica fully supports ORACLE for queries ??? I am not able to fire a below query: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='VMartDB' Which syntax does HP Vertica follow ??
Hello Syed, It's not clear what you mean when you request "full support" of Oracle queries. The SQL syntax is largely the same and the most commonly used catalog tables are also mostly compatible. However, some queries may need to be modified to work with Vertica if they previously worked with Oracle's database product. Please see the documentation for each case. Here is the documentation page for v_catalog.all_tables: https://my.vertica.com/docs/6.1.x/HTML/index.htm#16818.htm v_catalog.tables has more information, including owner information: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12276.htm
Comments