How-Tos

Step-By-Step Instructions

  • How to Scale Out an AtScale Single Instance

    This document describes how to scale out an AtScale single instance by moving the AtScale metadata database into its own instance. The reason for doing this is to minimize query pe...

  • How to Set parquet.block.size

    In the Design Center UI, for the SQL Engine, set the parameter parquet.block.size in 'EXTRA JDBC FLAGS.'

  • How to Set the JWT/Web Token Expiration

    Depending on the application that interacts with AtScale, expired JWT tokens can cause issues with API calls, such as aggregate rebuilds. To resolve this, get a token before every ...

  • How to Set Up an Okta Directory

    This procedure describes how to set up an Okta directory with AtScale. Okta API First, you need an API Token from Okta. Go to the API admin and Create a Token. Save the token:  00...

  • How to Set Up AtScale on GCP

    This procedure is a step-by-step guide on setting up AtScale on Google Cloud Platform (GCP) with HTTP + TCP load balancer. Instance  Create at least three VM hosts for the AtScale...

  • How to Tail Logs Directly from the Supervisor

    Sometimes when a user enters a command in Supervisor CLI, and something goes wrong, it is not obvious what caused the issue, and the user needs to exit Supervisor CLI to review log...

  • How to Take a Thread Dump of the Engine Process

     Use the following steps to identify the engine Java process and collect thread dump information:1. Find PID using "ps -ef" command.   63927 is used to run the Java process in this...

  • How to Update a Custom Engine Property Through the Design Center

    In some rare cases, AtScale support would ask users to update certain custom hidden engine properties. For example, update "query.drillToRaw.columnCountThreshold" to "10".  Here a...

  • How to Use AtScale GCP with a Load Balancer

      Getting Started  Create a new virtual machine instance and an instance group:   Create a Load Balancer    POST https://dev-compute.sandbox.googleapis.com/compute/be...

  • Shut Down and Start Up Procedures for Multi-Node AtScale Environments

    The following is the shutdown and restart sequence for a Clustered AtScale Multi-Node Environment containing Clustered AtScale Engine nodes and Query Engine nodes (if present). Not...