Dremio Software

https://docs.dremio.com/25.x
Admin
Dremio Software is a data lakehouse platform that enables users to connect to various data sources,...
Tokens:515,953
Snippets:6,036
Trust Score:10
Update:3 months ago
Show doc for...
Tokens:
Raw
### LOCATE function usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/LOCATE

Examples demonstrating basic substring searching and searching with a specified start position.

```sql
SELECT LOCATE('no','banana')  
-- 0  
```

```sql
SELECT LOCATE('an','banana')  
-- 2  
```

```sql
SELECT LOCATE('an','banana', 3)  
-- 4  
```

--------------------------------

### Create Function Examples

Source: https://docs.dremio.com/25.x/reference/sql/commands/functions

Examples of creating scalar functions with and without parameters.

```sql
CREATE FUNCTION hello() RETURNS VARCHAR RETURN SELECT 'Hello World!';
```

```sql
CREATE FUNCTION multiply (x INT, y INT) RETURNS INT RETURN SELECT x * y;
```

--------------------------------

### Show Branches Examples

Source: https://docs.dremio.com/25.x/reference/sql/commands/nessie/show-branches

Examples of listing branches in the current or a specified source.

```sql
SHOW BRANCHES  
```

```sql
SHOW BRANCHES in mySource  
```

--------------------------------

### MongoDB Configuration Parameter Examples

Source: https://docs.dremio.com/25.x/reference/api/catalog/source/container-source-config

Individual parameter examples for MongoDB source configuration.

```json
[{"hostname": "172.23.0.208","port": 27017}]
```

```json
false
```

```json
ANONYMOUS
```

```json
exampleuser
```

```json
admin
```

```json
2000
```

```json
false
```

```json
0
```

```json
4095
```

```json
FIRST
```

```json
[{"name": "maxPoolSize","value": "100"}]
```

```json
false
```

```json
172.23.0.208
```

```json
27017
```

```json
maxPoolSize
```

```json
100
```

--------------------------------

### Dropping a Pipe Example

Source: https://docs.dremio.com/25.x/reference/sql/commands/drop-pipe

An example demonstrating how to drop a pipe named Example_pipe.

```sql
DROP PIPE Example_pipe
```

--------------------------------

### Show Functions Examples

Source: https://docs.dremio.com/25.x/reference/sql/commands/functions

Examples of listing functions using various filter patterns.

```sql
SHOW FUNCTIONS;
```

```sql
SHOW FUNCTIONS LIKE 'protect_ssn';
```

```sql
SHOW FUNCTIONS LIKE 'protect_%';
```

--------------------------------

### BITWISE_AND usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BITWISE_AND

Examples demonstrating the bitwise AND operation on numeric inputs.

```sql
SELECT BITWISE_AND(7, 4)  
-- 4  
```

```sql
SELECT BITWISE_AND(1, 2)  
-- 0  
```

--------------------------------

### Show Tags Examples

Source: https://docs.dremio.com/25.x/reference/sql/commands/nessie/show-tags

Examples of listing tags in the current source or a specific source.

```sql
SHOW TAGS  
```

```sql
SHOW TAGS  
IN mySource  
```

--------------------------------

### ASCII Function Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/ASCII

Examples demonstrating the ASCII function with various string inputs.

```sql
SELECT ASCII ('DREMIO')  
-- 68  
```

```sql
SELECT ASCII ('D')  
-- 68  
```

```sql
SELECT ASCII ('')  
-- 0  
```

--------------------------------

### SIGN function examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/SIGN

Examples demonstrating the SIGN function with various numeric inputs.

```sql
SELECT SIGN(10.3)  
-- 1  
```

```sql
SELECT SIGN(-5)  
-- -1  
```

```sql
SELECT SIGN(24)  
-- 1  
```

```sql
SELECT SIGN(0.0)  
-- 0  
```

--------------------------------

### Example URI with Password

Source: https://docs.dremio.com/25.x/sonar/client-applications/clients/superset

A concrete example of a connection URI using username and password authentication.

```text
dremio+flight://myUserID:myPassword@myHost:32010/Samples?UseEncryption=false
```

--------------------------------

### Reflection Parameter Examples

Source: https://docs.dremio.com/25.x/reference/api/reflections

Examples of JSON structures for various reflection configuration parameters.

```json
AGGREGATION
```

```json
New Aggregation Reflection
```

