You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Pritesh Maker (JIRA)" <ji...@apache.org> on 2017/11/13 18:40:00 UTC
[jira] [Issue Comment Deleted] (DRILL-5889) sqlline loses RPC
connection
[ https://issues.apache.org/jira/browse/DRILL-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pritesh Maker updated DRILL-5889:
---------------------------------
Comment: was deleted
(was: Github user sachouche commented on the issue:
https://github.com/apache/drill/pull/1015
Padma, DRILL-5889 is the wrong JIRA (sqlline loses RPC..); I think your JIRA is 5899
Regards,
Salim
________________________________
From: Padma Penumarthy <no...@github.com>
Sent: Wednesday, November 1, 2017 11:15:20 AM
To: apache/drill
Cc: Salim Achouche; Mention
Subject: Re: [apache/drill] DRILL-5889: Simple pattern matchers can work with DrillBuf directly (#1015)
@sachouche<https://github.com/sachouche> @paul-rogers<https://github.com/paul-rogers> can you please review ?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<https://github.com/apache/drill/pull/1015#issuecomment-341192974>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AckoK8UN4uDlGPJGg6fpypIbPxKEOqGKks5syLU4gaJpZM4QJzty>.
)
> sqlline loses RPC connection
> ----------------------------
>
> Key: DRILL-5889
> URL: https://issues.apache.org/jira/browse/DRILL-5889
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 1.11.0
> Reporter: Robert Hou
> Assignee: Pritesh Maker
> Attachments: 26183ef9-44b2-ef32-adf8-cc2b5ba9f9c0.sys.drill, drillbit.log
>
>
> Query is:
> {noformat}
> 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;
> {noformat}
> Error is:
> {noformat}
> 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)
> {noformat}
> 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:
> {noformat}
> | 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`]]])
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)