Checklist for Inconsistent Execution Time of Same Query in Eon Mode
Sruthi Anumula, Senior Database Support Engineer
September 6, 2023
In Eon Mode, when a query is executed and if the ROS containers associated to the tables in the query are not present in depot, it will fetch results from the communal storage bucket. In the next immediate run, the query should provide results to the user from the files present in the depot. However,...
Using Fall Through Authentication
Sruthi Anumula, Senior Database Support Engineer
July 21, 2023
If a user tries to login using their credentials and the authentication fails, the user cannot login using other authentication methods. A simple example could be a user who was configured with hash authentication. Later, TLS authentication was introduced and granted to all users or in other words granted to the PUBLIC with higher priority....
Creating Iceberg External Tables in Vertica
Sruthi Anumula, Senior Database Support Engineer
June 1, 2023
From Vertica 12.0.4 onwards, we support creating external tables with parquet files in Apache Iceberg Table format. Iceberg is a high-performance table format which uses advanced filtering techniques and provides better performance by avoiding file listing. The striking feature of the external Iceberg tables is that there is no need to specify columns when defining...
Default Custom User Resource Pool
Sruthi Anumula, Senior Database Support Engineer
May 9, 2023
In Vertica versions 12.0.4 and later, you can set a default user resource pool for all users instead of defaulting users to a general pool, using the DefaultResourcePoolForUsers configuration parameter. How to set it? As a dbadmin user, create a user resource pool. The pool name can be used to configure the DefaultResourcePoolForUsers option. In...