
在
Presto
中使用
SQL
|
137
SELECT nationkey, name, regionkey
FROM tpch.sf1.nation;
nationkey | name | regionkey
-----------+----------------+-----------
0 | ALGERIA | 0
1 | ARGENTINA | 1
2 | BRAZIL | 1
3 | CANADA | 1
4 | EGYPT | 4
5 | ETHIOPIA | 0
...
或是从
customer
表获得一些数据:
SELECT custkey, nationkey, phone, acctbal, mktsegment
FROM tpch.tiny.customer;
custkey | nationkey | phone | acctbal | mktsegment
---------+-----------+-----------------+---------+------------
751 | 0 | 10-658-550-2257 | 2130.98 | FURNITURE
752 | 8 | 18-924-993-6038 | 8363.66 | MACHINERY
753 | 17 | 27-817-126-3646 | 8114.44 | HOUSEHOLD
754 | 0 | 10-646-595-5871 | -566.86 | ...