[ec2-user@ip-10-150-96-149 apache-drill-1.11.0-SNAPSHOT]$ bin/drill-embedded
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Jul 24, 2017 6:34:27 PM org.glassfish.jersey.server.ApplicationHandler initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
apache drill 1.11.0-SNAPSHOT
"drill baby drill"
0: jdbc:drill:zk=local> use kudu;
+-------+-----------------------------------+
|  ok   |              summary              |
+-------+-----------------------------------+
| true  | Default schema changed to [kudu]  |
+-------+-----------------------------------+
1 row selected (0.597 seconds)
0: jdbc:drill:zk=local> describe pulse_report;
+----------------+------------+--------------+
|  COLUMN_NAME   | DATA_TYPE  | IS_NULLABLE  |
+----------------+------------+--------------+
| year           | INTEGER    | NO           |
| month          | INTEGER    | NO           |
| day            | INTEGER    | NO           |
| hour           | INTEGER    | NO           |
| campaign_id    | BIGINT     | NO           |
| strategy_id    | BIGINT     | NO           |
| exch_id        | INTEGER    | NO           |
| mm_date_gmt    | TIMESTAMP  | NO           |
| gmt_offset     | INTEGER    | NO           |
| impressions    | INTEGER    | NO           |
| media_cost     | DOUBLE     | NO           |
| total_ad_cost  | DOUBLE     | NO           |
| total_spend    | DOUBLE     | NO           |
+----------------+------------+--------------+
13 rows selected (2.074 seconds)
0: jdbc:drill:zk=local> select campaign_id,impressions from pulse_report where `day` = 14 and campaign_id = 132444 and `hour` = 1;
+--------------+--------------+
| campaign_id  | impressions  |
+--------------+--------------+
| 132444       | 2            |
| 132444       | 11           |
| 132444       | 2            |
| 132444       | 31           |
| 132444       | 8            |
| 132444       | 12           |
| 132444       | 9            |
| 132444       | 11           |
| 132444       | 1            |
| 132444       | 7            |
| 132444       | 11           |
| 132444       | 2            |
| 132444       | 3            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 4            |
| 132444       | 4            |
| 132444       | 2            |
| 132444       | 9            |
| 132444       | 5            |
| 132444       | 2            |
| 132444       | 7            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 4            |
| 132444       | 3            |
| 132444       | 3            |
| 132444       | 1            |
| 132444       | 6            |
| 132444       | 2            |
| 132444       | 1            |
| 132444       | 3            |
| 132444       | 1            |
| 132444       | 13           |
| 132444       | 2            |
| 132444       | 3            |
| 132444       | 5            |
| 132444       | 1            |
| 132444       | 5            |
| 132444       | 1            |
| 132444       | 3            |
| 132444       | 4            |
| 132444       | 18           |
| 132444       | 7            |
| 132444       | 2            |
| 132444       | 5            |
| 132444       | 7            |
| 132444       | 1            |
| 132444       | 15           |
| 132444       | 1            |
| 132444       | 2            |
| 132444       | 1            |
| 132444       | 12           |
| 132444       | 3            |
| 132444       | 5            |
| 132444       | 1            |
| 132444       | 6            |
| 132444       | 15           |
| 132444       | 3            |
| 132444       | 7            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 4            |
| 132444       | 2            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 2            |
| 132444       | 2            |
| 132444       | 1            |
| 132444       | 17           |
| 132444       | 4            |
| 132444       | 6            |
| 132444       | 2            |
| 132444       | 3            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 2            |
| 132444       | 6            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 1            |
| 132444       | 19           |
| 132444       | 4            |
| 132444       | 5            |
| 132444       | 5            |
| 132444       | 13           |
| 132444       | 2            |
| 132444       | 3            |
| 132444       | 4            |
| 132444       | 6            |
| 132444       | 1            |
| 132444       | 4            |
| 132444       | 5            |
| 132444       | 2            |
+-------------+-------------+
| campaign_id | impressions |
+-------------+-------------+
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 7           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 4           |
| 132444      | 81          |
| 132444      | 20          |
| 132444      | 11          |
| 132444      | 20          |
| 132444      | 41          |
| 132444      | 1           |
| 132444      | 3           |
| 132444      | 10          |
| 132444      | 3           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 12          |
| 132444      | 8           |
| 132444      | 2           |
| 132444      | 4           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 11          |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 3           |
| 132444      | 1           |
| 132444      | 9           |
| 132444      | 2           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 1           |
| 132444      | 3           |
+-------------+-------------+
141 rows selected (0.906 seconds)
0: jdbc:drill:zk=local> select campaign_id,sum(impressions) from pulse_report where `day` = 14 and campaign_id = 132444 and `hour` = 1  group by campaign_id ;
+--------------+---------+
| campaign_id  | EXPR$1  |
+--------------+---------+
| 132444       | 734     |
+--------------+---------+
1 row selected (1.492 seconds)
0: jdbc:drill:zk=local> select campaign_id,sum(impressions) from pulse_report where `day` = 14 and campaign_id = 132444 and `hour` = 1  group by campaign_id ;
Error: SYSTEM ERROR: IllegalStateException: Failure while reading vector.  Expected vector class of org.apache.drill.exec.vector.NullableIntVector but was holding vector class org.apache.drill.exec.vector.BigIntVector, field= campaign_id(BIGINT:REQUIRED)

Fragment 1:0

[Error Id: 4365288d-2fa9-4b3a-9819-26caff2f0a67 on ip-10-150-96-149.ec2.internal:31010] (state=,code=0)