From solr-user-return-141915-archive-asf-public=cust-asf.ponee.io@lucene.apache.org Tue Jun 19 08:14:41 2018 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 [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id E9646180634 for ; Tue, 19 Jun 2018 08:14:40 +0200 (CEST) Received: (qmail 1233 invoked by uid 500); 19 Jun 2018 06:14:39 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 1219 invoked by uid 99); 19 Jun 2018 06:14:38 -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; Tue, 19 Jun 2018 06:14:38 +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 E7182C07FB for ; Tue, 19 Jun 2018 06:14:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.189 X-Spam-Level: ** X-Spam-Status: No, score=2.189 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, KAM_LIVE=1, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=icloud.com 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 v2v28_Hl63ty for ; Tue, 19 Jun 2018 06:14:35 +0000 (UTC) Received: from mr26p50im-ztdg04121101.me.com (mr26p50im-ztdg04121101.me.com [17.120.69.158]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 7BDCC5F42F for ; Tue, 19 Jun 2018 06:14:35 +0000 (UTC) Received: from process-dkim-sign-daemon.mr26p50im-ztdg04121101.me.com by mr26p50im-ztdg04121101.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) id <0PAK00C003OOES00@mr26p50im-ztdg04121101.me.com> for solr-user@lucene.apache.org; Tue, 19 Jun 2018 06:14:34 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=04042017; t=1529388874; bh=hFhxFx2/B5lanxA/AmnTyYx5uVsJA3X1ROUxkVVuDPM=; h=From:Content-type:MIME-version:Subject:Date:To:Message-id; b=XUnPTO8HC3plkf0OQXYmPVLvMwFjMsy7hsBeliC9l65xIBZcFBRg2ciLKHghs97HB S8OMQPOpxBNakLAu+0Hn2J3QY2s6qqFjX+/aWydgQ/oULt9FAzSNGzRc/lPg8KxX9k yC4+TBwFRFKkyKYOKdVoY76EVJ9qzVh1DWAi2JJ8IQt1zl4XJYbm7bnYkr7G+3idMa W1Wpx0WKfD8XIsv3dM60p3LCVmPJqZ7lsnr4Bgc08vP1duo/IDqF4sxwCOukl7HbMK 95njXcPcTktXLSxzrnWeQ8IolYo0ThLy+mSssC4ut1X0UPFqienOyFUQFpzeVvM9VU lhttjfI06p16A== Received: from icloud.com ([127.0.0.1]) by mr26p50im-ztdg04121101.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) with ESMTPSA id <0PAK00OTR407JW10@mr26p50im-ztdg04121101.me.com> for solr-user@lucene.apache.org; Tue, 19 Jun 2018 06:14:34 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-06-19_02:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 clxscore=1015 suspectscore=1 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1707230000 definitions=main-1806190072 From: Aroop Ganguly Content-type: multipart/alternative; boundary="Apple-Mail=_013504F7-C193-474B-9B6F-DB7D4CD098E7" MIME-version: 1.0 (Mac OS X Mail 11.4 \(3445.8.2\)) Subject: Re: Solr Odbc for Parallel Sql integration with Tableau Date: Mon, 18 Jun 2018 23:14:29 -0700 References: To: solr-user@lucene.apache.org In-reply-to: Message-id: X-Mailer: Apple Mail (2.3445.8.2) --Apple-Mail=_013504F7-C193-474B-9B6F-DB7D4CD098E7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Joel Yes I was able to make the ODBC bridge work very easily (using steps = mentioned here = https://github.com/risdenk/solrj-jdbc-testing/blob/master/odbc/README.md = = ),=20 But the actual Tableau integration has not been fruitful yet due to 2 = reasons: 1. Tableau inherently writes inner queries : select a as A, b as B from = (select * from c) =E2=80=94 this fails immediately, as parallel sql in my experience = does not like inner queries. 2. The default Tableau view which is awesome to drag and drop the entire = table does not work for parallel sql as we need to specify a =E2=80=9Climi= t=E2=80=9D otherwise it keeps giving the error about =E2=80=9Cscore=E2=80=9D= . So I defaulted to the custom query option on Tableau but it failed for = the inherent inner-queryness of Tableau as mentioned in 1. :)=20 =E2=80=94 I will keep at it tomorrow and maybe I will be able to figure = a way out. > On Jun 18, 2018, at 7:55 PM, Joel Bernstein = wrote: >=20 > That's interesting that you were able to setup OpenLink. At Alfresco = we've > done quite a bit of work on the Solr's JDBC driver to integrate it = with the > Alfresco repository, which uses Solr. But we haven't yet tackled the = ODBC > setup. That will come very soon. To really take advantage of Tableau's > capabilities we will need to add joins to Solr's parallel SQL. Solr = already > uses Apache Calcite, which has a join optimizer, so mainly this would > involve hooking up the various Streaming Expression joins. >=20 > Joel Bernstein > http://joelsolr.blogspot.com/ >=20 > On Mon, Jun 18, 2018 at 6:37 PM, Aroop Ganguly = > wrote: >=20 >> Ok I was able to setup the odic bridge (using OpenLink) and I see the >> collections popping up in Tableau too. >> But I am unable to actually get data flowing into Tableau reports = because, >> Tableau keeps creating inner queries and Solr seems to hate inner = queries. >> Is there a way to do inner queries in Solr Parallel Sql ? >>=20 >>> On Jun 18, 2018, at 12:30 PM, Aroop Ganguly = >> wrote: >>>=20 >>>=20 >>> Hi Everyone >>>=20 >>> I am not sure if something has been done on this yet, though I did = see a >> JIRA with links to the parallel sql documentation, but I do not think = that >> answers the question. >>>=20 >>> I love the jdbc driver and it works well for many UIs but there are >> other systems that need an ODBC driver. >>>=20 >>> Can anyone share any guidance as to how this can be done or has been >> done by others. >>>=20 >>> Thanks >>> Aroop >>=20 >>=20 --Apple-Mail=_013504F7-C193-474B-9B6F-DB7D4CD098E7--