From user-return-10676-apmail-ignite-user-archive=ignite.apache.org@ignite.apache.org Mon Mar 27 08:47:55 2017 Return-Path: X-Original-To: apmail-ignite-user-archive@minotaur.apache.org Delivered-To: apmail-ignite-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D0B7619D80 for ; Mon, 27 Mar 2017 08:47:55 +0000 (UTC) Received: (qmail 80709 invoked by uid 500); 27 Mar 2017 08:47:55 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 80653 invoked by uid 500); 27 Mar 2017 08:47:55 -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 80643 invoked by uid 99); 27 Mar 2017 08:47: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; Mon, 27 Mar 2017 08:47: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 31846C1F9B for ; Mon, 27 Mar 2017 08:47:55 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.173 X-Spam-Level: ** X-Spam-Status: No, score=2.173 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_SOFTFAIL=0.972] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id UsT_ym7ywrav for ; Mon, 27 Mar 2017 08:47:54 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 726195FB30 for ; Mon, 27 Mar 2017 08:47:54 +0000 (UTC) Received: from static.162.255.23.37.macminivault.com (unknown [162.255.23.37]) by mbob.nabble.com (Postfix) with ESMTP id 3DDA23FC030D for ; Mon, 27 Mar 2017 01:22:19 -0700 (PDT) Date: Mon, 27 Mar 2017 01:47:52 -0700 (MST) From: ozgurnevres To: user@ignite.apache.org Message-ID: <1490604472659-11457.post@n6.nabble.com> Subject: How can I perform SqlFieldsQuery on DateTime field (binary cache)? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit My query is: var rows = _cache.QueryFields(new SqlFieldsQuery("select productid, recorddate, inventory from product where recorddate > '2016-03-27'")); and I get the exception below: Failed to run map query remotely but this works: var rows = _cache.QueryFields(new SqlFieldsQuery("select productid, recorddate, inventory from product where inventory > 10")); Thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-can-I-perform-SqlFieldsQuery-on-DateTime-field-binary-cache-tp11457.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.