Instalar Presto 8.8 Tutorial — Como
Presto CLI es una herramienta interactiva para enviar consultas SQL. Descárgala:
cd /opt/presto
wget https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.288/presto-cli-0.288-executable.jar
mv presto-cli-0.288-executable.jar presto-cli.jar
chmod +x presto-cli.jar
Conéctate al servidor local:
./presto-cli.jar --server localhost:8080 --catalog memory --schema default
Si usaste tpch:
./presto-cli.jar --server localhost:8080 --catalog tpch --schema sf1
Ejecuta una consulta de prueba:
SHOW CATALOGS;
SHOW SCHEMAS FROM memory;
CREATE TABLE memory.default.test AS SELECT 1 AS id;
SELECT * FROM memory.default.test;
Salida esperada:
id
----
1
(1 row)
¡Felicidades! Presto 8.8 está funcionando.
Create etc/catalog/memory.properties:
connector.name=memory
memory.max-data-per-node=256MB
sudo /opt/presto/bin/launcher stop
You now have Presto 8.8 running on a single node with TPC-H catalog. From here, you can:
Next steps: Check the official Presto 0.288 documentation for advanced configurations. como instalar presto 8.8 tutorial
Enjoy querying at interactive speed with Presto 8.8!