```json
df99ab32-c2d4-4d1c-9e91-2c8be861bb8a
```

```json
true
```

```json
false
```

```json
[{"name": "pickup_datetime"},{"name": "passenger_count"},{"name": "trip_distance_mi"},{"name": "fare_amount"},{"name": "tip_amount"},{"name": "total_amount"}]
```

```json
[{"name": "pickup_datetime","granularity": "DATE"},{"name": "passenger_count","granularity": "DATE"},{"name": "total_amount","granularity": "DATE"},{"name": "trip_distance_mi","granularity": "DATE"}]
```

```json
[{"name": "passenger_count","measureTypeList": ["SUM", "COUNT"]},{"name": "trip_distance_mi","measureTypeList": ["SUM", "COUNT"]},{"name": "fare_amount","measureTypeList": ["SUM", "COUNT"]},{"name": "tip_amount","measureTypeList": ["SUM", "COUNT"]},{"name": "total_amount","measureTypeList": ["SUM", "COUNT"]}]
```

```json
[{"name": "trip_distance_mi"},{"name": "total_amount"}]
```

```json
[{"name": "pickup_datetime"},{"name": "passenger_count"}]
```

```json
[{"name": "trip_distance_mi"}]
```

```json
CONSOLIDATED
```

```json
reflection
```

```json
"name": "pickup_datetime"
```

--------------------------------

### Property List Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/source/container-source-config

Example of the propertyList array structure for defining connection properties.

```json
[{"name": "fs.s3a.aws.credentials.provider","value": "org.apache.hadoop.fs.s3a.SimpleAWSCredentialsProvider"}]
```

--------------------------------

### BITWISE_XOR Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BITWISE_XOR

Basic usage examples demonstrating the bitwise XOR operation on integer values.

```sql
SELECT BITWISE_XOR(7, 4)  
-- 3  
```

```sql
SELECT BITWISE_XOR(1, 2)  
-- 3  
```

--------------------------------

### Restore from Backup Example

Source: https://docs.dremio.com/25.x/admin/cli/restore

Example command to restore Dremio metadata from a specific backup directory.

```bash
./bin/dremio-admin restore -d /tmp/dremio_backup_05august/dremio_backup_2022-08-05_13.41
```

--------------------------------

### View SQL Context Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/view

Example of the SQL context array for the view query.

```json
["Samples", "samples.dremio.com"]
```

--------------------------------

### Privileges Array Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/privileges

Example list of available privileges for a specific grant type.

```json
["ALTER","ALTER_REFLECTION","MANAGE_GRANTS","MODIFY","SELECT","VIEW_REFLECTION"]
```

--------------------------------

### Example URI with PAT

Source: https://docs.dremio.com/25.x/sonar/client-applications/clients/superset

A concrete example of a connection URI using a personal access token.

```text
dremio+flight://myUserID:myPAT@myHost:32010/Samples?UseEncryption=false
```

--------------------------------

### Source Configuration Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/source

Example JSON object for the config parameter when creating an S3 source.

```json
{"accessKey": "EXAMPLE78HT89VS4YJEL","accessSecret": "EXAMPLEe3bcpKnAwgJ2WBpX8d9kEdhMz24guiR7L","secure": true,"rootPath": "/","enableAsync": true,"compatibilityMode": false,"isCachingEnabled": true,"maxCacheSpacePct": 100,"requesterPays": false,"enableFileStatusCheck": true,"defaultCtasFormat": "ICEBERG","isPartitionInferenceEnabled": false,"credentialType": "ACCESS_KEY"}
```

--------------------------------

### FLOOR function examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/FLOOR

Examples demonstrating the behavior of the FLOOR function with zero, positive, and negative numbers.

```sql
SELECT FLOOR(0)  
-- 0  
```

```sql
SELECT FLOOR(45.76)  
-- 45  
```

```sql
SELECT FLOOR(-1.3)  
-- -2  
```

--------------------------------

### Table Path Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/table

Example of the path array format required in the request body.

```json
["Samples", "samples.dremio.com", "Dremio University", "restaurant_reviews.parquet"]
```

--------------------------------

### Describe a pipe example

Source: https://docs.dremio.com/25.x/reference/sql/commands/describe-pipe

Example usage of the DESCRIBE PIPE command for a specific pipe named Example_pipe.

```sql
DESCRIBE PIPE Example_pipe
```

