RE: Teiid with Solr - using any other engine except the SolrDefaultQueryEngine

[Mark Horninger]

Thanks for the response, Alex.  

I am trying to accomplish a Federated search of SQL Server and Solr.  I guess I 
should have given more detail on this.

The overall plan is to do the following:
1. SSIS ETL data from multiple sources into SQL Server
2. SSIS call to update Solr Indexing.
3. SQL standard "=" matching when possible to reduce the candidate data set.
4. Dismax match based on a rule set Joining SQL Server candidate dataset 
against Solr indexing set using a join operator.
5. Cache possible matches in SQL Server for a given record in order for a human 
to disposition them.

From what I read, Carrot is great for Solr clustering, but once you get into 
RDBMS, you're out of luck.


 
-Original Message-
From: Alexandre Rafalovitch [mailto:arafa...@gmail.com] 
Sent: Thursday, December 31, 2015 12:44 AM
To: solr-user <solr-user@lucene.apache.org>
Subject: Re: Teiid with Solr - using any other engine except the 
SolrDefaultQueryEngine

Are you trying to do federated search? What about carrot? Not the one that 
ships with Solr, the parent project.

Regards,
   Alex
On 31 Dec 2015 12:21 am, "Mark Horninger" <mhornin...@grayhairsoftware.com>
wrote:

> I have gotten Teiid and Solr wired up, but it seems like the only way 
> to query is with the default Solr Query Engine, and nothing else.  In 
> asking Dr. Google, this is a data black hole.  The more I look at it, 
> the more I think I'm going to end up having to write a custom 
> translator.  Is there anyone else out there who has had this 
> challenge, and if so, how did you overcome it?
>
> Thanks In Advance!
>
> -Mark H.
>
>
> [GrayHair]
> GHS Confidentiality Notice
>
> This e-mail message, including any attachments, is for the sole use of 
> the intended recipient(s) and may contain confidential and privileged 
> information. Any unauthorized review, use, disclosure or distribution 
> of this information is prohibited, and may be punishable by law. If 
> this was sent to you in error, please notify the sender by reply 
> e-mail and destroy all copies of the original message.
>
> GrayHair Software <http://www.grayhairSoftware.com>
>
>

Teiid with Solr - using any other engine except the SolrDefaultQueryEngine

[Mark Horninger]

I have gotten Teiid and Solr wired up, but it seems like the only way to query 
is with the default Solr Query Engine, and nothing else.  In asking Dr. Google, 
this is a data black hole.  The more I look at it, the more I think I'm going 
to end up having to write a custom translator.  Is there anyone else out there 
who has had this challenge, and if so, how did you overcome it?

Thanks In Advance!

-Mark H.


[GrayHair]
GHS Confidentiality Notice

This e-mail message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution of this information is 
prohibited, and may be punishable by law. If this was sent to you in error, 
please notify the sender by reply e-mail and destroy all copies of the original 
message.

GrayHair Software 

RE: Testing Solr configuration, schema, and other fields

[Mark Horninger]

Daniel,


Sounds almost like you're reinventing the wheel.  Could you possibly automate 
this through puppet or Chef?  With a VDI environment, then all you would need 
to do is build a new VM Node based on original setup.  Then you can just roll 
out the node as one of the zk nodes.

Just a thought on that subject.

v/r,

-Mark H.

-Original Message-
From: Davis, Daniel (NIH/NLM) [C] [mailto:daniel.da...@nih.gov]
Sent: Wednesday, December 30, 2015 3:10 PM
To: solr-user@lucene.apache.org
Subject: Testing Solr configuration, schema, and other fields

At my organization, I want to create a tool that allows users to keep a solr 
configuration as a Git repository.   Then, I want my Continuous Integration 
environment to take some branch of the git repository and "publish" it into 
ZooKeeper/SolrCloud.

Working on my own, it is only a very small pain to note foolish errors I've 
made, fix them, and restart.However, I want my users to be able to edit 
their own Solr schema and config *most* of the time, at least on development 
servers.They will not have command-line access to these servers, and I want 
to avoid endless restarts.

I'm not interested in fighting to maintain such a useless thing as a DTD/XSD 
without community support; what I really want to know is whether Solr will 
start and can index some sample documents.   I'm wondering whether I might be 
able to build a tool to fire up an EmbeddedSolrServer and capture error 
messages/exceptions in a reasonable way. This tool could then be run by my 
users before they commit to git, and then again by the CI server before it 
"publishes" the configuration to ZooKeeper/SolrCloud.

Any suggestions?

Dan Davis, Systems/Applications Architect (Contractor), Office of Computer and 
Communications Systems, National Library of Medicine, NIH

[GrayHair]
GHS Confidentiality Notice

This e-mail message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution of this information is 
prohibited, and may be punishable by law. If this was sent to you in error, 
please notify the sender by reply e-mail and destroy all copies of the original 
message.

GrayHair Software 

RE: HELP!!!!

[Mark Horninger]

It depends on what you want to do with it.  There are tons of ways to skin the 
proverbial cat, and it all depends on what you want to do with it.  You really 
need to start by learning the very basics of Solr, and then move forward from 
there.  Once you understand Solr, you must also understand your data at least 
in a limited fashion.  You will need to use that understanding in order to make 
the correct decisions around your schema design, as well as the correct query 
engine.

Only then should you attempt to write a client application for Solr, otherwise 
you are guaranteed failure.

