You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Dan Dosch (JIRA)" <ji...@apache.org> on 2015/09/23 20:42:04 UTC
[jira] [Updated] (HIVE-11938) Beeline - strange behavior when
server responds quickly
[ https://issues.apache.org/jira/browse/HIVE-11938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Dosch updated HIVE-11938:
-----------------------------
Description:
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}
was:
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
> 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.1.0, 1.2.1
> 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}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)