--------------------------------

### LTRIM usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/LTRIM

Examples demonstrating how to trim specific characters or default spaces from the beginning of a string.

```sql
SELECT LTRIM('pancake', 'pan')  
-- cake  
```

```sql
SELECT LTRIM('pancake', 'abnp')  
-- cake  
```

```sql
SELECT LTRIM('   dremio')  
-- dremio  
```

--------------------------------

### LEFT function usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/LEFT

Examples demonstrating how to use the LEFT function with different length parameters.

```sql
SELECT "LEFT"('Dremio - SQL Engine', -12)  
-- Dremio  
```

```sql
SELECT "LEFT"('Dremio - SQL Engine', 6)  
-- Dremio  
```

--------------------------------

### Start Docker containers

Source: https://docs.dremio.com/25.x/security/rbac/integrations/lake-formation/lake-formation-demo

Initializes the demo environment using the provided docker-compose file.

```bash
docker compose up -d
```

--------------------------------

### Start Dremio Service

Source: https://docs.dremio.com/25.x/get-started/cluster-deployments/deployment-models/standalone/dremio-config

Commands to initiate the Dremio service based on the installation type.

```bash
$ sudo <DREMIO-HOME>/bin/dremio start
```

```bash
$ sudo service dremio start
```

--------------------------------

### Start Fluent Bit

Source: https://docs.dremio.com/25.x/sonar/monitoring/exporting/aws-azure-storage

Execute the Fluent Bit binary pointing to your custom configuration file.

```bash
fluent-bit -c dremio_fluent-bit.conf  

```

--------------------------------

### Configuration File Examples

Source: https://docs.dremio.com/25.x/sonar/client-applications/clients/python

YAML configuration templates for connecting to local or clustered Dremio instances.

```yaml
username: my_username  
password: my_password  
query: SELECT 1  
```

```yaml
hostname: my_coordinator_node  
port: 32010  
username: my_username  
password: my_password  
query: SELECT 1  
```

--------------------------------

### Example Flight SQL JDBC URL

Source: https://docs.dremio.com/25.x/sonar/client-applications/clients/datagrip

Use this URL format for a local Dremio installation without encryption enabled.

```text
jdbc:arrow-flight-sql://localhost:32010?useEncryption=false
```

--------------------------------

### Grant Type Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/privileges

Example value for the grantType attribute.

```text
SPACE
```

--------------------------------

### Example SQL Query for Reflection Recommendation

Source: https://docs.dremio.com/25.x/sonar/reflections/reflection-recommendations

A sample SQL query used as input to generate reflection recommendations.

```sql
SELECT Max("p_size")  
FROM s3.bucket1.tpch.sf10.parquet.part  
JOIN s3.bucket1.tpch.sf10.parquet.lineitem  
ON "p_partkey" = "l_partkey"  
GROUP BY "p_brand"  
```

--------------------------------

### List backup command options

Source: https://docs.dremio.com/25.x/admin/cli/backup

Use the help flag to view all available configuration options for the backup utility.

```bash
./dremio-admin backup -h  
```

--------------------------------

### BITWISE_NOT Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BITWISE_NOT

Examples demonstrating the bitwise inversion of integer values.

```sql
SELECT BITWISE_NOT(0)  
-- -1  
```

```sql
SELECT BITWISE_NOT(9223372036854775807)  
-- -9223372036854775808  
```

--------------------------------

### Issuer Claim Example

Source: https://docs.dremio.com/25.x/security/authentication/external-token

Example of the issuer claim identifying the token provider.

```json
"iss": "https://server.example.com",
```

--------------------------------

### RSHIFT int64 Example

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/RSHIFT

Placeholder example for the int64 variant of the RSHIFT function.

```sql
sample call 1  
-- sample return 1  
```

--------------------------------

### BTRIM Usage Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BTRIM

Examples demonstrating how to use BTRIM with default space trimming and custom character sets.

```sql
SELECT BTRIM('      dremio ')  
-- dremio  
```

```sql
SELECT BTRIM('~/~/~/dremio~', '~')  
-- /~/~/dremio  
```

```sql
SELECT BTRIM('---dremio-', '-')  
-- dremio  
```

```sql
SELECT BTRIM('stringvalue', 'string')  
-- value  
```

```sql
SELECT BTRIM('pancake pan', 'abnp')  
-- cake  
```

