Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 13 Nov 2017 18:40:00 +0000 (UTC)
From: "Pritesh Maker (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13110488.1508362392000.223477.1510598400772@Atlassian.JIRA>
In-Reply-To: <JIRA.13110488.1508362392000@Atlassian.JIRA>
References: <JIRA.13110488.1508362392000@Atlassian.JIRA> <JIRA.13110488.1508362392488@jira-lw-us.apache.org>
Subject: [jira] [Issue Comment Deleted] (DRILL-5889) sqlline loses RPC
 connection
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Mon, 13 Nov 2017 18:40:11 -0000


     [ https://issues.apache.org/jira/browse/DRILL-5889?page=3Dcom.atlassia=
n.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
 =20
    Padma, DRILL-5889 is the wrong JIRA (sqlline loses RPC..); I think your=
 JIRA is 5899
   =20
   =20
    Regards,
   =20
    Salim
   =20
    ________________________________
    From: Padma Penumarthy <notifications@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 wor=
k with DrillBuf directly (#1015)
   =20
   =20
    @sachouche<https://github.com/sachouche> @paul-rogers<https://github.co=
m/paul-rogers> can you please review ?
   =20
    =E2=80=94
    You are receiving this because you were mentioned.
    Reply to this email directly, view it on GitHub<https://github.com/apac=
he/drill/pull/1015#issuecomment-341192974>, or mute the thread<https://gith=
ub.com/notifications/unsubscribe-auth/AckoK8UN4uDlGPJGg6fpypIbPxKEOqGKks5sy=
LU4gaJpZM4QJzty>.

)

> 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, dril=
lbit.log
>
>
> Query is:
> {noformat}
> alter session set `planner.memory.max_query_memory_per_node` =3D 10737418=
240;
> 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=3D10.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=3D,code=3D0)
> {noformat}
> From drillbit.log:
> 2017-10-18 14:04:23,044 [UserServer-1] INFO  o.a.drill.exec.rpc.user.User=
Server - RPC connection /10.10.100.190:31010 <--> /10.10.100.190:45776 (use=
r server) timed out.  Timeout was set to 30 seconds. Closing connection.
> Plan is:
> {noformat}
> | 00-00    Screen
> 00-01      Project(EXPR$0=3D[$0], EXPR$1=3D[$1])
> 00-02        UnionExchange
> 01-01          Project(EXPR$0=3D[$2], EXPR$1=3D[$3])
> 01-02            HashAgg(group=3D[{0, 1}], EXPR$0=3D[$SUM0($2)], EXPR$1=
=3D[MAX($3)])
> 01-03              Project(no_nulls_col=3D[$0], nulls_col=3D[$1], EXPR$0=
=3D[$2], EXPR$1=3D[$3])
> 01-04                HashToRandomExchange(dist0=3D[[$0]], dist1=3D[[$1]])
> 02-01                  UnorderedMuxExchange
> 03-01                    Project(no_nulls_col=3D[$0], nulls_col=3D[$1], E=
XPR$0=3D[$2], EXPR$1=3D[$3], E_X_P_R_H_A_S_H_F_I_E_L_D=3D[hash32AsDouble($1=
, hash32AsDouble($0, 1301011))])
> 03-02                      HashAgg(group=3D[{0, 1}], EXPR$0=3D[COUNT()], =
EXPR$1=3D[MAX($2)])
> 03-03                        Scan(groupscan=3D[ParquetGroupScan [entries=
=3D[ReadEntryWithPath [path=3Dmaprfs:///drill/testdata/hash-agg/data1]], se=
lectionRoot=3Dmaprfs:/drill/testdata/hash-agg/data1, numFiles=3D1, usedMeta=
dataFile=3Dfalse, columns=3D[`no_nulls_col`, `nulls_col`, `filename`]]])
> {noformat}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)