0: jdbc:phoenix:localhost:2181:/hbase> !describe US_POPULATION
+------------+--------------+----------------+--------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+-------------+----------------+-------------------+--------------------+-------------------+--------------+----------------+---------------+--------------+-------------------+-------------------+-------------+----------------+----------+----------------+---------------+----------+
| TABLE_CAT  | TABLE_SCHEM  |   TABLE_NAME   | COLUMN_NAME  | DATA_TYPE  | TYPE_NAME  | COLUMN_SIZE  | BUFFER_LENGTH  | DECIMAL_DIGITS  | NUM_PREC_RADIX  | NULLABLE  | REMARKS  | COLUMN_DEF  | SQL_DATA_TYPE  | SQL_DATETIME_SUB  | CHAR_OCTET_LENGTH  | ORDINAL_POSITION  | IS_NULLABLE  | SCOPE_CATALOG  | SCOPE_SCHEMA  | SCOPE_TABLE  | SOURCE_DATA_TYPE  | IS_AUTOINCREMENT  | ARRAY_SIZE  | COLUMN_FAMILY  | TYPE_ID  | VIEW_CONSTANT  | MULTI_TENANT  | KEY_SEQ  |
+------------+--------------+----------------+--------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+-------------+----------------+-------------------+--------------------+-------------------+--------------+----------------+---------------+--------------+-------------------+-------------------+-------------+----------------+----------+----------------+---------------+----------+
|            |              | US_POPULATION  | STATE        | 1          | CHAR       | 2            | null           | null            | null            | 0         |          |             | null           | null              | null               | 1                 | false        |                |               |              | null              |                   | null        |                | 1        |                |               | 1        |
|            |              | US_POPULATION  | CITY         | 12         | VARCHAR    | null         | null           | null            | null            | 0         |          |             | null           | null              | null               | 2                 | false        |                |               |              | null              |                   | null        |                | 12       |                |               | 2        |
|            |              | US_POPULATION  | POPULATION   | -5         | BIGINT     | null         | null           | null            | null            | 1         |          |             | null           | null              | null               | 3                 | true         |                |               |              | null              |                   | null        | 0              | -5       |                |               | null     |
+------------+--------------+----------------+--------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+-------------+----------------+-------------------+--------------------+-------------------+--------------+----------------+---------------+--------------+-------------------+-------------------+-------------+----------------+----------+----------------+---------------+----------+
0: jdbc:phoenix:localhost:2181:/hbase> select * from US_POPULATION
. . . . . . . . . . . . . . . . . . .> ;
+--------+---------------+-------------+
| STATE  |     CITY      | POPULATION  |
+--------+---------------+-------------+
| AZ     | Phoenix       | 1461575     |
| CA     | Los Angeles   | 3844829     |
| CA     | San Diego     | 1255540     |
| CA     | San Jose      | 912332      |
| IL     | Chicago       | 2842518     |
| NY     | New York      | 8143197     |
| PA     | Philadelphia  | 1463281     |
| TX     | Dallas        | 1213825     |
| TX     | Houston       | 2016582     |
| TX     | San Antonio   | 1256509     |
+--------+---------------+-------------+
10 rows selected (0.039 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> explain select count(*) from US_POPULATION as u join US_POPULATION as p on u.state = p.state;
+---------------------------------------------------------------------------------+-----------------+----------------+
|                                      PLAN                                       | EST_BYTES_READ  | EST_ROWS_READ  |
+---------------------------------------------------------------------------------+-----------------+----------------+
| CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER US_POPULATION                      | null            | null           |
|     SERVER FILTER BY FIRST KEY ONLY                                             | null            | null           |
|     SERVER AGGREGATE INTO SINGLE ROW                                            | null            | null           |
|     PARALLEL INNER-JOIN TABLE 0 (SKIP MERGE)                                    | null            | null           |
|         CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN FULL SCAN OVER US_POPULATION  | null            | null           |
|             SERVER FILTER BY FIRST KEY ONLY                                     | null            | null           |
|     DYNAMIC SERVER FILTER BY U.STATE IN (P.STATE)                               | null            | null           |
+---------------------------------------------------------------------------------+-----------------+----------------+
7 rows selected (0.028 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> explain select * from US_POPULATION as u join US_POPULATION as p on u.state = p.state;
+---------------------------------------------------------------------------------+-----------------+----------------+
|                                      PLAN                                       | EST_BYTES_READ  | EST_ROWS_READ  |
+---------------------------------------------------------------------------------+-----------------+----------------+
| CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN FULL SCAN OVER US_POPULATION          | null            | null           |
|     PARALLEL INNER-JOIN TABLE 0                                                 | null            | null           |
|         CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN FULL SCAN OVER US_POPULATION  | null            | null           |
|     DYNAMIC SERVER FILTER BY U.STATE IN (P.STATE)                               | null            | null           |
+---------------------------------------------------------------------------------+-----------------+----------------+