Python logoPython Access to Presto Cluster with PyHive

Presto access is represented by many Python libraries among those are Dropbox/PyHive, prestosql/presto-python-client, prestodb/presto-python-client, and easydatawarehousing/prestoclient. Mostly of libraries use Python DB-API interface to access Presto which uniforms commands.

Python Access to Presto Cluster with Presto Client article describes PrestoSQL client library usage.

Dropbox/PyHive library …

more ...



Trino logoHive Standalone Metastore for Presto in Docker

Hive connector in Presto can retrieve data from both HDFS and S3 compatible storages. The connector requests Hive metastore as a link to those storages. There are two types of metastores. The first one is beefy one which includes multiple services. The second one is light weight and is called …

more ...

Docker logoInstall Docker CE in CentOS/RHEL 7

Installing Docker CE in CentOS/RHEL 7 is a trivial process but it is not true in all cases. Specially, when we deal with open source products, maintaining and patching might be an issue for doing it in timely manner. Community forums and other sources are our life savers to …

more ...



Intel logoNVMe RAID Performance on Z390 Chipset Motherboard

NVMe SSD RAIDs are getting more popular in our days. It is an interesting question - what hardware to use to build more efficient RAID in terms of performance. Z390 chipset motherboard might include 2 or 3 NVMe slots for building of Raid 0 or 1 based on Intel® Rapid Storage …

more ...

Security logoRemove Private Key from Java Keystore

Java keystore (JKS) is a file secured by a password. Java keystore repository can contain public key certificates with corresponding private keys. The keys are used to encrypt communication over network. If JKS file is distributed, private keys should be removed from the repository. keytool tool is aimed to manipulate …

more ...