FAQ Database Discussion Community


Elastic Search multi-value field aggregation

elasticsearch,aggregation,multivalue
My indexed documents have a schema: { ... 'authors': [{'first name': 'John', 'last name': 'Smith'}, {'first name': 'Mark', 'last name': 'Spencer'}] ... } I would like to search them and aggregate by the individual authors, so get a list with top authors which occurred in my hits. Terms aggregation seems...

ORDER BY multi-valued field in an Access query

sql,ms-access,union,multivalue
An intro about why I'm using multi-valued fields that you can skip if you want: I know that multi-valued fields are considered harmful, but I have a really good use for it. I have items that some are in Category A, some are in Category B, and some are in...

Build Alternative Data Structures with MultiValue Arrays

dictionary,data-structures,linked-list,multivalue,pick
I have been programming with PICK for a few months now, and am still adjusting to thinking of programming solutions that solely use multi-value arrays. PICK doesn't natively offer any other data structures for either database or in-memory operations * (ignoring dimensioned arrays for the sake of argument since they...

remove attribute in json that contain multivalue in asp.net c# before show it in gridview

c#,asp.net,json,gridview,multivalue
I'm newbie in asp.net c# . Iwant to show the json data into table with gridview .I have json data with this format : [{ "reviewerID": "A1YS9MDZP93857", "asin": "0006428320", "reviewerName": "John Taylor", "helpful": [ 0, 0 ], "reviewText": "last movement of sonata #6 is missing. What should one expect?", "overall":...

What Java data structure is best for two-way multi-value mapping

java,dictionary,data-structures,bidirectional,multivalue
I'm relatively new to Java and I have a question about what type of data structure would be best for my case. I have a set of data which are essentially key-value pairs, however each value may correspond to multiple keys and each key may correspond to multiple values. A...

How to write a function using arrays as input parameter in postgres 8.2

arrays,postgresql,multivalue,greenplum,postgresql-8.2
I am fairly new to Postgres and would like help with writing function that has an array as input parameter. I am using the function for a SSRS report and would like to add multiselect functionality CREATE OR REPLACE FUNCTION foo(facid bigint, dptname text[]) RETURNS SETOF tmpdb AS $BODY$ select...