--------------------------------

### ISNOTTRUE Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/IS__NOT__TRUE

Examples demonstrating the ISNOTTRUE function with integer and boolean inputs.

```sql
SELECT ISNOTTRUE(1)  
-- False  
```

```sql
SELECT ISNOTTRUE(FALSE)  
-- True  
```

```sql
SELECT ISNOTTRUE(0)  
-- True  
```

--------------------------------

### ISTRUE Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/IS__NOT__TRUE

Examples demonstrating the ISTRUE function with integer and boolean inputs.

```sql
SELECT ISTRUE(1)  
-- True  
```

```sql
SELECT ISTRUE(FALSE)  
-- False  
```

```sql
SELECT ISTRUE(0)  
-- False  
```

--------------------------------

### Sample service configuration

Source: https://docs.dremio.com/25.x/get-started/cluster-deployments/deployment-models/standalone/standalone-tarball

Example content for the dremio.service file used to manage the Dremio daemon.

```ini
    #  
    # Installation is assumed to be under /opt/dremio  
    #  
    [Unit]  
    Description=Dremio Daemon Server  
    Documentation=https://docs.dremio.com  
    Wants=network-online.target  
    After=network-online.target  
      
    [Service]  
    User=dremio  
    Group=dremio  
    RuntimeDirectory=dremio  
    ExecStart=/opt/dremio/bin/dremio start-fg  
    Restart=on-failure  
    # Set maximum number of file descriptors Dremio can open.  
    # Dremio requires a large number to work correctly.  
    LimitNOFILE=65536  
      
      
    [Install]  
    WantedBy=multi-user.target  

```

--------------------------------

### Convert VARCHAR to BINARY

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BINARY_STRING

Examples demonstrating the conversion of string literals to binary format.

```sql
SELECT BINARY_STRING('DREMIO')  
-- RFJFTUlP  
```

```sql
SELECT BINARY_STRING('000')  
-- MDAw  
```

--------------------------------

### CREATE TABLE AS Syntax

Source: https://docs.dremio.com/25.x/reference/sql/commands/create-table-as

The general syntax for the CREATE TABLE AS command, including optional partitioning, sorting, and table properties.

```sql
CREATE TABLE [IF NOT EXISTS] <table_name>  
  [ HASH PARTITION BY ( { <column_name> | <partition_transform> } [ , ... ] ) ]  
  [ LOCALSORT BY ( <column_name> [ , ... ] ) ]  
  [ TBLPROPERTIES ( '<property_name>' = '<property_value>' [ , ... ] ) ]  
  AS <select_statement>  
```

--------------------------------

### Build Connector with Maven

Source: https://docs.dremio.com/25.x/sonar/data-sources/arp-connector

Execute the Maven command to compile, test, package, and install the connector.

```bash
mvn clean install  

```

--------------------------------

### View Field Type Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/view

Example of a type object definition for a field.

```json
{"name": "BOOLEAN"}
```

--------------------------------

### Reset password example

Source: https://docs.dremio.com/25.x/admin/cli/reset-password

A concrete example of resetting the password for a specific user.

```bash
./dremio-admin set-password -u user123 -p dremio123  
```

--------------------------------

### Sample Group List Configuration

Source: https://docs.dremio.com/25.x/get-started/cluster-deployments/customizing-configuration/ldap

Example configuration for implementing the GROUP_ENTRY_LISTS_USERS relationship between users and groups.

```json
{
    "connectionMode": "PLAIN",
    "servers": [
        {
            "hostname": "host_ip",
            "port": 389
        }
    ],
    "names": {
        "bindDN": "CN=admin,DC=drem,DC=io",
        "bindMethod": "UNAUTHENTICATED",
        "bindPassword": "admin",
        "baseDN": "dc=drem,dc=io",
        "userFilter": "&(objectClass=posixAccount)",
        "userAttributes": {
            "baseDNs": [
                "OU=Users,OU=ldaptest,DC=drem,DC=io",
            ],
            "id": "uid",
            "firstname": "givenName",
            "lastname": "sn",
            "email": "mail"
        },
        "userGroupRelationship": "GROUP_ENTRY_LISTS_USERS",
        "groupEntryListsUsers": {
            "userEntryUserIdAttribute": "uid",
            "groupEntryUserIdAttribute": "memberUid"
        },
        "groupDNs": ["cn={0},OU=test,OU=ldaptest,DC=drem,DC=io",
                     "cn={0},OU=dev,OU=ldaptest,DC=drem,DC=io"],
        "groupFilter": "|(objectClass=posixGroup)(objectClass=sub)",
        "autoAdminFirstUser": false
    }
}
```

