Trino includes Hive connector to access Hive data warehouse. Warehouse data is stored in the Hadoop Distributed File System (HDFS) or in S3 compatible storages. Data files located in Hive warehouse are in varieties of formats and data size can be enormous. Trino uses Hive metastore to discover schemas and …

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 …

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 …

Communication between Trino and a client can be secured with HTTPS protocol. config.properties Trino setup file located in /etc/trino folder includes the information necessary for establishing a connection to DBeaver. Java Keystore file contains a public key which is required to connect DBeaver to Trino cluster secured with …

Heterogeneous networks are common now. Those networks include computers with Windows and Unix Operation Systems (OS). Exchange files between those Operation Systems is a trivial task. It can be done with command line interface (CLI) or Graphic User Interface (GUI). Both methods give the same results but it depends on …

Z370 and Z390 Intel chipsets was released back in 2017 and 2018 years and they still are mainstream now. There are many motherboards based on Z370 and Z390 chipsets containing 2 or more M.2 sockets. Those motherboards might accommodate NVMe SSD storages with RAID 0 or 1 built on …

Trino cluster is sensitive to memory setup. As Trino is developed in Java, Java is foundation to configure it. In many cases, Trino server is not started because of memory configuration. During Trino server launch, the validation rules are applied to make sure that major memory settings are consistent. It …

Microsoft Access can be used to connect to Big Data. Cloudera Hadoop cluster is one of Big Data platforms. Those two systems can easily interact with each other by means of an ODBC connection. Microsoft Access natively supports ODBC drivers and Cloudera develops ODBC drivers for many Operation Systems. Hive …

Like other installations and setups, Trino formerly PrestoSQL can contain steps which cause difficulties. How many times you were stuck with something? In mostly cases, it was a trivial issue but you spent countless time to solve it. It's better to have a cheat sheet for discovering those issues before …

Trino accesses a variety of data sources by means of connectors. Hive connector is used to access files stored in Hadoop Distributed File System (HDFS) and S3 compatible systems. Metastore can be configured with two options: Hive or AWS Glue Data Catalog. Hive metastore setup and configuration are described in …