Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AEA70200B13 for ; Wed, 15 Jun 2016 09:50:43 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id AD1BD160A4D; Wed, 15 Jun 2016 07:50:43 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id A53AE160A4C for ; Wed, 15 Jun 2016 09:50:42 +0200 (CEST) Received: (qmail 18675 invoked by uid 500); 15 Jun 2016 07:50:41 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 18665 invoked by uid 99); 15 Jun 2016 07:50:41 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Jun 2016 07:50:41 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 4E75A18050F for ; Wed, 15 Jun 2016 07:50:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.299 X-Spam-Level: * X-Spam-Status: No, score=1.299 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=bontix-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id erG6tNAUz9Bj for ; Wed, 15 Jun 2016 07:50:39 +0000 (UTC) Received: from mail-vk0-f44.google.com (mail-vk0-f44.google.com [209.85.213.44]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 3D3DB5F4E5 for ; Wed, 15 Jun 2016 07:50:38 +0000 (UTC) Received: by mail-vk0-f44.google.com with SMTP id t129so18870467vka.1 for ; Wed, 15 Jun 2016 00:50:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bontix-com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to; bh=pqujhEHYg/TKsDXO3hihx9gC7+AQrBBSoT6DTFxbzF8=; b=s0/i+MhUObSAaMg9I+2VM/wPhkg5bE8+grI9fPgH3ZjTFYtDTqJh82nWMeYrdYH8HC LBbm0eSKku36z3knb6aPKqnu0RCak+VF0xwrD61k99cdu/FzbZHn88qHGxQ0btuu07n4 koLwnnEprXQ6ly5kDpYPnns9cGJI9iPuPh5AnQ9Ays+5bUeskUC+dCVx5WHQkYcWKHqx zlmWXvsVOzd5LhGr8e1U5TkPQKiIpZi94SqU6KZpKYSXDV38mbraA6lO+dWK8W0RBwiy mcjQ55LvlHea6itjjU5t8VElNAJQJ657F43rEAcD/Nk1VG0nKwPLwfCezRdc3juMzpnk 9mMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to; bh=pqujhEHYg/TKsDXO3hihx9gC7+AQrBBSoT6DTFxbzF8=; b=hbEaPS7myHzGOCS2V6OwYvUtJTFX+RIYF5OtcBz89yMac0ShLNn34STxvOzUJKFD/8 T36gOhrQdfzK1XzDmmUvmOiFBp86Qr7JVWn9jzxCd2MppA0Dc3vwlwEXNtaDQ7KdVB1V r2+x6TjjQ6l8LjNNWGluInOFnbEFurLdhuh0xA+L2HdX2Ub3io+VkHDiOuSNztLKV4Jd jIT9gFEx/mN+jQMrBEoZue7hoTMUC9LhSE0Ledr7dZ0WUNERigK/wZhQL2VC4UAMasq1 onEw9VgDLKmZ4nF/RKAAYz/5E04foUY+IqelpTea6k3YLRA2oed8IdsDigzyj5F6p9xX uKKQ== X-Gm-Message-State: ALyK8tIT81kM9H/cedUpMgHSCvgG4+miCrlF0eaUujYLVDPmFoJOs/IRQPnNUKy1OEBlKnAAySVSAwo03LG/Rw== MIME-Version: 1.0 X-Received: by 10.159.55.193 with SMTP id q59mr10593416uaq.43.1465977037069; Wed, 15 Jun 2016 00:50:37 -0700 (PDT) Received: by 10.176.1.212 with HTTP; Wed, 15 Jun 2016 00:50:37 -0700 (PDT) X-Originating-IP: [148.0.21.163] Date: Wed, 15 Jun 2016 03:50:37 -0400 Message-ID: Subject: SQL queries with BinaryObject From: Eduardo Julian To: user@ignite.apache.org Content-Type: multipart/alternative; boundary=94eb2c04c8e68b369b05354c6082 archived-at: Wed, 15 Jun 2016 07:50:43 -0000 --94eb2c04c8e68b369b05354c6082 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, everyone. I found out about the BinaryObject functionality for storing and manipulating data on Ignite ( http://apacheignite.gridgain.org/docs/binary-marshaller). I decided to adopt it, in order to reduce the hassle during data-migrations= . However, when I try to do SQL queries on a cache that contains data created by building BinaryObjects, I get errors saying that the columns I'm querying are missing. For example: Caused by: org.h2.jdbc.JdbcSQLException: Column "IS_ACTIVE" not found; SQL statement: SELECT "Cache".BinaryObject._key, "Cache".BinaryObject._val FROM "Cache".BinaryObject WHERE is_active =3D true I imagined that it was because I had migrated from using Java classes, to directly using BinaryObject, so I set up a QueryEntity with key java.lang.String, and value org.apache.ignite.binary.BinaryObject, and added query-fields for all of the fields I'll be using (including is_active), and yet, I still get the same error. I looked up on Google, but I've only found examples of ScanQuery with BinaryObject, but no examples of SqlQuery with BinaryObject ( https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apa= che/ignite/examples/datagrid/CacheQueryExample.java ). So I want to ask if it's at all possible to do SQL queries with BinaryObject, and if so, what might I be missing. Oh, and I forgot to mention that I'm using setStoreKeepBinary and withKeepBinary, so I don't think the problem might be with that. Thanks in advance for the help! --=20 Eduardo Julian * Chief Science Officer* Mobile.1.809.330.4184 Skype. eejp1991 www.bontix.com This electronic mail and its attachments may contain confidential or priviledged information intended only for the address and may be protected by law; they should not be distributed, used or copied without authorization. If you have received this email in error,please notify immediately at 1(809) 330-4184 or send an email to our address: eduardoejp@bontix.com the sender and delete this message and its attachments. As emails may be altered, Bontix is not liable for messages that have been modified, changed or falsified. Thank you Este correo electr=C3=B3nico y sus archivos adjuntos pueden contener inform= aci=C3=B3n confidencial o privilegiada destinado =C3=BAnicamente para la direcci=C3=B3= n y puede ser protegido por la ley y no deben ser distribuidos, utilizados o copiados sin autorizaci=C3=B3n. Si usted ha recibido este mensaje por error, por fav= or notifique inmediatamente al 1(809) 330-4184 o env=C3=ADe un correo electr= =C3=B3nico a nuestra direcci=C3=B3n: eduardoejp@bontix.com al remitente = y borre este mensaje y sus anexos. Como correos electr=C3=B3nicos pueden ser alterado, Bontix no se hace responsable de los mensajes que se han modificado, cambiado o falsificados. Gracias --94eb2c04c8e68b369b05354c6082 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi, everyone.

I foun= d out about the BinaryObject functionality for storing and manipulating dat= a on Ignite (http://apacheignite.gridgain.org/docs/binary-marsha= ller).

I decided to adopt it, in order to reduce the hassle during = data-migrations.

However, when I try to do SQL queries on a cache that= contains data created by building BinaryObjects, I get errors saying that = the columns I'm querying are missing.

For example:
Caused by: org.h2.jdbc.JdbcSQLException: Column = "IS_ACTIVE" not found; SQL statement:
SELECT "Cach= e".BinaryObject._key, "Cache".BinaryObject._val FROM "C= ache".BinaryObject WHERE=C2=A0is_active =3D true

<= div>I imagined that it was because I had migrated from using Java classes, = to directly using BinaryObject, so I set up a QueryEntity with key=C2=A0jav= a.lang.String, and value=C2=A0org.apache.ignite.binary.BinaryObject, and ad= ded query-fields for all of the fields I'll be using (including is_acti= ve), and yet, I still get the same error.

I looked= up on Google, but I've only found examples of ScanQuery with BinaryObj= ect, but no examples of SqlQuery with BinaryObject (https://github.c= om/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examp= les/datagrid/CacheQueryExample.java).

So I wan= t to ask if it's at all possible to do SQL queries with BinaryObject, a= nd if so, what might I be missing.

Oh, and I forgo= t to mention that I'm using=C2=A0setStoreKeepBinary and=C2=A0withKeepBi= nary, so I don't think the problem might be with that.

Thanks in advance for the help!

--
<= div class=3D"gmail_signature" data-smartmail=3D"gmail_signature">
=C2=A0 =C2=A0=C2=A0=C2=A0
=C2=A0 =C2=A0=C2=A0Eduardo J= ulian
=C2=A0 =C2=A0 Chief Science Officer
=C2=A0 =C2= =A0 Mobile.1.809.3= 30.4184
=C2=A0 =C2=A0 Skype. =C2=A0eejp1991
=C2=A0 =C2=A0=C2=A0 =C2=A0 =C2=A0www.bontix.com


=C2=A0 =C2= =A0 =C2=A0
=C2=A0
T= his=C2=A0electronic mail=C2=A0=C2=A0and its attachments may contain confide= ntial or priviledged information=C2=A0intended only for the address and=C2= =A0may be protected by law; they should not be distributed, used or copied = without authorization. If you have received this email in error,please noti= fy immediately at=C2=A01(809) 330-4184= =C2=A0or send an email to our address: =C2=A0eduardoejp@bontix.com=C2=A0the sender and delete this message and its attachmen= ts. As emails may=C2=A0be=C2=A0altered, Bontix is not liable for messages that have been modified, changed or = falsified. Thank you
<= br>Este correo electr=C3=B3nico y sus ar= chivos adjuntos pueden contener informaci=C3=B3n confidencial o privilegiad= a destinado =C3=BAnicamente para la direcci=C3=B3n y puede ser protegido po= r la ley y no deben ser distribuidos, utilizados o copiados sin autorizaci= =C3=B3n. Si usted ha recibido este mensaje por error, por favor notifique i= nmediatamente al=C2=A01(809) 330-4184=C2=A0o env=C3=ADe un correo electr=C3=B3nico a nuestra d= irecci=C3=B3n:=C2=A0eduardoejp@bontix.com= =C2=A0al remitente y borre este mensaje = y sus anexos. Como correos electr=C3=B3nicos pueden ser alterado, Bontix no= se hace responsable de los mensajes que se han modificado, cambiado o fals= ificados. Gracias

--94eb2c04c8e68b369b05354c6082--