--Mark H.

-Original Message-
From: Alfredo Vega Ramírez [mailto:alfredo.v...@vertice.cu]
Sent: Friday, November 13, 2015 11:28 AM
To: solr-user@lucene.apache.org
Subject: Re: HELP

Greetings, I'm new using Solr. I have problem to create a client application. 
As I do, if I need to use frameworks, or Solr has a way to create client 
applications.

[GrayHair]
GHS Confidentiality Notice

This e-mail message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution of this information is 
prohibited, and may be punishable by law. If this was sent to you in error, 
please notify the sender by reply e-mail and destroy all copies of the original 
message.

GrayHair Software 

RE: Same query fails in SolrJ, but works in the browser.

[Mark Horninger]

I just found that, too.  It's not the exact same query if you misspell your 
parameter.   Oh, the benefits of a second look at things.

Thanks Mikhail.

-Original Message-
From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] 
Sent: Tuesday, August 04, 2015 9:37 AM
To: solr-user solr-user@lucene.apache.org
Subject: Re: Same query fails in SolrJ, but works in the browser.

On Tue, Aug 4, 2015 at 4:24 PM, Mark Horninger  
mhornin...@grayhairsoftware.com wrote:

 Hi Solr Users,

 I am running into a problem where a more complex dismax query I am 
 trying to run works with no problem in the browser.  The query is as follows:
 http://
 solr-server:8983/solr/core/select?q=FreddefType=dismaxsort=date1
 %20descqf=Line1^2%20Line2%20Line3%20Line4%20Line5%20Line6%20Line7^2%2
 0Line8^2%20Line9%20Line10^1

 Like I said, I can run this query without problem in the browser, 
 however there is a problem trying to run the exact same query within 
 SolrJ, I get a
 400 error back, with the text undefined field name

 The code to generate the query is as follows:
 q: Fred
 defType: dismax
 sort: date1 desc
 qf: Line1^2 Line2 Line3 Line4 Line5 Line6 Line7^2 Line8^2 Line9 
 Line10^1

 String result = null;
 SolrClient client = null;
 QueryResponse response = null;
 try {
   client = new HttpSolrClient(
   http://solr-server:8983/solr/core);
   SolrQuery parms = new SolrQuery();
   parms.set(q, q);
   parms.set(defTpe, defType);

defTpe ???


   parms.set(sort, sort);
   parms.set(qf, qf);
   parms.set(rows, rows);
   response = client.query(parms);
 } catch (SolrServerException e) {
   e.printStackTrace();
 } catch (IOException e) {
   e.printStackTrace();
 } finally {
   if (client != null) {
 try {
   client.close();
 } catch (IOException e) {
   e.printStackTrace();
 }
   }
 }
 if(response != null) {
   result = response.toString();
 }
 return result;
   }

 For whatever reason, this is not working.  If anyone could shed some 
 light on the issue I would be extremely grateful.

 Thanks,

 -Mark
 [GrayHair]
 GHS Confidentiality Notice

 This e-mail message, including any attachments, is for the sole use of 
 the intended recipient(s) and may contain confidential and privileged 
 information. Any unauthorized review, use, disclosure or distribution 
 of this information is prohibited, and may be punishable by law. If 
 this was sent to you in error, please notify the sender by reply 
 e-mail and destroy all copies of the original message.

 GrayHair Software http://www.grayhairSoftware.com




--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics

http://www.griddynamics.com
mkhlud...@griddynamics.com

Same query fails in SolrJ, but works in the browser.

[Mark Horninger]

Hi Solr Users,

I am running into a problem where a more complex dismax query I am trying to 
run works with no problem in the browser.  The query is as follows:
http://solr-server:8983/solr/core/select?q=FreddefType=dismaxsort=date1%20descqf=Line1^2%20Line2%20Line3%20Line4%20Line5%20Line6%20Line7^2%20Line8^2%20Line9%20Line10^1

Like I said, I can run this query without problem in the browser, however there 
is a problem trying to run the exact same query within SolrJ, I get a 400 error 
back, with the text undefined field name

The code to generate the query is as follows:
q: Fred
defType: dismax
sort: date1 desc
qf: Line1^2 Line2 Line3 Line4 Line5 Line6 Line7^2 Line8^2 Line9 Line10^1

String result = null;
SolrClient client = null;
QueryResponse response = null;
try {
  client = new HttpSolrClient(
  http://solr-server:8983/solr/core);
  SolrQuery parms = new SolrQuery();
  parms.set(q, q);
  parms.set(defTpe, defType);
  parms.set(sort, sort);
  parms.set(qf, qf);
  parms.set(rows, rows);
  response = client.query(parms);
} catch (SolrServerException e) {
  e.printStackTrace();
} catch (IOException e) {
  e.printStackTrace();
} finally {
  if (client != null) {
try {
  client.close();
} catch (IOException e) {
  e.printStackTrace();
}
  }
}
if(response != null) {
  result = response.toString();
}
return result;
  }

For whatever reason, this is not working.  If anyone could shed some light on 
the issue I would be extremely grateful.

Thanks,

-Mark
[GrayHair]
GHS Confidentiality Notice

This e-mail message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution of this information is 
prohibited, and may be punishable by law. If this was sent to you in error, 
please notify the sender by reply e-mail and destroy all copies of the original 
message.

GrayHair Software http://www.grayhairSoftware.com