---
title: "Trino Client Supported Features"
slug: "trino-client-supported-features"
updated: 2026-10-27T17:23:32Z
published: 2026-10-27T17:23:32Z
canonical: "docs.vastdata.com/trino-client-supported-features"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vastdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Trino Client Supported Features

## Creating Database Views

You can create database views using the Trino client when connected to a VAST Database. Views allow you to save queries and re-use them in other queries.

Database views are stored queries that present a part of a VAST Database. They are created and managed using the client application and stored in a table in the database itself. They can be used in other queries on the database.

| Action | Example |
| --- | --- |
| Create a new View | ```plaintext CREATE VIEW vast."mybucket/myschema".myview COMMENT "view comment" AS (SELECT col1, col2 FROM vast."mybucket/myschema".mytable WHERE col1 > 0) ``` |
| List Views in the database | Trino has no direct way of listing views. You can use workarounds like this example, where all views have the suffix "_view". ```plaintext SHOW TABLES FROM vast."mybucket/myschema" LIKE '%_view%' ``` |
| Show details for a View | ```plaintext SHOW CREATE VIEW vast."mybucket/myschema".myview ``` |
| Redefine a View | ```plaintext ALTER VIEW vast."mybucket/myschema".myview AS (SELECT col1, col2 FROM vast."mybucket/myschema".mytable WHERE col1 > 0 AND col2 > 0) ``` |
| Query using a View | ```plaintext SELECT * FROM vast."mybucket/myschema".myview WHERE v_col2 > 5 ORDER BY v_col1 ``` |
| Rename a View | ```plaintext ALTER VIEW vast."mybucket/myschema".myview RENAME TO vast."mybucket/myschema".mynewview ``` |

### Limitations

- View properties are not supported
- Nested data types are not supported
- User-defined column names and comments are lost if the schema of the query changes when redefining a view