From user-return-63688-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Wed Apr 17 16:03:10 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id B6CC0180672 for ; Wed, 17 Apr 2019 18:03:09 +0200 (CEST) Received: (qmail 89289 invoked by uid 500); 17 Apr 2019 16:02:55 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 89279 invoked by uid 99); 17 Apr 2019 16:02:55 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Apr 2019 16:02:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 4E396C8A62 for ; Wed, 17 Apr 2019 16:02:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.8 X-Spam-Level: * X-Spam-Status: No, score=1.8 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id YChxdCNyxHP9 for ; Wed, 17 Apr 2019 16:02:51 +0000 (UTC) Received: from sonic317-32.consmr.mail.ne1.yahoo.com (sonic317-32.consmr.mail.ne1.yahoo.com [66.163.184.43]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id F22C35FBBA for ; Wed, 17 Apr 2019 16:02:50 +0000 (UTC) X-YMail-OSG: JAgxhukVM1nfBny0zgha5Cz6aoHg_EtFQh5xSNKcsAtNUDc1YFpaA9PvIagfdU6 4KABzQ0oT4vNiWyCsnUWJUsMvDZ8gg3fxy1cBFAAfS1lrwImmTtWn.aJlXmAzJgo6pEE6stdn9Vt od8L1FAYdbrss2uW9G7aY9vFVPkLNFsSPNikXT59laMPJOfuHWffK0BV0rySBHDM2QGc2VpitWNw iW.7JkPH3B3Ezpe7xkunphnd8emsXcwSRB5hpELF7rNuk4IQj8iv9GDGKjNQwF8b0hC.rIyyGRlb Q0HzyKPyG.SDpH3YSpebnyClHGZhd2PX5KkmETKMWZ_eLYYchMc5kYFQ3nGlHMq3IzjhjfHrFGDZ FSKUe6CUtd.rUEnWVDwZDbCI73nHge.eAxZZgTAKzztTM.UJ8evB6n68lXerGLe6l0qDydlXqgiR OwQrDOXcPh5O.LcuZrqeHQb2RrUwlP22UF97Ta_sAlhJsfRNRw9kQ9HdDrHreMVW74MY4hM9uXFj kgnbAMk_WJNm0CA.CUB1UWChaam..taV14y_lbyijPJBvGyRhoXT41pKsQJLY2PngopmxHG520IX Mote3VXwkhEz6AzQ5_m1MHuwRM8qpVp2ZJRS3Di3.F9i8ESraBsBPXjNxcIarSgmHpbXJ0EKT8hW FWl07RE5ULi..G1qEcF64kt93k.VdFKohjnBcXqUZHCV9bNcV7iw613fr_raQGsTiDaEniLlvVFt okHKlDQmm.chuxn7GcSvjti33JM3grlKBV_Say7UknAfQwAngFnZnJoAl1KL3sqQc.bvnyUbMyG3 dIRcBHkfiIVZIz12._104tHlN_YDji60CeslZQyi35wmyq1yugQpuXYGQGUJ05nTddASCvqDe.bg ZEOTn9mTbHUhVoCu9LSaeQnfhybyWGRxM0bgqIJVEQ7vYzqmWjmwcj_RqEkGBgrTu1jhdczwO9t9 kKEj8XeB.EuHB7SaLbyHA9BnZ_AS7ejho4NkexQPZWhq5f_l01aXiPk_bKgDd4amBbSs3CtpuzqJ ejfs2TTNjS3MsaDx5LxHGU8yInqSvfY4WY.Zhj96kHm_cIhVDhO1mdIV1cF0E.AW1C9HKvll2gUx .SpGU Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Wed, 17 Apr 2019 16:02:43 +0000 Date: Wed, 17 Apr 2019 16:02:41 +0000 (UTC) From: Krishnanand Khambadkone To: user@cassandra.apache.org Message-ID: <2053189060.948487.1555516961266@mail.yahoo.com> In-Reply-To: References: <1645552749.744796.1555481531170.ref@mail.yahoo.com> <1645552749.744796.1555481531170@mail.yahoo.com> Subject: Re: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_948484_1537316385.1555516961264" X-Mailer: WebService/1.1.13490 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36 ------=_Part_948484_1537316385.1555516961264 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you gentlemen for all your responses.=C2=A0 =C2=A0Reading through th= em I was able to resolve the issue by doing the following, a.=C2=A0 Creating an index on one of the query fieldsb.=C2=A0 Setting page = size to 200 Now the query runs instantaneously. On Wednesday, April 17, 2019, 7:12:21 AM PDT, Shaurya Gupta wrote: =20 =20 As already mentioned in this thread, ALLOW FILTERING should be avoided in = any scenario. It seems to work in test scenarios, but as soon as the data increases to ce= rtain size(a few MBs), it starts failing miserably and fails almost always. ThanksShaurya On Wed, Apr 17, 2019, 6:44 PM Durity, Sean R = wrote: If you are just trying to get a sense of the data, you could try adding a l= imit clause to limit the amount of results and hopefully beat the timeout. However, ALLOW FILTERING really means "ALLOW ME TO DESTROY MY APPLICATION A= ND CLUSTER." It means the data model does not support the query and will no= t scale -- in this case, not even on one node. Design a new table to suppor= t the query with a proper partition key (and any clustering keys). Sean Durity -----Original Message----- From: Dinesh Joshi Sent: Wednesday, April 17, 2019 2:39 AM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.Read= TimeoutException: More info with detailed explanation: https://urldefense.proofpoint.com/v2/u= rl?u=3Dhttps-3A__www.instaclustr.com_apache-2Dcassandra-2Dscalability-2Dall= ow-2Dfiltering-2Dpartition-2Dkeys_&d=3DDwIFAg&c=3DMtgQEAMQGqekjTjiAhkudQ&r= =3DaC_gxC6z_4f9GLlbWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=3DHXMAEKpR-N5O0-U5rclUrsVk= 5QPmSUQYels4VTOVZWI&s=3DLHl3QGlLsAdszkJ6XK3O2w7_EcSyRyaSFjBgEcK9nfo&e=3D Dinesh > On Apr 16, 2019, at 11:24 PM, Mahesh Daksha wrote: > > Hi, > > how much data you are trying to read in the single query? is it large in = size or normal text data. > Looking at the exception it seems the node is unable to deliver data with= in stipulated time. I have faced similar issue with the response data in hu= ge in size (some binary data). But it was solved as we spread the data acro= ss multiple rows. > > Thanks, > Mahesh Daksha > > On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone wrote: > Hi,=C2=A0 I have a single instance cassandra server.=C2=A0 I am trying to= execute a query with ALLOW FILTERING option.=C2=A0 When I run this same qu= ery from cqlsh it runs fine but when I try to execute the query through the= java driver it throws this exception.=C2=A0 I have increased all the timeo= uts in cassandra.yaml file and also included the read timeout option in the= SimpleStetement query I am running.=C2=A0 Any idea how I can fix this issu= e. > Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cass= andra timeout during read query at consistency LOCAL_ONE (1 responses were = required but only 0 replica responded) > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org For additional commands, e-mail: user-help@cassandra.apache.org ________________________________ The information in this Internet Email is confidential and may be legally p= rivileged. It is intended solely for the addressee. Access to this Email by= anyone else is unauthorized. If you are not the intended recipient, any di= sclosure, copying, distribution or any action taken or omitted to be taken = in reliance on it, is prohibited and may be unlawful. When addressed to our= clients any opinions or advice contained in this Email are subject to the = terms and conditions expressed in any applicable governing The Home Depot t= erms of business or client engagement letter. The Home Depot disclaims all = responsibility and liability for the accuracy and content of this attachmen= t and for any damages or losses arising from any inaccuracies, errors, viru= ses, e.g., worms, trojan horses, etc., or other items of a destructive natu= re, which may be contained in this attachment and shall not be liable for d= irect, indirect, consequential or special damages in connection with this e= -mail message or its attachment. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org For additional commands, e-mail: user-help@cassandra.apache.org =20 ------=_Part_948484_1537316385.1555516961264 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you gentlemen for all your responses.   Readin= g through them I was able to resolve the issue by doing the following,

a.  Creating an index on one of the query fields<= /div>
b.  Setting page size to 200

Now th= e query runs instantaneously.

=20
=20
On Wednesday, April 17, 2019, 7:12:21 AM PDT, Shaurya G= upta <shaurya.nsit@gmail.com> wrote:


As= already mentioned in this thread, ALLOW FILTERING should be avoided in any= scenario.

It seems to work in test scena= rios, but as soon as the data increases to certain size(a few MBs), it star= ts failing miserably and fails almost always.

=
Thanks
Shaurya


On Wed, Apr 17,= 2019, 6:44 PM Durity, Sean R <SEAN_R_DURITY@homed= epot.com> wrote:
If you are just trying to get a sense of the d= ata, you could try adding a limit clause to limit the amount of results and= hopefully beat the timeout.

However, ALLOW FILTERING really means "ALLOW ME TO DESTROY MY APPLICATION A= ND CLUSTER." It means the data model does not support the query and will no= t scale -- in this case, not even on one node. Design a new table to suppor= t the query with a proper partition key (and any clustering keys).


Sean Durity


-----Original Message-----
From: Dinesh Joshi <djoshi3@icloud.com.INVALID>
Sent: Wednesday, April 17, 2019 2:39 AM
To: user@cassandra.apache.org
Subject: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.Read= TimeoutException:

More info with detailed explanation: https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__www.instaclu= str.com_apache-2Dcassandra-2Dscalability-2Dallow-2Dfiltering-2Dpartition-2D= keys_&d=3DDwIFAg&c=3DMtgQEAMQGqekjTjiAhkudQ&r=3DaC_gxC6z_4f9GLl= bWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=3DHXMAEKpR-N5O0-U5rclUrsVk5QPmSUQYels4VT= OVZWI&s=3DLHl3QGlLsAdszkJ6XK3O2w7_EcSyRyaSFjBgEcK9nfo&e=3D

Dinesh

> On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <dakshme@gm= ail.com> wrote:
>
> Hi,
>
> how much data you are trying to read in the single query? is it large = in size or normal text data.
> Looking at the exception it seems the node is unable to deliver data w= ithin stipulated time. I have faced similar issue with the response data in= huge in size (some binary data). But it was solved as we spread the data a= cross multiple rows.
>
> Thanks,
> Mahesh Daksha
>
> On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kkhambadkone@yahoo.com.invalid> wrote:
> Hi,  I have a single instance cassandra server.  I am trying= to execute a query with ALLOW FILTERING option.  When I run this same= query from cqlsh it runs fine but when I try to execute the query through = the java driver it throws this exception.  I have increased all the ti= meouts in cassandra.yaml file and also included the read timeout option in = the SimpleStetement query I am running.  Any idea how I can fix this i= ssue.
> Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: C= assandra timeout during read query at consistency LOCAL_ONE (1 responses we= re required but only 0 replica responded)
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ca= ssandra.apache.org
For additional commands, e-mail: user-help@cassand= ra.apache.org


________________________________

The information in this Internet Email is confidential and may be legally p= rivileged. It is intended solely for the addressee. Access to this Email by= anyone else is unauthorized. If you are not the intended recipient, any di= sclosure, copying, distribution or any action taken or omitted to be taken = in reliance on it, is prohibited and may be unlawful. When addressed to our= clients any opinions or advice contained in this Email are subject to the = terms and conditions expressed in any applicable governing The Home Depot t= erms of business or client engagement letter. The Home Depot disclaims all = responsibility and liability for the accuracy and content of this attachmen= t and for any damages or losses arising from any inaccuracies, errors, viru= ses, e.g., worms, trojan horses, etc., or other items of a destructive natu= re, which may be contained in this attachment and shall not be liable for d= irect, indirect, consequential or special damages in connection with this e= -mail message or its attachment.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ca= ssandra.apache.org
For additional commands, e-mail: user-help@cassand= ra.apache.org

------=_Part_948484_1537316385.1555516961264--