--------------------------------

### Create dremio directories

Source: https://docs.dremio.com/25.x/get-started/cluster-deployments/deployment-models/standalone/standalone-tarball

Sets up the necessary directories for Dremio installation, logs, and runtime data with appropriate ownership.

```bash
sudo mkdir /opt/dremio  
sudo mkdir /var/run/dremio && sudo chown dremio:dremio /var/run/dremio  
sudo mkdir /var/log/dremio && sudo chown dremio:dremio /var/log/dremio  
sudo mkdir /var/lib/dremio && sudo chown dremio:dremio /var/lib/dremio  

```

--------------------------------

### Property List Example

Source: https://docs.dremio.com/25.x/reference/api/catalog/source/container-source-config

Example of the propertyList array structure used for connection properties.

```json
[{"name": "dremio.azure.mode","value": "STORAGE_V2"}]
```

--------------------------------

### DAYOFYEAR SQL Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/DAYOFYEAR

Examples demonstrating the use of DAYOFYEAR with DATE and TIMESTAMP expressions.

```sql
SELECT DAYOFYEAR(DATE '2021-02-28')  
-- 59  
```

```sql
SELECT DAYOFYEAR(TIMESTAMP '2021-03-15 11:43:22')  
-- 74  
```

--------------------------------

### DAYOFWEEK Usage Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/DAYOFWEEK

Examples demonstrating the use of DAYOFWEEK with DATE and TIMESTAMP inputs.

```sql
SELECT DAYOFWEEK(DATE '2021-02-28')  
-- 1  
```

```sql
SELECT DAYOFWEEK(TIMESTAMP '2021-02-27 11:43:22')  
-- 7  
```

--------------------------------

### Create a View

Source: https://docs.dremio.com/25.x/reference/sql/commands/datasets

Defines the syntax and an example for creating a new view. The target path must exist prior to execution.

```sql
CREATE VIEW <VIEW-PATH> AS <SQL-QUERY>  
```

```sql
CREATE VIEW demo.jobs_view as SELECT * FROM "oracle_e2e".DREMIO.JOBS  
```

--------------------------------

### REGEXP_SPLIT Examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/REGEXP_SPLIT

Examples demonstrating how different keywords and integer values affect the splitting behavior of the REGEXP_SPLIT function.

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'FIRST', -1) AS R_LESS_SHIPMENT_TYPE  
-- ['', 'EGULAR AIR']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'LAST', -1) AS R_LESS_SHIPMENT_TYPE  
-- ['REGULAR AI', '']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'INDEX', 1) AS R_LESS_SHIPMENT_TYPE  
-- ['REGULA', ' AIR']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'ALL', 1) AS R_LESS_SHIPMENT_TYPE  
-- ['']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'ALL', 2) AS R_LESS_SHIPMENT_TYPE  
-- ['', 'EGULA']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'ALL', 3) AS R_LESS_SHIPMENT_TYPE  
-- ['', 'EGULA', ' AI']
```

```sql
SELECT REGEXP_SPLIT('REGULAR AIR', 'R', 'ALL', 4) AS R_LESS_SHIPMENT_TYPE  
-- ['', 'EGULA', ' AI', '']
```

--------------------------------

### BIN function usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/BIN

Examples showing the conversion of positive integers, negative integers, and null values to binary strings.

```sql
SELECT BIN(100)  
-- 1100100  
```

```sql
SELECT BIN(-100)  
-- 11111111111111111111111110011100  
```

```sql
SELECT BIN(null)  
-- null  
```

--------------------------------

### Cron Schedule Examples

Source: https://docs.dremio.com/25.x/reference/api/catalog/source

Examples of cron expressions used for scheduling reflection refreshes.

```text
0 0 0 * * ?
```

```text
0 45 15 * * 1,4,7
```

```text
0 15 7 ? * 2-6
```

--------------------------------

### Start Dremio from Tarball

Source: https://docs.dremio.com/25.x/get-started/yarn-quickstart

Launch the Dremio service from the bin directory.

```bash
./dremio start  
```

--------------------------------

### Roles Array Example

Source: https://docs.dremio.com/25.x/reference/api/roles

Example of the roles array containing nested role objects.

```json
[{"id": "6f87a9c5-d733-4935-8331-875a4a8e09d7","name": "SELECT and CREATE","type": "INTERNAL"},{"id": "f8426061-8413-46ec-a84d-1b481a97b248","name": "VIEW","type": "INTERNAL"}]
```

--------------------------------

### NTILE Window Function Example

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/NTILE

Demonstrates using NTILE to assign bucket numbers to rows partitioned by category and ordered by day of the week.

```sql
SELECT "Category",   
  "Descript",   
  "DayOfWeek",  
  NTILE(1)   
    OVER (  
      PARTITION BY "Category"   
      ORDER BY "DayOfWeek")  
