Stack Overflow
Stack Overflow

Questions tagged [datastax-search]

15 questions
4
votes
0 answers

Using collection of UDTs vs Denormalized rows in Cassandra

Imaging we have 2 tables in RDBMS, INVOICE and INVOICE_LINE_ITEMS and there is a One-To-Many relationship between INVOICE and INVOICE_LINE_ITEMS. INVOICE (1) --------> (*) INVOICE_LINE_ITEMS Above said entity needs to be stored in Cassandra now,…
Arun Chandrasekaran
  • 2,370
  • 2
  • 23
  • 33
4
votes
2 answers

How to query '%' character using LIKE operator in Cassandra 3.7?

I use Cassandra 3.7 and have a text column with SASI index. Let's assume that I want to find column values that contain '%' character somewhere in the middle. The problem is that '%' is a command char for LIKE clauses. How to escape '%' char in a…
KMV
  • 51
  • 1
  • 3
2
votes
2 answers

Group by and Count(*) in Datastax Search/Solr

Hi we have a solr index with diff fields in it like business,businessType, regionName, StateName, ..... Now I need a solr query to get the number of business of type businessType ='event' group by regionName. if I want to write a sql query for this…
Uttkarsh Jain
  • 228
  • 1
  • 12
1
vote
1 answer

Best way to access Solr using gremlin in datastax graph

what is the best way to use Solr in Datastax graph database. so, currently we have 4 node cluster where 3 nodes are DSE and 1 node is serving as Solr instance. now, currently we are using Solr web service to integrate Solr in our backend code where…
Uttkarsh Jain
  • 228
  • 1
  • 12
1
vote
1 answer

How to analyze JSON fields in Datastax (DSE) Search

I would like to store JSON data in a column and have it analyzed by the DSE search as a document and not as a text field. I cannot coerce the JSON docs into a table because they do not follow a common schema (or any reasonably sized set of…
kostja
  • 60,521
  • 48
  • 179
  • 224
0
votes
0 answers

How to get total-count from Cassandra query with a LIMIT

I've DSE Search enabled on a cluster and have a Cassandra table with search-index. There is a requirement to support a non-primary-key based search from application. But the search is based upon the columns which are part of search-index. And I need…
ThrowableException
  • 1,168
  • 1
  • 8
  • 29
0
votes
1 answer

Solr: Query based on distance field

I want to query solr with distant parameter and the query should be in distance range. we have all the cities index in solr with their lat long and boundaries now i want to run a query from a lat long , i want all the cities which are after 50 KM…
Uttkarsh Jain
  • 228
  • 1
  • 12
0
votes
1 answer

data when using DSE Solr

From Cassandra Datastax documentation: https://docs.datastax.com/en/dse/5.1/dse-dev/datastax_enterprise/search/customizeSchemaSearch.html, it is written: Fields with indexed="true" are indexed and stored as secondary files in Lucene so that the…
ctamisier
  • 293
  • 1
  • 2
  • 9
0
votes
1 answer

Record created in Cassandra doesn't get indexed into Solr if it has a Map column which is not even indexed

I have a DSE Cassandra table which has a column of type Frozen< Map< text,text>>. When I tried indexing the table in DSE Search Solr, I didnot index the above Map column. A record with NULL Frozen< Map< text,text> gets indexed in Solr while the one…
Arun Chandrasekaran
  • 2,370
  • 2
  • 23
  • 33
0
votes
1 answer

DSE solr found rows with expired columns

running DSE 4.8.10 - I have 3 DSE Search nodes in my cluster, RF=3. I'm seeing some messages in system.log like those below. It seems they always come after a compaction. Is there a problem with the solr indexes or is there at least an explanation…
LHWizard
  • 2,121
  • 19
  • 30
0
votes
0 answers

Datastax 5.0.3 Solr node does not reindex just goes down

I am trying to reindex one of my indexes deleting old data and full-index. When i try to do this. The node immediately goes down, i cannot run nodetool commands such as nodetool status, nodetool tpstats.Also, i cannot see CPU, disk, network. The…
Yılmaz
  • 185
  • 2
  • 14
0
votes
1 answer

finds all the paths between a group of defined vertices in datastax dse graph

According to this the following query: g.V(ids).as("a").repeat(bothE().otherV().simplePath()).times(5).emit(hasId(within(ids))).as("b").filter(select(last,"a","b").by(id).where("a", lt("b"))).path().by().by(label) does not work in datastax graph…
user4808924
  • 31
  • 5
0
votes
1 answer

Getting error "Cannot achieve consistency level ONE" while trying to insert record in DSE Cassandra

I am using DSE Cassandra and want to use solr_query so created the Keyspace as follows: create keyspace demo with replication = {'class': 'NetworkTopologyStrategy', 'Solr': 3}; Created the following table: create table demo.onlinetransactions (…
Virendra
  • 101
  • 8
0
votes
1 answer

DSE create core with coreOptionsInline

I am trying to set docValues as true on all the fields on the table to enable Sorting. dsetool create_core keyspace.cf generateResources=true reindex=true coreOptionsInline=generate_docvalues_for_fields:'*' But I am seeing the below…
saaia aiaas
  • 51
  • 1
  • 6
0
votes
1 answer

Solr Query For Join two tables in Datastax DSE

Recently I am working with on a Cassandra database project in which I am using Solr with DSE for partial search. I read in some documents about join query by using Solr, but not able to get a clear idea. Can anyone tell me :- joining of two tables…
Big Data Guy
  • 218
  • 3
  • 12