cloudera impala 交集、差集实际测试数据
[root@hadoop1 test-im]# impala-shell -i hadoop2 -f z_join_test_big_data.sql
Starting Impala Shell without Kerberos authentication
Connected to hadoop2:21000
Server version: impalad version 1.2.4 RELEASE (build ac29ae09d66c1244fe2ceb293083723226e66c1a)
Query: use db01
Query: show tables
+----------------------------------+
| name |
+----------------------------------+
| ontime |
| ontime_parquet |
| ontime_partitioned_parquet | ( 此表有 1.5 亿条数据 )
| ontime_partitioned_parquet_21_yi | ( 此表有 21.5 亿条数据 )
+----------------------------------+
Returned 4 row(s) in 0.01s
#有重复的数据
Query: select count(origincityname) from ontime_partitioned_parquet where year=2001 and month=1 and airlineid=20355 and dayofmonth=1
+-----------------------+
| count(origincityname) |
+-----------------------+
| 1980 |
+-----------------------+
Returned 1 row(s) in 0.41s
#有重复的数据