FROM Samples."samples.dremio.com"."SF_incidents2016.json"  
-- Category, Descript, DayOfWeek, EXPR$3  
-- ARSON, ARSON, Friday, 1   
-- EMBEZZLEMENT, EMBEZZLED VEHICLE, Friday, 1
```

--------------------------------

### Dremio Service Commands by Installation Type

Source: https://docs.dremio.com/25.x/admin/start-stop

Comparison of commands for Tarball and RPM installations.

```bash
Help: <DREMIO-HOME>/bin/dremio | service dremio
Start: <DREMIO-HOME>/bin/dremio start | service dremio start
Stop: <DREMIO-HOME>/bin/dremio stop | service dremio stop
Status: <DREMIO-HOME>/bin/dremio status | service dremio status
Restart: <DREMIO-HOME>/bin/dremio restart | service dremio restart
Autorestart: <DREMIO-HOME>/bin/dremio autorestart | service dremio autorestart
```

--------------------------------

### Start Dremio Service

Source: https://docs.dremio.com/25.x/get-started/yarn-quickstart

Start the Dremio service using the system service manager.

```bash
sudo service dremio start  
```

--------------------------------

### CREATE FOLDER Syntax

Source: https://docs.dremio.com/25.x/reference/sql/commands/nessie/create-folder

The basic syntax for creating a folder, including optional IF NOT EXISTS and reference clauses.

```sql
CREATE FOLDER [ IF NOT EXISTS ] <folder_name>  
   [ AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <refValue> ]  
```

--------------------------------

### Start Dremio Service

Source: https://docs.dremio.com/25.x/get-started/cluster-deployments/deployment-models/standalone/standalone-rpm

Command to start the Dremio service after the upgrade process is complete.

```bash
service dremio start
```

--------------------------------

### Show commit history examples

Source: https://docs.dremio.com/25.x/reference/sql/commands/nessie/show-logs

Various ways to invoke the SHOW LOGS command to view commit history.

```sql
SHOW LOGS  
```

```sql
SHOW LOGS  
  AT BRANCH myBranch  
```

```sql
SHOW LOGS  
  AT COMMIT "c7a79c74adf76649e643354c34ed69abfee5a3b070ef68cbe782a072b0a418ba"  
  in mySource  
```

--------------------------------

### User Claim Mapping Examples

Source: https://docs.dremio.com/25.x/security/authentication/external-token

Examples of mapping user identity claims such as upn or preferred_username.

```json
"upn": "user@dremio.com"
```

```json
"preferred_username": "user@dremio.com"
```

--------------------------------

### SET_UNION usage examples

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/SET_UNION

Examples demonstrating the removal of duplicates and merging of elements from two arrays.

```sql
SELECT SET_UNION(ARRAY[1, 2, 2, 3], ARRAY[1, 3, 5]);  
-- [2,3,5,1]  
```

```sql
SELECT SET_UNION(ARRAY[1, 1, 2], ARRAY[3, 3, 4]);  
-- [2,3,4,1]  
```

--------------------------------

### Calculate powers using POWER

Source: https://docs.dremio.com/25.x/reference/sql/sql-functions/functions/POW__POWER

Examples demonstrating the use of the POWER function with various numeric inputs.

```sql
SELECT POWER(5, 2)  
-- 25.0  
```

```sql
SELECT POWER(0.1, 2)  
-- 0.010000000000000002  
```

```sql
SELECT POWER(-2, 2)  
-- 4.0  
```

```sql
SELECT POWER(10, -2)  
-- 0.01  
```
Tokens:
Raw