[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Michael Suzuki (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15961384#comment-15961384
 ] 

Michael Suzuki commented on SOLR-8138:
--

[~risdenk], I have updated the ui to handle empty stmt. This is now part of the 
pull request, thanks for the feedback.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch, SOLR-8138.patch, SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Michael Suzuki (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15959710#comment-15959710
 ] 

Michael Suzuki commented on SOLR-8138:
--

Good catch, i havent tried sending and empty string. I will amend it to pass it 
as an empty string.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch, SOLR-8138.patch, SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Kevin Risden (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15959245#comment-15959245
 ] 

Kevin Risden commented on SOLR-8138:


So one thing I noticed while trying this out, is that if you just hit execute 
without filling in the box this error message is printed:

{quote}
Failed to execute sqlQuery 'undefined' against JDBC connection 
'jdbc:calcitesolr:'. Error while executing SQL "undefined": parse failed: 
Non-query expression encountered in illegal context
{quote}

[~michaelsuzuki] - I'm not sure the UI is doing the right thing here? I think 
the "undefined" is coming from the UI to the backend?

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch, SOLR-8138.patch, SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15955286#comment-15955286
 ] 

ASF GitHub Bot commented on SOLR-8138:
--

GitHub user michaelsuzukisagi opened a pull request:

https://github.com/apache/lucene-solr/pull/180

SOLR-8138, added new SQL Qury UI.



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/michaelsuzukisagi/lucene-solr master

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/lucene-solr/pull/180.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #180


commit 11514b16b292f2bc374134492a00425ee54181c7
Author: Michael Suzuki 
Date:   2017-04-04T15:46:22Z

SOLR-8138, added new sql qury ui.




> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch, SOLR-8138.patch, SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Joel Bernstein (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15954310#comment-15954310
 ] 

Joel Bernstein commented on SOLR-8138:
--

I applied the patch to master. It applied cleanly and the queries are showing 
in the logs, but the grid isn't appearing with the results.

[~michaelsuzuki], I think you'll to apply the patch to master to see if it's 
working for you.


> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch, SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Michael Suzuki (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15949587#comment-15949587
 ] 

Michael Suzuki commented on SOLR-8138:
--

Good point [~upayavira] , I have reverted it back to its original response.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Upayavira (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15947774#comment-15947774
 ] 

Upayavira commented on SOLR-8138:
-

Is the isbn field multivalued? I think it becomes an array when it is. It is 
important to be able to handle that situation, even if you have to tidy up the 
data in JS afterwards

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Michael Suzuki (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15947675#comment-15947675
 ] 

Michael Suzuki commented on SOLR-8138:
--

I have made the changes on the javascript side to format the data so that we do 
not return field values as an array.
So far its looking good but it would be better if received the data as above 
comment.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Michael Suzuki (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15947161#comment-15947161
 ] 

Michael Suzuki commented on SOLR-8138:
--

I have almost completed my patch which includes a UI to perform simple queries.
There is a slight issue with the response at the moment. Currently the json 
returns
{code}
 docs: [ 
{isbn: [ 3166313 ]},
{isbn: [ 2166313 ]},
{ EOF: true,RESPONSE_TIME: 4}
]
{code}
Im hoping to display the results as a grid but having the field return an array 
is in issue, ideally it would be good if we could return it as:
{code}
{isbn: 3166313 }
{code}



> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: Admin UI
>Affects Versions: 6.0
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Joel Bernstein (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15125219#comment-15125219
 ] 

Joel Bernstein commented on SOLR-8138:
--

I think based on the progress of the JDBC driver it makes sense to close this 
ticket. Rather then spending time adding SQL query capabilities to the Solr UI, 
users can connect to Solr using DBVisualizer or another JDBC client. So, I'll 
close this ticket out. 

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Upayavira (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985406#comment-14985406
 ] 

Upayavira commented on SOLR-8138:
-

Yes, whilst this is a decidedly cool feature, I'm not planning on adding it 
straight-away, and won't be adding it to 5x.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Kevin Risden (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985208#comment-14985208
 ] 

Kevin Risden commented on SOLR-8138:


It is a clone of the query tab. I agree the patch I posted isn't a long term 
solution. It was my quick patch to be able to share some of the Solr SQL 
querying with my team. I don't have time currently to look into integrating a 
better UI. I agree with you that it would be better to have a single query tab 
and not multiple places to go to query Solr.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Erick Erickson (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985383#comment-14985383
 ] 

Erick Erickson commented on SOLR-8138:
--

Do note that the SQL bits are Solr 6.0 _only_, can we disable/warn for 5x?

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Upayavira (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985066#comment-14985066
 ] 

Upayavira commented on SOLR-8138:
-

I haven't tried this yet, but from the source it looks like a clone of the 
query tab.

At present, the admin UI assumes knowledge of Solr, which is, in my view, 
unhelpful. I'd much rather move it towards something that people can use 
without Solr knowledge, but that can, if they want to, push it deeper. 

If you are game, I'd much rather review where SQL fits into an updated querying 
UI, and then work on that. SQL should, I'd imagine, just be one syntax used to 
query, the key user activity being 'querying'.

Does that sound reasonable?

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
> Attachments: SOLR-8138.patch
>
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Upayavira (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14946932#comment-14946932
 ] 

Upayavira commented on SOLR-8138:
-

[~joel.bernstein] I'm game, although I'm not yet very familiar with the SQL 
code. Does it run within SolrJ or directly inside a Solr instance?

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Joel Bernstein (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14946965#comment-14946965
 ] 

Joel Bernstein commented on SOLR-8138:
--

There is an http interface through the /sql handler. The result set is always 
JSON.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-8138) Simple UI for issuing SQL queries

[Joel Bernstein (JIRA)]

[ 
https://issues.apache.org/jira/browse/SOLR-8138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14946979#comment-14946979
 ] 

Joel Bernstein commented on SOLR-8138:
--

Here are the test cases for the /sql handler 
(https://svn.apache.org/repos/asf/lucene/dev/trunk/solr/core/src/test/org/apache/solr/handler/TestSQLHandler.java).
 

They use a SolrStream to send the request. Under the covers this is just an 
http request that returns json.

Because the SQL interface supports unlimited requests, we'll have to add a 
LIMIT clause to the SQL query as part of the UI.

> Simple UI for issuing SQL queries
> -
>
> Key: SOLR-8138
> URL: https://issues.apache.org/jira/browse/SOLR-8138
> Project: Solr
>  Issue Type: New Feature
>  Components: UI
>Affects Versions: Trunk
>Reporter: Joel Bernstein
>Priority: Minor
>
> It would be great for Solr 6 if we could have admin screen where we could 
> issue SQL queries using the new SQL interface.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org