InnerLife.io
  • Database
    • Oracle
    • HP Vertica
    • PostgreSQL
  • Administration
    • Virtualization
    • OpenVPN
    • HTTPD
    • OrangePI
  • Android
  • About
  • RU

Category - Database

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

19.01.2016
by InnerLife
5 min read
Add Comment

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...

Continue reading

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

19.01.2016
by InnerLife
1 min read
Add Comment

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...

Continue reading

Previous 1 2 3 4

Featured Posts

  • How to minimize your Docker image. 5 tips and tricks. Example of minifying from 328MB to 56MB.
  • Multicast Proxy Server
  • DBMail over PostgreSQL + Postfix + SASL on Debian. Part 1. Introduction.
  • Running QEMU VM with the latest kernel inside 2.6 OpenVZ container.
  • Fault tolerant PostgreSQL cluster with automatic failover using Repmgr and Barman. Part 1. Introduction.
Copyright © 2021. Created by Meks. Powered by WordPress.
  • Database
    • Oracle
    • HP Vertica
    • PostgreSQL
  • Administration
    • Virtualization
    • OpenVPN
    • HTTPD
    • OrangePI
  • Android
  • About
  • RU