Questions tagged [column-aggregation]
10 questions
26
votes
1 answer
Different inheritance types in the same schema
I'm using Doctrine 1.2 on a symfony project,
and I'm considering mixing concrete and column aggregation inheritance types in my schema:
column aggregation lets me query in a parent table and get both parent and child records, while concrete…
greg0ire
- 22,714
- 16
- 72
- 101
4
votes
2 answers
Automatic contact aggregation not working when inserting a new contact
I'm inserting 2 times the same contact to the Android emulator (2.3.3) with the following code:
ArrayList ops = new…
nr1
- 777
- 3
- 12
- 31
2
votes
1 answer
How to use kdb+ to track an arbitrary number of IOT scalar streams?
I am trying to use kdb+ to capture and do aggregations on a number of sensory streams collated from iot sensors.
Each sensor has a unique identifier a time component (.z.z) and a scalar value:
percepts:([]time:`datetime$(); id:`symbol$();…
Kyle Durnam
- 87
- 6
1
vote
1 answer
is there a way to add a summary row to jqgrid treeview
i am using jqgrid with the treegrid view and most of the columns are numbers that are aggregated up the tree. The one missing piece is having a total row to aggregate the top level hierarchy. Is there something built into jqgrid to support this or…
leora
- 188,729
- 360
- 878
- 1,366
1
vote
1 answer
Doctrine: Models with column_aggregation inheritance appear twice in SQL
Has anyone noticed this?
Whenever a model uses column_aggregation (inheritance), the schema.sql has 2 CREATE TABLE commands, one creates the basic table, and the other (apart from fields) adds an index on the inheritence column
CREATE TABLE Prop (id…
Prasad
- 1,822
- 3
- 23
- 40
1
vote
1 answer
Why is HBase full scan and aggregation slower than parquet, despite of also being columnar database?
I've been trying to use the "right" technology for a 360-degree customer application, it requires:
A wide-column table, each customer is one row, with lots of columns (says > 1000)
We have ~20 batch update analytics jobs running daily. Each…
Tung Vs
- 113
- 10
1
vote
2 answers
aggregate values of one colum by classes in second column using numpy
I've a numpy array with shape N,2 and N>10000. I the first column I have e.g. 6 class values (e.g. 0.0,0.2,0.4,0.6,0.8,1.0) in the second column I have float values. Now I want to calculate the average of the second column for all different classes…
Michael Hecht
- 2,093
- 6
- 25
- 37
1
vote
1 answer
Oracle 10g: howto aggregate by date differences
hi have te following data:
KEY VALUE TIMESTAMP
-------------- ---------- -----------------------
0F8CE962 900 20141124054503
0F8CE962 900 20141124082431
0F8CE962 …
morbidflame
- 11
- 1
0
votes
1 answer
Doctrine Column-Aggregation Inheritance
I'm trying to implement Doctrine column-aggregation inheritance
I copied the Yaml structure from the Doctrine guide and paste it in my schema.yml file:
Entity:
columns:
username: string(20)
password: string(16)
created_at: timestamp
…
tamir
- 3,207
- 2
- 33
- 51
-1
votes
1 answer
How to transpose Columnar data into Row only 3 columns (Month )and Map the rest to them (NO GROUPING) using Azure DF/Synapse Pipeline/ SQL query
Actual Header from CSV file
Supercategory Segment Subsegment Class Total Property (Brand + License) Corporate Manufacturer Manufacturer Brand License Licensors Model Number Item Description Jan 2022 Feb 2022 Jan 2022 …
Saranya Gogineni
- 1
- 1