11 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
55
views
Column-wise aggregation of array vectors :calculating mean per "level" for bid/ask data
I am currently working on a data analysis task in DolphinDB where I need to perform column-wise aggregation on array vectors that store level - 10 bid/ask data. Specifically, I have data for bid ...
-1
votes
1
answer
266
views
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 ...
2
votes
1
answer
133
views
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:
...
1
vote
1
answer
950
views
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 ...
1
vote
2
answers
307
views
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 ...
1
vote
1
answer
76
views
Oracle 10g: howto aggregate by date differences
hi have te following data:
KEY VALUE TIMESTAMP
-------------- ---------- -----------------------
0F8CE962 900 20141124054503
0F8CE962 ...
4
votes
2
answers
1k
views
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<ContentProviderOperation> ops = new ArrayList<ContentProviderOperation>();
ops....
0
votes
1
answer
502
views
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)
...
1
vote
1
answer
6k
views
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 ...
1
vote
1
answer
203
views
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 ...
26
votes
1
answer
1k
views
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 ...