使用DataStax Enterprise对Cassandra的正常查询工作,但不是solr_query [英] Normal Query on Cassandra using DataStax Enterprise works, but not solr_query
问题描述
我在使用solr_query处理程序在我的终端上的Cassandra中进行查询时出现了一个奇怪的问题。
当我对我的表执行正常查询时,没有问题,但是当我使用solr_query时,我得到以下错误:
无法完成请求:一个或多个节点不可用 / p>
遇到这个问题的其他人似乎无法对他们的数据进行任何查询,无论是否为solr_query。
任何人都可以给我一个关于我的solr节点问题的建议。
另外 - 我可以查询Solr管理页面,但就像我说的,我无法这样做在我的macbook的终端.....
这里是我使用的查询,供参考:
cqlsh:demo> select * from device WHERE solr_query ='id:[1 to 10000000000}' ;
更多信息:
这是我创建KEYSPACE的方式:
CREATE KEYSPACE demo WITH REPLICATION = {'class':'NetworkTopologyStrategy','Solr':1};
Solr核心:
bin / dsetool create_core demo.device generateResources = true reindex = true
执行nodetool环-h on the localhost and get this back:
数据中心:Solr
地址机架状态加载拥有令牌
127.0.0.1 rack1正常2.8 MB 100.00%-673443545391973027
正常.....这使我相信这是一个问题与实际的solr_query处理程序。
我还发现requestHandler在我的配置文件
$您的查询可能不正确: id:[1 to 10000000000}
p>
不可用的节点错误是不幸的是一个红色的鲱鱼,因为这是方式Thrift(Cassandra 2.0中的cqlsh是基于)翻译给定的错误,而你应该得到一个如果您使用基于本机协议的驱动程序重复相同的查询,则会产生有意义的错误。
I am having a strange issue occur while utilizing the solr_query handler to make queries in Cassandra on my terminal.
When I perform normal queries on my table, I am having no issues, but when I use solr_query I get the following error:
Unable to complete request: one or more nodes were unavailable.
Other individuals who have experienced this problem seem unable to do any queries on their data whatsoever, whether or not it is solr_query. My problem only persists while using that handler.
Can anyone give me a suggestion for what the issue may be with my solr node.
ALSO -- I can do queries off of the Solr Admin page but like I said, am unable to do so on a terminal within my macbook.....
Here is the query I used, for reference:
cqlsh:demo> select * from device WHERE solr_query='id:[1 to 10000000000}';
More info:
This is how I created my KEYSPACE:
CREATE KEYSPACE demo WITH REPLICATION = {'class':'NetworkTopologyStrategy', 'Solr':1};
This is how I created the Solr core:
bin/dsetool create_core demo.device generateResources=true reindex=true
Performed a nodetool ring -h on my localhost and got this back:
Datacenter: Solr
Address Rack Status State Load Owns Token
127.0.0.1 rack1 Up Normal 2.8 MB 100.00% -673443545391973027
So it appears my node is up and normal..... Which leads me to believe it is an issue with the actual solr_query handler.
I also found the requestHandler within my config file
Your query isn't probably correct: id:[1 to 10000000000}
The "unavailable nodes" error is unfortunately a red herring, as that's the way Thrift (which cqlsh in Cassandra 2.0 is based upon) translates given errors, while you should get a more meaningful error if you repeat the same query with a driver based on the native protocol.
这篇关于使用DataStax Enterprise对Cassandra的正常查询工作,但不是solr_query的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!