Yeah, that won't work. You could do this: dbadmin=> CREATE LOCAL TEMPORARY TABLE "iris" ("Sepal.Length" DOUBLE PRECISION, "Sepal.Width" DOUBLE PRECISION, "Petal.… (View Post)

The diagnostics tool scrutinize collects a broad range of information from a Vertica cluster. Part of the output from a scrutinize includes data collector table data. Once extracted, we can easily lo… (View Post)

Note that this a feature of "new " databases created after installing 9.3. If you want an existing DB upgraded to 9.3 to use this feature, change the value of the DMLTargetDirect database p… (View Post)

Write Optimized Store (WOS) is a memory-resident data structure for short-term data storage while Read Optimized Store (ROS) is a highly optimized, read-oriented, disk storage structure, organized by… (View Post)

Do you have any tables in your database with data? Check out the link below that lists what is not audited: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/Licensing/Cal… (View Post)