Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
1.1.2
-
None
-
REHL 7
getsoftwareinfo Tue Mar 13 13:42:25 2018
Name : mariadb-columnstore-platform
Version : 1.1.2
Release : 1
Architecture: x86_64
Install Date: Wed 29 Nov 2017 11:33:08 AM EST
Group : Applications/Databases
Size : 113942794
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm
Build Date : Thu 16 Nov 2017 10:20:27 AM EST
Build Host : ip-172-30-0-125.us-west-2.compute.internal
Relocations : (not relocatable)
Vendor : MariaDB Corporation Ab
URL : http://mariadb.org
Summary : MariaDB-Columnstore softwareREHL 7 getsoftwareinfo Tue Mar 13 13:42:25 2018 Name : mariadb-columnstore-platform Version : 1.1.2 Release : 1 Architecture: x86_64 Install Date: Wed 29 Nov 2017 11:33:08 AM EST Group : Applications/Databases Size : 113942794 License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details. Signature : (none) Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm Build Date : Thu 16 Nov 2017 10:20:27 AM EST Build Host : ip-172-30-0-125.us-west-2.compute.internal Relocations : (not relocatable) Vendor : MariaDB Corporation Ab URL : http://mariadb.org Summary : MariaDB-Columnstore software
Description
I have a column store table with 600 columns which is populated every 15 min by some ETL process.
TBL: UUID, StartDate, Hour, Minute, << 600 columns >>
I created another table with same columns (without minute column) so that I could do hourly aggregation.
TBL: UUID, StartDate, Hour, << 600 columns >>
I created an event that does the aggregation (sum) from 15 min table to this hourly table. The information_schema.events says that it is triggered but there is no data in the hourly table.