You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Aroop Ganguly <ar...@icloud.com> on 2018/06/18 19:30:29 UTC
Solr Odbc for Parallel Sql integration with Tableau
Hi Everyone
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.
I love the jdbc driver and it works well for many UIs but there are other systems that need an ODBC driver.
Can anyone share any guidance as to how this can be done or has been done by others.
Thanks
Aroop
Re: Solr Odbc for Parallel Sql integration with Tableau
Posted by Erick Erickson <er...@gmail.com>.
Asher:
Please follow the instructions here:
http://lucene.apache.org/solr/community.html#mailing-lists-irc. You
must use the _exact_ same e-mail as you used to subscribe.
If the initial try doesn't work and following the suggestions at the
"problems" link doesn't work for you, let us know. But note you need
to show us the _entire_ return header to allow anyone to diagnose the
problem.
Best,
Erick
On Mon, Jun 18, 2018 at 4:08 PM, Asher Shih <ca...@gmail.com> wrote:
> unsubscribe
>
> On Mon, Jun 18, 2018 at 3:37 PM, Aroop Ganguly <ar...@icloud.com> wrote:
>> 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 ?
>>
>>> On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <ar...@icloud.com> wrote:
>>>
>>>
>>> Hi Everyone
>>>
>>> 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.
>>>
>>> I love the jdbc driver and it works well for many UIs but there are other systems that need an ODBC driver.
>>>
>>> Can anyone share any guidance as to how this can be done or has been done by others.
>>>
>>> Thanks
>>> Aroop
>>
Re: Solr Odbc for Parallel Sql integration with Tableau
Posted by Asher Shih <ca...@gmail.com>.
unsubscribe
On Mon, Jun 18, 2018 at 3:37 PM, Aroop Ganguly <ar...@icloud.com> wrote:
> 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 ?
>
>> On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <ar...@icloud.com> wrote:
>>
>>
>> Hi Everyone
>>
>> 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.
>>
>> I love the jdbc driver and it works well for many UIs but there are other systems that need an ODBC driver.
>>
>> Can anyone share any guidance as to how this can be done or has been done by others.
>>
>> Thanks
>> Aroop
>
Re: Solr Odbc for Parallel Sql integration with Tableau
Posted by Aroop Ganguly <ar...@icloud.com>.
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 <https://github.com/risdenk/solrj-jdbc-testing/blob/master/odbc/README.md> ),
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)
— 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 “limit” otherwise it keeps giving the error about “score”. So I defaulted to the custom query option on Tableau but it failed for the inherent inner-queryness of Tableau as mentioned in 1. :)
— 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 <jo...@gmail.com> wrote:
>
> 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.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Mon, Jun 18, 2018 at 6:37 PM, Aroop Ganguly <ar...@icloud.com>
> wrote:
>
>> 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 ?
>>
>>> On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <ar...@icloud.com>
>> wrote:
>>>
>>>
>>> Hi Everyone
>>>
>>> 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.
>>>
>>> I love the jdbc driver and it works well for many UIs but there are
>> other systems that need an ODBC driver.
>>>
>>> Can anyone share any guidance as to how this can be done or has been
>> done by others.
>>>
>>> Thanks
>>> Aroop
>>
>>
Re: Solr Odbc for Parallel Sql integration with Tableau
Posted by Joel Bernstein <jo...@gmail.com>.
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.
Joel Bernstein
http://joelsolr.blogspot.com/
On Mon, Jun 18, 2018 at 6:37 PM, Aroop Ganguly <ar...@icloud.com>
wrote:
> 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 ?
>
> > On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <ar...@icloud.com>
> wrote:
> >
> >
> > Hi Everyone
> >
> > 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.
> >
> > I love the jdbc driver and it works well for many UIs but there are
> other systems that need an ODBC driver.
> >
> > Can anyone share any guidance as to how this can be done or has been
> done by others.
> >
> > Thanks
> > Aroop
>
>
Re: Solr Odbc for Parallel Sql integration with Tableau
Posted by Aroop Ganguly <ar...@icloud.com>.
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 ?
> On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <ar...@icloud.com> wrote:
>
>
> Hi Everyone
>
> 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.
>
> I love the jdbc driver and it works well for many UIs but there are other systems that need an ODBC driver.
>
> Can anyone share any guidance as to how this can be done or has been done by others.
>
> Thanks
> Aroop