Shulou(Shulou.com)06/01 Report--

Presto tests the performance of a single node and what is the usage of presto sql statements. In order to solve this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

1.presto mysql data is written to hive

Insert into hive.prestotest.mysqldata select * from mysql.lyjtest.data

two。 Copy data

Insert into hive.prestotest.mysqldata select * from hive.prestotest.mysqldata

3. Query

Presto:lyjpresto > select count (name), name from mysqldata group by name _ col0 | name-+-33554432 | 2 33554432 | 1 33554432 | 3 (3 rows) Query 20201230_042634_00067_mczzp, FINISHED, 1 nodeSplits: 74 total, 74 done (100.00%) 0:09 [101m rows 23.4MB] [11.2M rows/s, 2.61MB/s]

4. Commonly used sql

Select * from mysql.lyjtest.data;// query data

Create table lyjpresto.mysqldata as select * from mysql.lyjtest.data; / / create tables based on other tables

Help / / help

Show catalogs;// View data Source

Show schemas;// query database

Use hive.test;// enters a database

Show tables; / / View the tables under a database

This is the answer to the question about the single-node performance of presto testing and the usage of presto sql sentences. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.