[DRILL-5889] sqlline loses RPC connection

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Component/s: Execution - Relational Operators
• Assignee: Pritesh Maker
• Reporter: Robert Hou
• Created: 18/Oct/17 21:33
• Updated: 13/Nov/17 18:40

Description

Query is:

alter session set `planner.memory.max_query_memory_per_node` = 10737418240;
select count(*), max(`filename`) from dfs.`/drill/testdata/hash-agg/data1` group by no_nulls_col, nulls_col;

Error is:

0: jdbc:drill:drillbit=10.10.100.190> select count(*), max(`filename`) from dfs.`/drill/testdata/hash-agg/data1` group by no_nulls_col, nulls_col;
Error: CONNECTION ERROR: Connection /10.10.100.190:45776 <--> /10.10.100.190:31010 (user client) closed unexpectedly. Drillbit down?


[Error Id: db4aea70-11e6-4e63-b0cc-13cdba0ee87a ] (state=,code=0)

From drillbit.log:
2017-10-18 14:04:23,044 [UserServer-1] INFO o.a.drill.exec.rpc.user.UserServer - RPC connection /10.10.100.190:31010 <--> /10.10.100.190:45776 (user server) timed out. Timeout was set to 30 seconds. Closing connection.

Plan is:

| 00-00    Screen
00-01      Project(EXPR$0=[$0], EXPR$1=[$1])
00-02        UnionExchange
01-01          Project(EXPR$0=[$2], EXPR$1=[$3])
01-02            HashAgg(group=[{0, 1}], EXPR$0=[$SUM0($2)], EXPR$1=[MAX($3)])
01-03              Project(no_nulls_col=[$0], nulls_col=[$1], EXPR$0=[$2], EXPR$1=[$3])
01-04                HashToRandomExchange(dist0=[[$0]], dist1=[[$1]])
02-01                  UnorderedMuxExchange
03-01                    Project(no_nulls_col=[$0], nulls_col=[$1], EXPR$0=[$2], EXPR$1=[$3], E_X_P_R_H_A_S_H_F_I_E_L_D=[hash32AsDouble($1, hash32AsDouble($0, 1301011))])
03-02                      HashAgg(group=[{0, 1}], EXPR$0=[COUNT()], EXPR$1=[MAX($2)])
03-03                        Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:///drill/testdata/hash-agg/data1]], selectionRoot=maprfs:/drill/testdata/hash-agg/data1, numFiles=1, usedMetadataFile=false, columns=[`no_nulls_col`, `nulls_col`, `filename`]]])