Trino logoMemory Configuration in Trino Cluster

DateModifiedViewsCategory

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 …

more ...

Microsoft access logoConnect Microsoft Access to Hive with ODBC in Windows

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 …

more ...

Trino logoTrino Installation and Setup Pitfalls

DateModifiedViewsCategory

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 …

more ...

Trino logoAccess MinIO S3 Storage in Trino with File Metastore

DateModifiedViewsCategory

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 …

more ...

Kerberos logoCreate Ticket Cache File for Kerberos Authentication in Linux

Kerberos credentials can be stored in Kerberos ticket cache. They are valid for relatively short period of time. The period can be a session or a specified timeframe. A Kerberos ticket cache contains a service and a client principal names, lifetime indicators, flags, and the credential itself. Kerberos 5 client …

more ...

Google analytics logoAdd Google Analytics Pageviews in Static Web Site

Google Analytics requests authentication to access Google Analytics data/reports. Implementation of Google Analytics can be done in both places client and server. Server APIs support a wide variety of languages and the authentication process is transparent for users. Javascript is a language to access Google Analytics APIs in client …

more ...

Kerberos logoCreate Keytab for Kerberos Authentication in Linux

DateModifiedViewsCategory

Keytab stands for key table. It is a file which stores one or more Kerberos principals with corresponding encrypted keys. Encrypted keys are generated based on user passwords. It allows to secure storing of passwords and authenticate users without entering of passwords. The current version of the Kerberos protocol is …

more ...


Synology logoInstalling and Using PIP on Synology DSM

Python3 can be easily installed on Synology DSM through Synology Installation Center but pip installation is skipped. The first method to install pip is to bootstrap the pip installer into an existing Python installation. The ensurepip package is aimed for it. It's available starting from Python version 3.4. As …

more ...