skills.homes logoskills.homescapability registry
home/categories/sql-databases/treasure-data-td-skills-sql-skills-trino-to-hive-migration-skill-md
cd ..
sql-databasesdatabases

trino-to-hive-migration

Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.

View Sourcesql-databases
treasure-data
maintainer
treasure-data
Updated 1/9/2026
Stars
5
Forks
4
quick start

Installation and usage

Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use trino-to-hive-migration