Dan Dosch created HIVE-11938:
--------------------------------
Summary: Beeline - strange behavior when server responds quickly
Key: HIVE-11938
URL: https://issues.apache.org/jira/browse/HIVE-11938
Project: Hive
Issue Type: Bug
Components: Beeline
Affects Versions: 1.2.1, 1.1.0
Reporter: Dan Dosch
Priority: Minor
Running into an odd issue where Beeline is taking the output which contains all
three columns, and displaying the first column above the results, and not
displaying the other two columns at all. An example of the output can be seen
below:
{code}
Beeline version 1.2.1 by Apache Hive
beeline> !connect jdbc:hive2://192.168.99.1:11111
Connecting to jdbc:hive2://192.168.99.1:11111
Connected to: Apache Hive (version 0.13.0)
Driver: Hive JDBC (version 1.2.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://192.168.99.1:11111> select color, sum(`Order Quantity`) _c1,
sum(`Sales Amount`) _c2 from devschema.dave_default group by color;
Yellow
Silver
Black
Red
White
Multi
Blue
+--------+------+------+--+
| color | _c1 | _c2 |
+--------+------+------+--+
+--------+------+------+--+
No rows selected (0.927 seconds)
{code}
This seems to occur if the TGetOperationStatusResp is returned too quickly, or
if the query results themselves return too quickly. If I intentionally make the
response TGetOperationStatusResp (adding a 50ms sleep) and the query itself
take longer (3000ms sleep), then this problem does not occur and the same query
returns results as you would expect.
{code}
0: jdbc:hive2://192.168.99.1:22222> select color, sum(`Order Quantity`) _c1,
sum(`Sales Amount`) _c2 from devschema.dave_default group by color;
+---------+--------+----------------------+--+
| color | _c1 | _c2 |
+---------+--------+----------------------+--+
| Yellow | 7599 | 7655535.572937012 |
| | 45456 | 679863.2531113625 |
| Silver | 5408 | 8006530.302539825 |
| Black | 15681 | 1.402016470304108E7 |
| Red | 7716 | 1.208516000507736E7 |
| White | 908 | 8162.919813156128 |
| Multi | 6196 | 168616.0429916382 |
| Blue | 6203 | 3569734.185958862 |
+---------+--------+----------------------+--+
8 rows selected (3.587 seconds)
{code}
I've attached the thrift requests and responses
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
