HP Vertica

One of the key moments using HP Vertica is an optimization of data storage using encoding. Encoding reduces disk space usage, making it faster to get huge amounts of data using on-the-fly decoding.We can suggest optimal encoding type based on data type, cardinality and encoding algorithm intensity. In this article I will investigate disk storage …

HP Vertica. Storing timestamp data depending on precision and encoding type. Read More »

Working with Vertica JDBC, you can get an error while binding timestamp variable.Possibly, you have a similar query: select id from test where d_add > ? – interval ‘1 day’ And you get the following error on prepareStatement stage: [Vertica][VJDBC](4286) ERROR: Operator does not exist: timestamp > interval(in seconds) Solution is simple, just add bind-variable …

HP Vertica. Timestamp binding. Error 4286: Operator does not exist. Read More »